Functions stopped working

L

lfstevens

I've been using Access 2003 for awhile, and have embedded standard and
self-written functions in my SQL statements.

Then they stopped working.

Browsing the boards, I learned that this happens and that I should
reinstall. In succession, I tried:

- repairing the install
- reinstalling
- deinstalling and installing

Functions still don't work.

Thanks for your insights!
 
L

lfstevens

The message is: "compile error in query" followed by a chunk of the
sql. I have dozens of queries which died all at once.
 
R

Roger Carlson

This is sometimes an indication that there is a problem with your
References. In any code window, go to Tools>References and see if any have
MISSING next to it. Often, just unchecking this reference solves the
problem. In other cases, you may have to re-install the reference.

--
--Roger Carlson
Access Database Samples: www.rogersaccesslibrary.com
Want answers to your Access questions in your Email?
Free subscription:
http://peach.ease.lsoft.com/scripts/wa.exe?SUBED1=ACCESS-L
 
L

lfstevens

Nothing is marked missing. Online help says that "Visual Basic objects
and procedures" should be checked and that you can't uncheck it. I see
no such item in my references dialog. Instead, "Microsoft Access 11.0
object library" is present, checked and un-uncheckable.

Also, there are a total of 6 "Visual Basic For Application" entries,
referencing various dlls. Only 1 of them is checked. The dialog box is
too narrow to show the full path and file name for that entry.
 
R

Roger Carlson

It still feels like a reference problem. You might want to take a look at
these links:
http://allenbrowne.com/ser-38.html
http://www.accessmvp.com/djsteele/AccessReferenceErrors.html
(One suggestion from Doug Steele's link might help: If none have "MISSING:",
select an additional reference at random, back out of the dialog, then go
back in and unselect the reference you just added. If that doesn't solve the
problem, try to unselect as many of the selected references as you can
(Access may not let you unselect them all), back out of the dialog, then go
back in and reselect the references you just unselected. (NOTE: write down
what the references are before you delete them, because they'll be in a
different order when you go back in)

http://support.microsoft.com/default.aspx?scid=kb;en-us;283115

Sorry I couldn't help more.

--
--Roger Carlson
Access Database Samples: www.rogersaccesslibrary.com
Want answers to your Access questions in your Email?
Free subscription:
http://peach.ease.lsoft.com/scripts/wa.exe?SUBED1=ACCESS-L
 
Top