Now() function no longer works when computer is upgraded to Vista

  • Thread starter Thread starter Rosemary
  • Start date Start date
R

Rosemary

I have a database that was developed in Access 2007 that I am using the Now()
function to get the date and format it into "dd mmm yyyy" format. It's at
the top of reports, etc. It was working just fine until our organization
pushed out Vista, now I get the famous ?Name in place of the date.
I thought it was Vista, so I took an old database that was Access 2000 and
converted it to 2007 on my Vista machine, then opened it up and the Now()
function is still working fine in it.
Is it a reference or something I'm missing? The code is as follows:
"As of " & Format(Now(),"dd mmm yyyy")

Any help is appreciated.
 
On Wed, 18 Mar 2009 06:19:03 -0700, Rosemary

Why do you have a question mark at the end of your "Is it a
reference..." sentence? Code window > Tools > References and you'll
know for sure.

-Tom.
Microsoft Access MVP
 
I'd already looked at the references in both databases and they had the same
ones, but the new database had several more checked than the old database.
From your remark, I tried removing the extra ones and that seemed to work.
It was either the VBScript Regular Expressions or the MS ADO Ext 6.0 for DDL
and Security.
 
Don't expect it to be a specific reference that causes the problem.

The Now() function is actually contained in the VBA library, which is always
the last reference checked. If any reference is bad, Access is stopped
before it gets to the VBA library.
 
Back
Top