If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
auto number is skipping by one for each entry
Hello:
I am using a form to enter records to the table. Through this form the user is able to enter multiple records. They type the values and click on save button. Then a message box shows up asking whether they have more data to enter. If they have, they say yes and type the data and click on save. This process goes on until they say no to enter more records. Everything seems working fine. Except the auto number is skipping one, for each entry. I am using DAO recordsetclone in the forms program. I am closing this recordsetclone at the end of the program. Still it is skipping one number for auto number field. How do I fix this one? Any help is appreciated. TIA, Sheela |
#2
|
|||
|
|||
auto number is skipping by one for each entry
Posting your message in multiple groups wastes people's time. Please limit
your posts to one group so that you do not have multiple people working on a solution for you. Rick B "sheela" wrote in message ... Hello: I am using a form to enter records to the table. Through this form the user is able to enter multiple records. They type the values and click on save button. Then a message box shows up asking whether they have more data to enter. If they have, they say yes and type the data and click on save. This process goes on until they say no to enter more records. Everything seems working fine. Except the auto number is skipping one, for each entry. I am using DAO recordsetclone in the forms program. I am closing this recordsetclone at the end of the program. Still it is skipping one number for auto number field. How do I fix this one? Any help is appreciated. TIA, Sheela |
#3
|
|||
|
|||
auto number is skipping by one for each entry
Sorry i didn't think that way.
-----Original Message----- Posting your message in multiple groups wastes people's time. Please limit your posts to one group so that you do not have multiple people working on a solution for you. Rick B "sheela" wrote in message ... Hello: I am using a form to enter records to the table. Through this form the user is able to enter multiple records. They type the values and click on save button. Then a message box shows up asking whether they have more data to enter. If they have, they say yes and type the data and click on save. This process goes on until they say no to enter more records. Everything seems working fine. Except the auto number is skipping one, for each entry. I am using DAO recordsetclone in the forms program. I am closing this recordsetclone at the end of the program. Still it is skipping one number for auto number field. How do I fix this one? Any help is appreciated. TIA, Sheela . |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
number display error with auto calculation | John | Worksheet Functions | 2 | March 1st, 2004 09:20 PM |
Excel 2002 "auto" number format | Norman Harker | Worksheet Functions | 0 | February 26th, 2004 04:40 AM |
Turning off Auto Number Formatting | Lorraine | Worksheet Functions | 1 | February 9th, 2004 10:30 PM |
Auto form number | Freshman | Worksheet Functions | 1 | November 13th, 2003 09:12 AM |