Report Invoice problem and Autonumber Question ?

[soldieryap]

i wanna to display a customer invoice preview form and print it out, because i wanna to enter the customer ID to enter that page... i use =Trim([customer ID]), is it correct? if not what should i do, how to pop up a column to enter the customer ID before enter that page?

another one, can we start the Autonumber from a certain number instead of start from 1?

 

[WaltLukeIII]

I don't know of a way to start an autoNumber. I usually make my own autonumber field and increment each time a new item is added.

If you want to open a form with only ceartian information in it. I would use a form to select what criteria you want. Have a form that askes for the Customer ID that they want to see then have them press a button on this form that opens the next form with the CustomerID as the LinkCriteria. For more information look at the module and Under Help at the "DoCmd Methods" and "OpenForm".

Walt III
SAElukewl@netscape.net

http://www.muc.edu/~lukewl

 

[THoey]

To the best of my knowledge, you have no control over an Autonumber in Access. The only way I could think of to start at a specific number might be to write some code that would go into a loop, adding records to the table, to the value of the number you want to start with minus 1. I would put something unique in one of the columns, and then write a query to delete all the records that have that unique value.

Hope this helps...

Terry M. Hoey
th3856@txmail.sbc.com

Ever notice that by the time that you realize that you ran a truncate script on the wrong instance, it is too late to stop it?