Format command not working after upgrade

[Guest]

I have an old Access 97 database that has the VBA command Format( aDate,
"ddd") that runs on one of my machines. And it used to run on my customer's
machines. But when they got their PCs replaced, adding a newer version
of Office, that command didn't work any more.

I went on their PCs and created a brand new database db1.mdb in Access97 and
found that the command Format( aDate, "ddd") does work, but not on the old
database when they open it up.

I checked the References and all matched, except for the MS CDO 1.2 Library,
which I then replaced with MS CDO for NTS (I've not tested this one yet).

But the code for the Format command resides in VBA332.DLL. I checked the
date of my VBA332.DLL and it was 7/10/1997 11:00 PM and theirs was 7/11/1997
12:00 AM. So I copied mine over into one of their PC. But that didn't
help- still Format was not recognized as a command.

Any help is appreciated.

Thanks.

 

[Guest]

Hi.

Running an Access database on a computer with a different installation
configuration can mess up the References, even though you may not see the
"Missing: ReferenceNameblahblahblah" notice when you open the References
dialog window. Access complains that a VBA function is "not defined" even
though you can see that the function is right there, plain as day. One of
the references listed _after_ the VBA library is usually to blame, but Access
doesn't always point this out to you.

On your customer's computer, open the problem database, then open the
References window, write down the path and file name for one of the
References, and then delete this Reference. (That MS CDO reference sounds
like a good candidate.) Close the References window, then open it again.
Add the reference that you just deleted. If you see a "Missing:
ReferenceNameblahblahblah" notice, then add that reference, too, and then
close the References window once again. Try to compile the code. If it
compiles without errors, then you've fixed the hidden missing references
problem.

HTH.

Gunny

See http://www.QBuilt.com for all your database needs.
See http://www.Access.QBuilt.com for Microsoft Access tips.

(Please remove ZERO_SPAM from my reply E-mail address, so that a message
will be forwarded to me.)

- - -
When you see correct answers to your question posted in Microsoft's Online
Community, please sign in to the Community and mark these posts, so that all
may benefit by filtering on "Answered questions" and quickly finding the
right answers to similar questions. Remember that the best answers are often
given to those who have a history of rewarding the contributors who have
taken the time to answer questions correctly.