Forum Moderators: open

Message Too Old, No Replies

simple access counter

counter

         

brancook

12:08 am on Feb 16, 2007 (gmt 0)

10+ Year Member



Hi everyone,

I'm in need of good little database to assign serial numbers to a product. What I need is something simple and fool proof. What I'm doing is creating product id labels in a program called Bartendar and I need the serial number tracking to come from a reliable source.

Is there a way that access can do this?

Thanks

nickthompson

4:21 pm on Feb 27, 2007 (gmt 0)

10+ Year Member



Yes. Set up your table with a field with data type 'Autonumber'. At the bottom of the table design window you'll see a parameter called 'New Values', which is set to 'Increment' by default. Change this to 'Random'.

By default you'll get an 8 digit ID. Change the data type to 'Replication ID' if you want a (much) longer ID field.

Nick

brancook

6:24 pm on Mar 8, 2007 (gmt 0)

10+ Year Member



Thanks Nick,

I'll give that a shot.