append sequential numbers in access table (1 Viewer)

[hatmak]

hi

please help in

append sequential numbers in access query or table ( this sequence is variable )

based in number I put it in form like

12500

I want add 500 record sequence like

12501
12502
12503
12504



to
13000

other example
110200000 add 100 Coupon

to 110200100
in attached example

in form tb

when I press in button Generate Coupon

make this sequence in table "all_Coupon"


thanks for help

 

[theDBguy]

Hi. Sounds like you could use a Tally table.

Sent from phone...

 

[hatmak]

any help

 

[plog]

This is pretty simple, even if you don't know VBA I suggest you give it a shot. I'll help by writing the psuedo code:

Sub AddCoupons()

for i=0 to Me.CouponCount
  DoCmd.RunSQL("INSERT INTO YourTable (CouponNumberField) VALUES (" & i + Me.CouponNumber " &")")
  Next i
End Sub

Again, that's pseudo code which means it illustrates the ideas you need in your code but not the exact syntax.

 

[theDBguy]

any help

Here, using a Tally table. Hope it helps...

 

[hatmak]

Here, using a Tally table. Hope it helps...

please try this number

100000000000

I have error massage

 

[The_Doc_Man]

No doubt you DO have an error. I believe I counted 11 zeros there. That number is 100 Billion (USA nomenclature) which would cause an integer overflow. The largest number you can count using a LONG is 4.1 billion (approximately) or 2^32 -1. IF you are on a 32-bit machine, you are done because Access won't support the QUAD type if the hardware doesn't support it. If you are on a 64-bit machine AND have a relatively new version of Access, it is POSSIBLE to have a quadword integer that would support a number that large. If so, you could use a VBA loop like plog showed you. The other choice would be to count numbers that big using a CURRENCY data type.

Why do you want/need numbers that big anyway?

 

[hatmak]

No doubt you DO have an error. I believe I counted 11 zeros there. That number is 100 Billion (USA nomenclature) which would cause an integer overflow. The largest number you can count using a LONG is 4.1 billion (approximately) or 2^32 -1. IF you are on a 32-bit machine, you are done because Access won't support the QUAD type if the hardware doesn't support it. If you are on a 64-bit machine AND have a relatively new version of Access, it is POSSIBLE to have a quadword integer that would support a number that large. If so, you could use a VBA loop like plog showed you. The other choice would be to count numbers that big using a CURRENCY data type.

Why do you want/need numbers that big anyway?

thanks for reply

Why do you want/need numbers that big anyway?

because that number is used for coupon number like big sale or serial number that issue in big market

 

[theDBguy]

because that number is used for coupon number like big sale or serial number that issue in big market

I think @The_Doc_Man's point was, have you tried manually entering that number into your Access table? Did it work?

Otherwise, what data type were you planning to use to store that number?

 

[Pat Hartman]

Can you break this into two parts. A prefix and a suffix? You can increment them separately but it will get complicated.