Noob asking for help - Access 2003

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

groupsdotgoogle@creativenow.com - 19 Dec 2005 23:28 GMT

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

Reply to this Message

Douglas J. Steele - 19 Dec 2005 23:30 GMT

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

Signature

Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no e-mails, please!)

> I'm trying to autonumber a certain field. Searches through this group
> lead me to trying a default value of
[quoted text clipped - 11 lines]
>
> Thanks

Reply to this Message

Brendan Reynolds - 19 Dec 2005 23:35 GMT

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.

Signature

Brendan Reynolds

> I'm trying to autonumber a certain field. Searches through this group
> lead me to trying a default value of
[quoted text clipped - 11 lines]
>
> Thanks

Reply to this Message

groupsdotgoogle@creativenow.com - 20 Dec 2005 18:59 GMT

Thank you for your input.

Reply to this Message