I keep getting an error function not avaliable when trying to run a certain statement in Access.

Any ideas?

Sounds like you have a Missing Reference (http://www.access-programmers.co.uk/ubb/Forum1/HTML/001587.html)

its a dcount function thats causing the error and also some vba behind a button.

Any idea what reference is needed?

((tblMain.[call back])=date()) and ((tblmain.userID)=Currentuser()))

This is a copy of the statement that is displayed in the error box with the function not avalable message. Its been working fine until today and no changes have been made to the database.

Mike posted a hyperlink to a forum topic that contains the answer you need.

Checked all this and everything is OK.

The tick box is there in VBA and the vba332.dll exists in the same directory for everyone.

If I re-install the full copy of access 97 over the top of the original everything is ok.

Any more ideas!

Have you tried copying and renaming the form,remember to compile and save before opening the form.

Don't think copying and renaming the form will make any difference.

The database is constructed with a fron and backend the users see the fron end with the forms etc which sits on individual pc's. This then has links to the data in the backend.

Some copies work some don't. The copies that don't have been working fine in the past.

Try changing Date() to Now()

Are there no references at all marked as missing? (It can upset the proper function of all sorts of things, not just the functions that reside in the missing library)

There is something listed as missing.

Can't read it but it says something about common, sorry can't read the rest.

It also says that on pc's that aren't having problems.

harrisw, If you don't believe Mike and Rich about the references, look up the problem yourself in the microsoft knowledge base. They'll tell you the same thing. FIX the broken reference!
http://search.support.microsoft.com/kb/c.asp?fr=0&SD=GN&LN=EN-US

Fixed.

Many thanks