Variant data type

[Wantula]

Im trying to assign auto date(current date) to the date field.However
everytime I do this, there is an error, saying im trying to assign a null
value to the variable that is not a variant data type.Im using: =date(). Is
there a way I can change the date variable to a variant datatype.

 

[John Vinson]

Im trying to assign auto date(current date) to the date field.However
everytime I do this, there is an error, saying im trying to assign a null
value to the variable that is not a variant data type.Im using: =date(). Is
there a way I can change the date variable to a variant datatype.

There are a couple of possible causes of this error:

- Check your References. Open the VBA editor and select Tools...
References from the menu. If one is marked MISSING, many things will
get messed up, calls to Date() amongst them. Uncheck the checkbox by
the missing reference, and (if it's needed) recheck it. Close and open
Access and see if the problem is resolved. If not, doublecheck that
the file referred to by the reference does in fact exist in the
pointed-to directory.

- If you have a field or a control named Date, Access may be getting
confused. Rename it.


John W. Vinson[MVP]
Join the online Access Chats
Tuesday 11am EDT - Thursday 3:30pm EDT
http://community.compuserve.com/msdevapps