D
DSmith
Anyone know why Date() does not work in 2007 Access and what has replaced
it? Thanks!
it? Thanks!
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
R
ruralguy via AccessMonster.com
I don't have ac2007 but I suspect Date() works as it always has. Do you have
any reference problems?
http://www.accessmvp.com/djsteele/AccessReferenceErrors.html
Does it throw an error?
any reference problems?
http://www.accessmvp.com/djsteele/AccessReferenceErrors.html
Does it throw an error?
W
WesT
I haven't really looked into it but it returns the name? error
U
UpRider
I've been using Access 2007 heavily for a couple of months and not
experienced that problem.
In what fashion do you get an error?
UpRider
experienced that problem.
In what fashion do you get an error?
UpRider
R
ruralguy via AccessMonster.com
You didn't name one of your functions or sub's or modules Date did you?
Here's some links if you didn't already have them.
Special characters that you must avoid when you work with Access databases
http://support.microsoft.com/?id=826763
List of reserved words in Access 2002 and Access 2003
http://support.microsoft.com/?id=286335
List of Microsoft Jet 4.0 reserved words
http://support.microsoft.com/?id=321266
Here's some links if you didn't already have them.
Special characters that you must avoid when you work with Access databases
http://support.microsoft.com/?id=826763
List of reserved words in Access 2002 and Access 2003
http://support.microsoft.com/?id=286335
List of Microsoft Jet 4.0 reserved words
http://support.microsoft.com/?id=321266
I haven't really looked into it but it returns the name? error
[quoted text clipped - 3 lines]I don't have ac2007 but I suspect Date() works as it always has. Do you have
any reference problems?
W
WesT
On mine, I just had an access2003 database that I opened but I had not
converted it. I was just trying out 2007 and wanted to see it in action.
Havent used it since(work still uses 2003)
converted it. I was just trying out 2007 and wanted to see it in action.
Havent used it since(work still uses 2003)
U
UpRider
In a database still in A2003 format running under A2007, make sure you have
these references:
Visual Basic for Applications
Microsoft Access 12.0 Object Library
Microsoft DAO 3.6 Object Library
Microsoft Office 12.0 Object Library
Microsoft Activex Data Objects 2.8 Library
I think this will fix things up.
Uprider
these references:
Visual Basic for Applications
Microsoft Access 12.0 Object Library
Microsoft DAO 3.6 Object Library
Microsoft Office 12.0 Object Library
Microsoft Activex Data Objects 2.8 Library
I think this will fix things up.
Uprider
D
DSmith
My database is still in A2000. I'm using =Date() in a text box on a report
to just give a current date. I get the error ?name.
to just give a current date. I get the error ?name.
B
BruceM
What was the result of your checking references? How about the naming
issues that have been mentioned (such as whether there is a field named Date
anywhere)?
issues that have been mentioned (such as whether there is a field named Date
anywhere)?
D
DSmith
There's not a field named Date. It works fine in A2003 just not A2007. We've
move one computer over to A2007 to see what issues we'll have to deal with
this is one of them.
move one computer over to A2007 to see what issues we'll have to deal with
this is one of them.
B
BruceM
And the references were OK?
DSmith said:There's not a field named Date. It works fine in A2003 just not A2007.
We've move one computer over to A2007 to see what issues we'll have to
deal with this is one of them.
D
DSmith
I'm sorry, I guess references just went right over my head. I checked them
and the utility.mda was missing so I deleted the reference and now
everything works like it should. So what did I delete? What is utlility.mda?
Do I need it? Thanks so much.
and the utility.mda was missing so I deleted the reference and now
everything works like it should. So what did I delete? What is utlility.mda?
Do I need it? Thanks so much.
B
BruceM
I think I more or less understand what references are, but I can't really
explain them coherently. I do know that if built-in functions produce the
#Name error it is often a references problem. Doug Steele's article on the
subject (I have added the link again) covers the subject in more detail than
I knew existed, but is clearly written for all that.
http://www.accessmvp.com/djsteele/AccessReferenceErrors.html
explain them coherently. I do know that if built-in functions produce the
#Name error it is often a references problem. Doug Steele's article on the
subject (I have added the link again) covers the subject in more detail than
I knew existed, but is clearly written for all that.
http://www.accessmvp.com/djsteele/AccessReferenceErrors.html
D
DSmith
Read that article...a bit more info than this brain can understand. I guess
I'll see if A2007 will miss utility.mda. Thanks for all your help!
I'll see if A2007 will miss utility.mda. Thanks for all your help!
B
BruceM
Glad for the chance to contribute from time to time. I wish I could claim
credit for finding the link, but another person in the thread posted that.
credit for finding the link, but another person in the thread posted that.