Autonumber start at 500 (1 Viewer)

Banana

split with a cherry atop.
Local time
Today, 04:58
Joined
Sep 1, 2005
Messages
6,318
As usual, Brent gets it.

I totally spaced out on that argument parts, thinking that the code didn't have any.
 

datAdrenaline

AWF VIP
Local time
Today, 06:58
Joined
Jun 23, 2008
Messages
697
Thanks Bannana ... but the tip about the Class vs Standard module you posted is good too!! ...
 

datAdrenaline

AWF VIP
Local time
Today, 06:58
Joined
Jun 23, 2008
Messages
697
One more thing ccg.. you're step by step should be ....

copy the code. open VB. INSERT->New Module. Paste.

Display the immediate window (View -> Immediate Window),
type "SetAutoNumber InvoiceID, 550" and then hit the <Enter> key.
 

ccg_0004

Registered User.
Local time
Today, 04:58
Joined
Mar 12, 2008
Messages
41
Worked my way through it

One more thing ccg.. you're step by step should be ....

copy the code. open VB. INSERT->New Module. Paste.

Display the immediate window (View -> Immediate Window),
type "SetAutoNumber InvoiceID, 550" and then hit the <Enter> key.
will *A LOT* of help from my friends (beatles tune in bg...). Thanks so much y'all I got it working now. I never knew about the Immediate window or even how to call a procedure.

You learn something new everyday they say, so I guess I can go to sleep now! Thanks again for the help!:D
 

Users who are viewing this thread

Top Bottom