Date field

[Guest]

Recently, my auto date field has stopped working. With a medium date, the
current date is supposed to be entered when a new record is created, but it
is now displaying #Name? in the date column. I am also recieving the error
message: Unknown Function 'Date' in validation espression or default value on
'rigmoves 2006.Date' This started today (March 2, 2006) and the same
format, and database has been used for the past 3 years without any problems!
Any suggestions???

 

[Guest]

You are having issues with your references.

Re-create your references, from the coding window, and your problem should
clear up.

You can search the topics for other posts on this same issue.

Sharkbyte

 

[Roger Carlson]

Check your References. Look here:
http://allenbrowne.com/ser-38.html

--
--Roger Carlson
MS Access MVP
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

 

[Guest]

I checked my references and found that Adobe control for ActiveX is missing.
I browsed to my ActiveX folder in Adobe Acrobat, and now am faced with a
dilemna: Which file is it??? I have AcroIEHelper.dll, AcroPDF.dll,
GbDetect.dll, and pdfshell.dll. Is it any of these or do I have to look
somewhere else??? I apologize for my lack of knowledge, but I am new to
Access. Thank you for the help you have given me already! and that yet to
come!

 

[Roger Carlson]

First of all, remember which reference it is. Then just Uncheck it and
click OK. Quite often, this fixes the problem. If it doesn't, you'll have
to check it again and then find the file it references. I don't know what
that would be. You might look on your client's machine.

--
--Roger Carlson
MS Access MVP
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

 

[Guest]

Hi Brant,

The first thing I would try is to simply deselect this reference. Click on
the OK button to dismiss the references dialog. Then click on Debug > Compile
ProjectName. If your code compiles without an error, then you did not need
this reference checked in the first place. It is not uncommon at all to find
unneeded libraries that are referenced in databases.


Tom

http://www.access.qbuilt.com/html/expert_contributors.html
http://www.access.qbuilt.com/html/search.html
__________________________________________

 

[Guest]

Thank you all for your assistance, the problem has cleared right up!