Noob asking for help - Access 2003

  • Thread starter Thread starter groupsdotgoogle
  • Start date Start date
G

groupsdotgoogle

I'm trying to autonumber a certain field. Searches through this group
lead me to trying a default value of
Nz(DMax("[EmpID]","tblEmployee"),0)+1. When I try to save, I get
"Unknown function 'Nz' in validation express or default value on....".
I search under "Unknown function" & I read that I should check under
Tools/references. Do that, I find about five available references have
been checked out of what looks like several hundred. None are marked
"missing" (which I read I should look for). The five are: Visual Basic
for Applications, Microsoft Access 11.0 Object Library, OLE Automation,
Microsoft DAO 3.6 Object Library & Microsoft ActiveX Data Objects 2.1
Library.

Any ideas on getting this working?

Thanks
 
You can't use functions when defining the default value for a field in a
table.
 
While it is true that error messages like these can be caused by a missing
reference, there are other causes, and this is one of them - you can't do
that in the table, you have to use a form.
 
Back
Top