Go Back   Access World Forums > Microsoft Access Discussion > Tables

 
Reply
 
Thread Tools Rate Thread Display Modes
Old 06-15-2016, 09:05 AM   #1
jedder18
Just Livin the Dream!
 
Join Date: Mar 2012
Posts: 115
Thanks: 27
Thanked 9 Times in 9 Posts
jedder18 is on a distinguished road
add new autonumber fld data

User would like the InvNbr to be autogenerated in there table.
The field Invoice# is currently text.
So, I've created a new field in a copy of the structure of the PayRcvdTable .....InvNbr
I was able to get it started at the correct number in the new copy of a blank table.
However, How do I get the data from the current table into this new table without having the autonbr fld (InvNbr) generate a nbr for the appended records that shouldn't be populated.
I want any future records in the table to be autogenerated from the starting point I have of InvNbr 80.

jedder18 is offline   Reply With Quote
The Following User Says Thank You to jedder18 For This Useful Post:
hassanogaibi (06-28-2016)
Old 06-15-2016, 02:11 PM   #2
GohDiamond
"Access- Imagineer that!"
 
GohDiamond's Avatar
 
Join Date: Nov 2006
Location: Hartford, CT
Posts: 546
Thanks: 17
Thanked 48 Times in 46 Posts
GohDiamond is on a distinguished road
Re: add new autonumber fld data

Autonumber is Just that, each new record is incremented by default sequentially, so if you append 50 existing records to a table structure and the default starts at 80 then you'll AUTOnumber the records as they are sorted on append 80 thru 129.

You may need to do a custom VBA script in your Invoice form to simply start with 80 on the next invoice and then add 1 to the last number used each time you generate an invoice. Instead of the table's autonumber, because an autonumber is not really supposed to have any business intelligence associated with it.

CHeers!
Goh
GohDiamond is offline   Reply With Quote
The Following 2 Users Say Thank You to GohDiamond For This Useful Post:
hassanogaibi (06-28-2016), jedder18 (06-16-2016)
Old 06-15-2016, 02:13 PM   #3
RuralGuy
AWF VIP
 
RuralGuy's Avatar
 
Join Date: Jul 2005
Location: @ 8300' in the Colorado Rockies
Posts: 13,815
Thanks: 7
Thanked 309 Times in 299 Posts
RuralGuy is just really nice RuralGuy is just really nice RuralGuy is just really nice RuralGuy is just really nice RuralGuy is just really nice
Re: add new autonumber fld data

You really do not want an autonumber. Here's a link that should help: http://www.baldyweb.com/CustomAutonumber.htm

__________________
(RG for short) aka Allan Bunch Previous MS Access MVP acXP, ac07, ac10, ac13 - WinXP Pro, Win7 Pro, Win10 Pro
Please post back to this Forum so all may benefit.
Teaching is not filling a bucket but lighting a fire.
RuralGuy is offline   Reply With Quote
The Following 2 Users Say Thank You to RuralGuy For This Useful Post:
hassanogaibi (06-28-2016), jedder18 (06-16-2016)
Old 06-16-2016, 05:13 AM   #4
jedder18
Just Livin the Dream!
 
Join Date: Mar 2012
Posts: 115
Thanks: 27
Thanked 9 Times in 9 Posts
jedder18 is on a distinguished road
Re: add new autonumber fld data

They're going to have to go with higher numbers for the invoices going forward.
Don't want to jump through all these hoops for 1 number.
I'm making an executive decision here,
As long as the number is unique, shouldn't be an issue.
Thanks for all your help

jedder18 is offline   Reply With Quote
The Following User Says Thank You to jedder18 For This Useful Post:
hassanogaibi (06-28-2016)
Reply

Tags
append , autonumber

Thread Tools
Display Modes Rate This Thread
Rate This Thread:

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Pasting data with autonumber 97fleminglja Tables 6 10-14-2018 07:44 PM
Question AutoNumber Fields for data. sjd General 2 07-05-2012 12:48 PM
Next autonumber (non consecutive data) vrk1219 Tables 6 04-15-2009 03:11 AM
Autonumber PK vs. Data PK OxDavis Tables 4 08-31-2006 03:31 AM
using autonumber data against IN (list)? igloo Queries 1 09-27-2004 12:20 PM




All times are GMT -8. The time now is 04:24 PM.


Microsoft Access Help
General
Tables
Queries
Forms
Reports
Macros
Modules & VBA
Theory & Practice
Access FAQs
Code Repository
Sample Databases
Video Tutorials

Featured Forum post


Sponsored Links


Powered by vBulletin®
Copyright ©2000 - 2018, Jelsoft Enterprises Ltd.
(c) copyright 2017 Access World