Record Count

[jgelpi16]

I am importing a text file directly into a table. What I need is to fill in a "counter" field every time I load the file (I delete all out of table each time). If I use the Autonumber feature it picks up from where it left off last time ( filled in 1 - 10 first time and then 11-15 the second time). Any suggestions would be greatly appreciated. Thank you

[ajetrumpet]

after deleting all the records out, you can restart the autonumber at any number you want by using the MS method. some of it is adopted here: http://www.ajenterprisesonline.com/_...e=AutoNumStart

allen browne also has a simpler method of doing it using data definition methods. for the above function, delete the data out before running it, if you choose that method.

[jgelpi16]

Thank you! I'll have to research when I have a little bit more time.

[jgelpi16]

Adam,
I used your function and it is working beautifully. However, there is one issue I run into upon exiting of the function. I receive the run-time error message:

"The action or method requires a Table Name argument."

I'm new at calling functions and am sure I have something simple messed up. I did make sure the AutoNum field is not indexed. Below is the code that calls the function:

DoCmd.OpenFunction (AutoNumStart("tblBEACONGarnFile", "AutoNum", 1))

Thanks again for your help.

[jgelpi16]

Got it. Used "Call" instead of "DoCmd.OpenFunction". What is the difference?