Software

Ask something
Discussion Locked

VB commands unavailable to Access 97 DB

0 helpful
7 replies

by usarmydi

Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

For example:

fs.getfile "C:\" & Trim(me!file) & ".doc"

Errors out. Have uninstalled/reinstalled Office 97 Prof. Have downloaded all available updates. Assume I may need an "ADD-IN" but don't know which one. Any help?

7 replies

by usarmydi

You are correct. I had a lapse in typing skills. That, however, is not the problem. The actual code is correct. On some machines, the DB runs fine. On others, the VB commands are unavailable. Same brand/model PC. Same OS. Same Office 97 Pro CD. Same everything, basically.

by usarmydi

Here's the code break and error:

Compile Error:
Can't find project or library.

Breaks on the VB functions:

Trim
Format

by drinkin and thinkin

I don't know if this is the cause of your problem but it may give you somewhere to look.

According to M$:

CAUSE
Your database contains a reference to a database, type library, or object library that is marked as "Missing:" in the References dialog box.

RESOLUTION
Follow these steps to remove the missing reference:

Open your database.
Open a module in Design view.
On the Tools menu, click References.
Click to clear the check box for the type library or object library markedas "Missing:."

An alternative to removing the reference is to restore the referenced file to the path specified in the References dialog box. If the referenced file is in a new location, clear the "Missing:" reference and create a new reference to the file in its new folder.

This discussion is closed to new replies.