I have an access 2003 data base with 30,000 records. I want to be able to select one, multiple, or all the records in the table and print certain fields, from each record to an individual page or form with the headings as indicated. Attached please find a sample db, an image of what the Page form should look like? with the information inserted from the table. The fields to be printed are
AccountNum-LastName-FirstName-Address1-City-State-Zip-DOB-Gender-First Visit Date.
The page will be printed to an image file With "Joy Image Printer" I need the Name of the File to be the respective SSN ftom the Table
Macro For Access
To work on winxp