Date Field Error

[Guest]

I recently upgraded to Windows XP with Access 2003 - I have a macro that when
I enter a new record in the form it auto fills the date field with todays
date. When using my Windows XP PC - this macro errors out. It works great
on my Windows 2000 pc.

Erika

 

[Al Campagna]

Erika,
Why don't you just make the Default Value for that field...
Date()
Any new record will have that date entered.
Shouldn't need a macro to do that...

--
hth
Al Campagna . Candia Computer Consulting . Candia, NH USA
Microsoft Access MVP
http://home.comcast.net/~cccsolutions

"Find a job that you love, and you'll never work a day in your life."

 

[Guest]

That would work for the first date field. I also have a priority field and
when the priority number changes I have a date field that changes to display
the date that the change was made. I am receiving the same error, is there a
better way to set that field up?

 

[Al Campagna]

Erika,
We'll need more detail...
*Please post your ERROR message, and describe what your doing in detail, using field
names, events, and all the macro steps and arguments.

Some things to try in the meantime...
1. Have you tried to rewrite the macro in 2003... just in case there might be a
difference between the two version (I'm not aware of any in regard to Date handling) That
would only take a minute to try, if you haven't already.
2. Have you tried using an event procedure instead?
Private Sub PriorityNumber_AfterUpdate()
SomeDateField = Date()
End Sub
3. Just for a shot in the dark... use Tools/Options/General and UNcheck all AutoName
options.
4. Don't name any date field "Date"... use MyDate or PriorityChangeDate or etc...

Please reply again with the detailed info requested...
If still no luck, you could send me the zipped .mdb file/s via my website (Contact)
below, with a note as to what form and what control the macro is against.
Put "newsgroup" in the subject. (Confidentiality assured-no charge)
--
hth
Al Campagna . Candia Computer Consulting . Candia, NH USA
Microsoft Access MVP
http://home.comcast.net/~cccsolutions

"Find a job that you love, and you'll never work a day in your life."