Noob asking for help - Access 2003

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
 
D

Douglas J. Steele

You can't use functions when defining the default value for a field in a
table.
 
B

Brendan Reynolds

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top