Help for MS access
-
Can anyone tell me how to clear the counters from Autonumbers in table?
E.g. i set the number to 10000, it will auto and incrementally from 10000 to 10001 to 10002... so on and so for in each record. however, when i want the counter to go back to 10000, i'm unable to do so, any clue to it?
-
Post some screenshot.
-
U r using Version
-
I'm using MS office 2000. How can you make the 10007 to become 10000 again?
-
1)Hi, the answer to your question is this :Originally posted by babymac13:Can anyone tell me how to clear the counters from Autonumbers in table?
E.g. i set the number to 10000, it will auto and incrementally from 10000 to 10001 to 10002... so on and so for in each record. however, when i want the counter to go back to 10000, i'm unable to do so, any clue to it?
You are using AutoNumber field. You can not change it back WITHOUT changing this field to Number.
When you use autoNumber, you have this problem when it hits the last number of this field can take. So, think what cases you want to use this.
2) To change whatever number you want, first declare the field to number.
remember to capture this field if you can to change it later. -
Simple... delete all the records, then use the "Repair and Compact" feature of the database, then let us know if that helps, coz i know it did work for me.
-
Thks for replying.Originally posted by Sky2D2:1)Hi, the answer to your question is this :
You are using AutoNumber field. You can not change it back WITHOUT changing this field to Number.
When you use autoNumber, you have this problem when it hits the last number of this field can take. So, think what cases you want to use this.
2) To change whatever number you want, first declare the field to number.
remember to capture this field if you can to change it later.
But i trying changing the field to number and return the field back to autonumber again, but the autonumber still start from 100007.
Do u mind to explain it once again. Thks. -
First, the AutoNumber field is for autonumber in sequence. Is this Invoice table link to another autoNumber field in another table?Originally posted by babymac13:Thks for replying.
But i trying changing the field to number and return the field back to autonumber again, but the autonumber still start from 100007.
Do u mind to explain it once again. Thks.
Assume you use ony Invoice table:
To change the Id field of the table, you can use DAO or ADO. Do you know this?
Let say you have Id = 10007, but want to change it to say 10000, you need to use DAo or ADO to change it. Capture 10000 first, use recordset object to change the old id=10007.
If you want the NEW ID say 10000, copy this table, delete the old table, change this copy table with the old table name. everything will begin with 10000. -
Thks, it's helpful, but it didn't start from 10000 but 10001.Originally posted by DailyFreeGames.com:Simple... delete all the records, then use the "Repair and Compact" feature of the database, then let us know if that helps, coz i know it did work for me. -
Sorry, wat's DAO or ADO stand for?Originally posted by Sky2D2:First, the AutoNumber field is for autonumber in sequence. Is this Invoice table link to another autoNumber field in another table?
Assume you use ony Invoice table:
To change the Id field of the table, you can use DAO or ADO. Do you know this?
Let say you have Id = 10007, but want to change it to say 10000, you need to use DAo or ADO to change it. Capture 10000 first, use recordset object to change the old id=10007.
If you want the NEW ID say 10000, copy this table, delete the old table, change this copy table with the old table name. everything will begin with 10000. -
i'm using 2003 Professional version
-
Anyone have any clue to this error? The one circle in red.
-
Hi, the error msg means the (Inv Id)control 's datasource is not correct. Sometimes you see #error sign too. Open the Inv ID 's properties and check the data tab and see if you use the correct field.Originally posted by babymac13:Sorry, wat's DAO or ADO stand for?
Do these step:
1. Check the relationship between tables.
2. Check the Form's datasource.(open the form's properties and see the data tab) and make sure form using the correct table.
I think you need to tell me the relationship between tables, make sure links are done correctly. A poor table design will bound to give you alots of problems later.
DAO and ADO are activeX Data Objects to do many tasks on database such as changing the table content..... -
Sorry for the trouble again.
Can anyone explain the following below? This is found in the expression builder under select Query design.
ExtendedPrice: CCur([Order Details]!UnitPrice*[Order Details]!Quantity*(1-[Order Details]!Discount))
What is
1)CCur
2) ! and ?
3) the purpose of that fomula
Thank in advance. -
To reset the Autonumber, what I do is to delete the autonumber field (in design mode) in your case its the InvoiceID field and immediately create a new auto field with the same name.
-
Thanks.Originally posted by MCY:To reset the Autonumber, what I do is to delete the autonumber field (in design mode) in your case its the InvoiceID field and immediately create a new auto field with the same name.
-
Hi, may i know if anyone has ever encountered the problem below?
I have no idea to desolve the error.
I suspect it's because my reservation id is a autonumber that lead to the error, am i correct to say that.?