View Full Version : autocounter & Print one page


olsen
11-06-2001, 08:41 AM
I am new to Access, and trying to make a simple form.
I have 1 table, with 4 fields
number : Autonumber, that can not be reused after it have been printed, It have to be counted up every time at new print
text1, text 2 and text3 : typed in numbers and text that have to be saved with the autonumber.

How do I mix that ?? and how do I make sure that I only print the one page I am using and there after fields to be ably to make a new print after typing info.

Chris RR
11-07-2001, 06:54 AM
Some questions and maybe a few suggestions to get you started.

"Autonumber" won't do a record count in a printed page. It's an automatically generated number that can be used as a unique record key. You need to look at the COUNT function to do a record count.

Don't name your fields text1, text2, and text3. Months from now, you won't remember what is in them.

If you need to make sure that a record is only printed one time, you could add a new field to your table, called something like WAS_PRINTED. Make it a yes/no field, default it to "n" and create a little update query that sets it to "yes". Run that update query right after every print.

Remember that you don't want to print a form, you want to print a report. You can make a report that looks just like your form, and put a button on your form to print that report.