printing new records

[Afrosheen]

I have two fields, a date field {for the version number} and a memo field.
I've created a form from the two fields called version updates. What it does
is when I change something in the database I can put the date and what I've
changed in the database. The thing is that I may have different version
updates and I want to print out the latest. Note: I do have have a print
command button to print out the record.

What I want to do is to print out the latest versions that I created. I may
have 2-3 versions that I haven't printed out and I want to print out just
those versions not the others.

Any suggestions would help
Thanks for reading my post.

 

[Sean Timmons]

Shouldn't be too bad.. I'd create a form that asks for the oldest version to
start with.

Have a Query that bumps against the table and uses your form

=[Forms]![FormName]![oldestversion] as criterion against the version number

field

Create a report that pulls from this query.

Have your form run the report on submit.

 

[John W. Vinson]

What I want to do is to print out the latest versions that I created. I may
have 2-3 versions that I haven't printed out and I want to print out just
those versions not the others.

Access won't by itself record which ones have been printed out and which
haven't (not to mention which jammed in the printer...); you'll need to record
that information yourself somewhere.

 

[Paul Shapiro]

I usually add a field for the date printed. You need some kind of field, and
the print date is potentially more useful than just a Yes/No. In the user
interface, I usually give an option to reprint records that were printed
during a user-specified date range, for example.

 

[John W. Vinson]

I usually add a field for the date printed. You need some kind of field, and
the print date is potentially more useful than just a Yes/No. In the user
interface, I usually give an option to reprint records that were printed
during a user-specified date range, for example.

Excellent approach. You can even update the field in the Close event of the
Report (or some other suitable event).