If you have a new account but are having problems posting or verifying your account, please email us on hello@boards.ie for help. Thanks :)

Hello all! Please ensure that you are posting a new thread or question in the appropriate forum. The Feedback forum is overwhelmed with questions that are having to be moved elsewhere. If you need help to verify your account contact hello@boards.ie

Hi there,
There is an issue with role permissions that is being worked on at the moment.
If you are having trouble with access or permissions on regional forums please post here to get access: https://www.boards.ie/discussion/2058365403/you-do-not-have-permission-for-that#latest

Vb6

jl2004 · 2004-02-23 17:07:34

Does any1 know a component in vb that acts the same way as autoNumber in Ms Access ?

23-02-2004 5:07pm

#1

jl2004

Closed Accounts Posts: 3 ✭

Join Date: February 2004

Posts: 2

Does any1 know a component in vb that acts the same way as autoNumber in Ms Access ?

0

Comments

#2 23-02-2004 5:39pm

bonkey

Registered Users, Registered Users 2 Posts: 15,443 ✭✭✭✭

Join Date: April 2001

Posts: 14635

No, but you can write one in under a dozen lines of code, so I'm not really surprised.

jc

0
#3 24-02-2004 12:18pm

jl2004

Closed Accounts Posts: 3 ✭

Join Date: February 2004

Posts: 2

dont mean do be a dumbass but im as much a newbie to vb as to boards.ie
any chance of showin me the code?

0
#4 24-02-2004 3:20pm

bonkey

Registered Users, Registered Users 2 Posts: 15,443 ✭✭✭✭

Join Date: April 2001

Posts: 14635

Describe what you want it for.....

0
#5 24-02-2004 10:55pm
Mazikeen

Closed Accounts Posts: 24 ✭

Join Date: February 2004

Posts: 22
The simplest implementation would be something like:
Public Function getAutoNumber() Static iAutoNumber As Integer iAutoNumber = iAutoNumber + 1 getAutoNumber = iAutoNumber End Function
However it starts getting more complex as you introduce things such as multiple autonumber instances and persistance (where does your auto number go when you switch off your code?)

0
#6 25-02-2004 10:07am

jl2004

Closed Accounts Posts: 3 ✭

Join Date: February 2004

Posts: 2

Thats grand, i have it figured out now, thanks.....

0
Advertisement
#7 25-02-2004 1:44pm

McGintyMcGoo

Closed Accounts Posts: 333 ✭✭

Join Date: January 2003

Posts: 239

Thats grand, i have it figured out now, thanks.....

... "figured out" OR you just copied it exactly!!??

0