After update 10-31-07
I'm using an After Update event on a form to update one field with the
current date when a checkbox is checked, but the date doesn't display until I
scroll down the form. Is there some way to get the date to display right
after the box is checked (or at least once the next record is selected)?
Message posted via AccessMonster.com
Sounds like you have a control that has a Name that is different from the
name of the date field.
In the AfterUpdate code, use the name of the control,..."New" button activates send/receive
When I click the Send/Receive button, nothing happens.
However, when I click the "New Message" button, in comes
all my new messages. Also, the auto Send/Receive under
Options (every 1 minute) is not working at all.
Any thoughts on how to fix this?
...When is Microsoft coming out with updated version of Publisher?
I've been using Pubisher since 1997 and it's great...but now it's almost FOUR
years old with no no version! More graphics, more WordArt options, that
would be nice. When are we going to see a Publisher 2006-7??????
There is a new version of Office being beta tested now with an approximate
release date of Spring 2007.
(No clue about the amount of clipart or WordArt. Sorry)
MVP Microsoft [Publisher]
"Nancy O'Brien" <Nancy O'Brien@discussions.microsoft.com> wrote in message
news:005128ED-EF3D-4ADA-B02D-B5EB6790BFC0@microsoft.com.....Creating Dialog Pointer with new, causes Exception
I've written an MFC app, which has a tabbed interface. When it starts
up, it checks my registry key, to determine how many tabs it needs, it
then creates each tab, and puts a custom non modal, child dialog on
The problem is, in release mode, it can only create the first dialog,
the second one causes a memory exception.
It *looks* like MFC doesnt like me trying to initialize a pointer like
so, when that pointer is NULL.
m_pDialogs[i] = new CMyDialog;
Thing is, isn't that the whole point of the new operator? And malloc
for that matter?
The only difference, th...2 updates won't install
Server 2003 SP2 updates KB973354 and 958469 both get error 0x800F0102. What
can I look for ?
Dave Mc wrote:
> Server 2003 SP2 updates KB973354 and 958469 both get error
> 0x800F0102. What can I look for ?
Gone through this yet?
How To Ask Questions The Smart Way
...Seeking new Bank Recommendation
I am currently a BankOne customer, but am dropping them due to the new ATM
service fee. BankOne now charges $1.50 per non-BankOne ATM transaction -
this is in addition to what the local bank that runs the ATM charges. I
travel A LOT and am always needing cash from a non-BankOne ATM.
Unfortunately, BankOne is also the dominant bank in my area - ATMs in
Walgreens, Dominicks, lots of branches. I am going to stand on principle and
cancel my accounts w/ BankOne however.
I was a Preferred Checking customer w/ BankOne for 10 years (no fees for
anythign if you kept a $2500 minimum balance - maybe it ...Permissions after 12.1.2 update
Operating System: Mac OS X 10.5 (Leopard)
Question. Not sure, but I after running the 12.1.2 office 2008 updater, I noticed this when repairing permissions using disk utility
Permissions differ on "Library", should be drwxrwxr-t , they are drwxrwxr-x .
Now, I also noticed other disk utility repair permissions that take place after the weekly overnight sripts run. I am just trying to figure out if running the office 2008 updater 12.1.2 could generate the permissions fix reported above. I installed this on 2 exactly the same computers, and didn't g...HowTo disable cell reference update
I want to disable cell reference updates when I am inserting a row.
My chart has series data in A2..A7.
After row insert with MoveDown at row 2 the references are updated to A3..A8
How do I preserve the original cell refernce?
...How to determine whether update rollup is installed
I've just installed the update rollup on test machines both for client
and server. However there's no obvious change - even the build version
numbers shown on the web interface remain the same. Is this to be
expected? How can I tell that the update is installed successfully?
Not sure why they didn't update the version number. On the server, go to
add/remove programs and check the 'show updates' checkbox at the top. then,
under the Microsoft CRM Server, you should see 'Update Rollup 1...'
"Tom" <thisisme_ithink@yahoo...New Folder
Operating System: Mac OS X 10.6 (Snow Leopard)
How do I open a new folder to organize my documents? The document list in Word2008 for Mac is not like Word I've used before.
Your description is very minimal at best, so I assume you are talking
about the Save dialogue, and the fact that you cannot see all the
folders in this dialogue, but merely a dropdown list with the most
recently used folders. Click on the blue square next to the field in
which you enter the document name, with the tiny triangle that is
pointing down, and the dialogue will ...New to formulas
I need help with formulas, or a math function.
Bacically what I need to do is have Cell A2 subtract Cell A1 and be
outputted to Cell B2.
I have no idea how to start this.
"Money 2006" <Money2006@discussions.microsoft.com> wrote in message
>I need help with formulas, or a math function.
> Bacically what I need to do is have Cell A2 subtract Cell A1 and be
> outputted to Cell B2.
> I have no idea how to start this.
> Thank You
In cell B2 type "=A2-A1" (without...Subforms won't refresh after new record 11-17-09
Access 2003, XP Pro
I have a main form with two separate subforms. I view various records by
clicking on some list boxes.
To add a new record, I select Records, Data Entry.
(1) Make a selection in a combo on the main form.
(2) Make a selection in a combo and enter some text in a textbox on subform1
(3) Make a selection in a combo on subform2
Subform2 has some code on the After Update event that saves the new record
and goes to a previously selected record in cbo1 on the main form (cbo2 has
code on the After Update event to go to that record).
Here's the cod...Updating links
In one of our office spreadsheets, everytime it is opened it asks do you
want to update cells from another spreadsheet. I believe when this
spreadsheet was set up, a work sheet was copied from another spreadsheet. I
thought that all the references to that other spreadsheet had been removed.
Is there anyway to identify (other than manually checking each cell) which
cell has a formula linked to the old spreadsheet.
Thanks in advance,
Download and install Bill Manville's FindLink add-in, which you can find
In article <bYd1d.27315$Z14.90...Check for Values
I have 2 tables, requirements and stock on hand. In the requirement
table, I have a part number, qty and due date and a related record in
the stock on hand table using part number showing current stock. My
question is can I use a query (and how!) to tell me
a) I have enough stock to fulfil the requirements and
b) If not at what date will I not be able to fulfil the requirements
and by how many?
Have been working on this for a while, and cant work it out
You are there, we are not ... the following may not fit your situation ...
If you have a [Par...Update a radio button by combobox selection
In a VS2008 VB project, I have a combobox that gets its value from a table
with three columns. I want to display one column in the combobox, write the
value of the second column back to a different table, and I want to change
the value of a radio button (on the same form as the combobox) based on the
value of the third column of the selected record.
I'm setting the ComboBox.Text value to be the first column,
the ComboBox.SelectedValue to be the second column, but how would I change
the radio buttons in the most efficient way?
Thanks in advance,
Wrong g...Update cell based on date range
Hey guys! I was wondering if I could get some help here. I would lik
to update a cell based on a date range. For example, I would like t
update the value of a cell to the value of another cell if the curren
date is between July 1st and July 10th. However, if the date i
outside the date range, I want the value for that cell to not b
updated, and be the previous value. Can anyone give me an example a
to how I would do this? Thanks!!
deversole's Profile: http://www.excelforum.com/member.php?action=geti...Check if data has already been formatted.
I have a sub() as part of a larger set of macros.
This particular sub() will take the raw data pulled from an in-house
reporting system and format it to suit our needs (adding a couple of columns
with formulas to facilitate pivot table creation).
This is the code as I have it so far:
Application.ScreenUpdating = False
ActiveWindow.DisplayGridlines = False
Dim DataWks As Worksheet
Dim LastRow As Long
Dim LastCol As Long
' Set the DataWks variable
Set DataWks = Worksheets("Data")
...How to add new entity?
I'm now researching the customization abilities of MS CRM 1.2.
So I have a small task, which I'm not able to accomplish with SDK.
The main question is how to add additional entity to CRM?
I need to add entity "Pets", and dictionary "PetTypes".
Pets should be linked with Contacts (1:M).
Pets should have 3 attributes:
- Name (string of 150 chars),
- Type (value from PetTypes dictionary),
- Description (string of 1000 chars)
PetTypes should have 3 entries: "Cat", "Dog" and "Parrot"
I expect that i...A first look at the new Office Snapin for MSCRM
This posting is provided "AS IS" with no warranties, and confers no rights.
Use of any included script or code samples are subject to the terms
...Vendor transactions and checks
I'm trying to create a vendor payment report from my program. From which
tables I can get the vendor payable transaction information??? I also need
to know whether there is a check aleady issue to a transaction.
...Keeping a table in a form editable and checking that fields are filled in before allowing a save
Firstly apologies if this is the incorrect forum but I was looking for
a general word forum and could not find one. Please point me to one if
I am trying to create a form where I want to specify what items need
to be filled in. (Review minutes from design reviews). I want to make
certain fields mandatory like the date, attendees and check list used
and want to block saving of the document with a warning until they are
filled in. Is there a way of doing this?
Also as a part of the review actions are filled in to a table.
depending on how many actions there are the table...Setting Outlook settings to new server
We are in the process of moving mailboxes to a new server. Is there a utility
or ad policy to automatically configure outlook to point to the new exchange
server? Instead of manually configuring the users outlook profile.
On Tue, 21 Nov 2006 11:15:01 -0800, Rich
>We are in the process of moving mailboxes to a new server. Is there a utility
>or ad policy to automatically configure outlook to point to the new exchange
>server? Instead of manually configuring the users outlook profile.
If you are moving the mailboxes in the same org vi...Email accounts are not created for new user
I had a severe system crash several days ago because of bad memory in my
domain controller (Server 2003 R2)/Exchange server 2003 (small site - no
extra systems). I had to reinstall Exchange 2003 and reload the exchange
store from backup. For existing users everything works great. Everybody can
send and receive email, the calender works correctly, etc. OWA works.
However, when I create a new user account in Active Directory Computers and
Users, the account is created and the new user can log onto a system.
However, Outlook 2003 cannot be configured to use the exchange server. In
t...Error creating new task
"Could not complete operation. One or more parameter
values are not vaild"
...New message opens up behind outlook window
Everytime I click new in my inbox to open a new message,
the new message pops up behind the main oulook window.
does anyone know how to make this stop?