Date() is starting to not work

  • Thread starter Thread starter Pepper
  • Start date Start date
P

Pepper

I have a form that writes information to a table.

There is a field called "Entry_date" that has a default
value in the data table as "=Date()".

For the past year I have had no problems with this table
but in the past few days, I have started to see the
Entry_date field empty. It seems to be localized to
certain users but these users have not had problems in the
past.

In addition, and maybe this is unrelated, some of the
users are getting errors on the reports. They work fine
in my building but the same MDE file presents errors in
the other building (I have not been over there to see what
the problem might be.)

The date problems could also be from people in another
physical location (Tennesee vs. Texas).

Any help would be appreciated, not sure what to be looking
for.
 
Probably something has happened to mess up the references. Open VBE and
select Tools | References to see if any are marked as missing.
 
Likely a reference problem. If you are using a97, then you also need to
ensure that they all are running the save version of JET (you did not
mention what version you are running).

Anyway, to fix your problem, check out:

Allen Browne
http://users.bigpond.net.au/abrowne1/ser-38.html

Doug Steele:
http://members.rogers.com/douglas.j.steele/AccessReferenceErrors.html

Peter Walker:
http://www.papwalker.com/dllhell/index-page2.html


MsKb Articles: 310803, 208218, 209849, 286300

ACC2000: How Access 2000 Resolves Visual Basic for Applications References
http://support.microsoft.com/default.aspx?scid=kb;en-us;248941

ACC2000: How to Resolve Reference Issues in an Access Database
http://support.microsoft.com/default.aspx?scid=kb;en-us;310803
 
Back
Top