Hi!

I use Date() and IsDate() functions to determine default values in Access 

solution. I made this solution in a desktop where I have Windows 2000 and 

Access 2000. There everything works fine. When I use it on a desktop with 

Windows 98 and Access 2000, it says that "defined function can not be used 

in this clause".

I have tried to check if there is a library or reference missing but they 

seem to be ok (I understood that VBE6.DLL would be the library required).

I have to copy my solution to our customers servers which often are win98 

and access 2000, so it would help me a lot if somebody has any idea of why 

theese functions doesn't allways work.

Thanks,

Sanna

Hi Sanna,



You can try registering the DAO360.dll file. Sometimes the built-in 

functions like Date() will not work if this file isn't not registered 

correctly. To register the file go to

Start > Find Files or folder > Search for dao360.dll regsvr32.exe.



When you have found the 2 files drag the dao360.dll and drop it on 

regsvr32.exe



You should get a message saying "DLLRegister Server in "<pathname>" 

Succeeded.



Now try and run your application.



Good Luck and let me know how it turns out.



Nancy

Hi Nancy,



I did what you told me and I got that succeeded-message. However, when I 

tried to use the app again, it still gave me the same error message:



"The defined function can not be used in this clause.



- You used DoEvents-, LBound-, UBound-, Spc-, or Tab-function in the 

clause.

- You used SQL-accemblyfunction (e.g. count) in the design view of the 

table or in counted object or field." (I'm not sure if I translated this 

last sentence correctly)



Do you have more ideas?

Thank you,

Sanna



> Hi Sanna,

> 

> You can try registering the DAO360.dll file. Sometimes the built-in 

> functions like Date() will not work if this file isn't not registered 

> correctly. To register the file go to

> Start > Find Files or folder > Search for dao360.dll regsvr32.exe.

> 

> When you have found the 2 files drag the dao360.dll and drop it on 

> regsvr32.exe

> 

> You should get a message saying "DLLRegister Server in "<pathname>" 

> Succeeded.

> 

> Now try and run your application.

> 

> Good Luck and let me know how it turns out.

> 

> Nancy

I have found that the system date format can sometimes affect program date

logic.



Walt