I need to create a table that can automatically generate numbers starting with 9910080 then go to 9910081 and so on.
If anyone can help me i would so appreciate it!!! Its for my job and i'm so lost, i can't figure it out. Thanks
I need to create a table that can automatically generate numbers starting with 9910080 then go to 9910081 and so on.
If anyone can help me i would so appreciate it!!! Its for my job and i'm so lost, i can't figure it out. Thanks
You would use DMax() in the BeforeUpdate event of a form to generate the next number.
where do i find DMax on access?? Sorry im not really familiar with access
VBA Help: <ALT> F11 and then F1
...what version of Access are you using?
access 2007 on XP
So just hit F1 and type DMax in the search bar.
awesome, thanks!!!!
You're welcome. Just post back here if you still need assistance on this issue.
ahh ok so i read what it said about Dmax on F1 but im still confused. Ive been playing with it but still no success. I opened Insert then Procedure and typed DMax then i entered... nextnumber = Nz(DMax(targetfield, targetdomain), 9910079) + 1
But im not sure what im not doing right to create a table where i can generate the number?? Please Help!!
All of the arguments of the Domain functions are strings.
DLookup Usage Samples