Results 1 to 4 of 4
  1. #1
    Eric1066 is offline Novice
    Windows XP Access 2007
    Join Date
    Oct 2009
    Posts
    14

    Newbie Help Account Numbers

    Hi Guys,



    Im new to this but i've been able to create the tables and the forms but I need a little help...

    I have created a new field called AccountNum where I want to apply a unique 8 digit number. How can I get access to do this automatically and sequentially with every new updated form?

    Thanks for any help, it is greatly appreciated!!
    Eric

  2. #2
    SoftwareMatters is offline Access VBA Developers
    Windows XP Access 2003
    Join Date
    Mar 2009
    Location
    Dorset
    Posts
    274
    You could use an autonumber but you would have to add 10000000 records first and then delete them to start from where you needed to be. Otherwise you could do it in code by using dmax and then adding 1 to the number.

  3. #3
    dcrake's Avatar
    dcrake is offline Competent Performer
    Windows XP Access 2003
    Join Date
    Aug 2009
    Posts
    435
    NO you do not need to create 10m records then delete them. Total nonsense. Create a new table and in the first column make it an number and enter 10000000 then save the record.

    Next create an append query and append the number field from table 2 into the autonumber field of table1. This will force the autonumber to begin at 1000000, or any number you want it to start at.

    David

  4. #4
    Eric1066 is offline Novice
    Windows XP Access 2007
    Join Date
    Oct 2009
    Posts
    14
    thanks for the responses! but like I said im a noob and I do not know what any of this means! how do I use DMax or where is Append Query? I looked at every option and could not find anything labelled append. Sorry guys for being an idiot, but the help I need, needs to be more 'step by step' type instructions.

    Thankyou so much, any and all help appreicated!!
    Eric.

Please reply to this thread with any new information or opinions.

Similar Threads

  1. account rights
    By pietje in forum Security
    Replies: 1
    Last Post: 02-05-2009, 12:58 PM
  2. newbie needs design help
    By ashiers in forum Database Design
    Replies: 0
    Last Post: 09-13-2008, 07:05 PM
  3. An oldie but newbie
    By GTodd in forum Access
    Replies: 1
    Last Post: 06-25-2008, 08:15 AM
  4. Newbie question
    By The_Dude in forum Programming
    Replies: 2
    Last Post: 12-23-2007, 07:11 PM
  5. Newbie question
    By benplace in forum Queries
    Replies: 1
    Last Post: 12-13-2005, 06:40 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums