Hi there
I'm new to this site and new to Access. I've created a basic database which requires a user to enter data before allowing them to print this data in a formatted report.
I can not quite get the report printing feature working properly. I have created a query enterAJobNumber which requires the user to enter the invoice number (primary key). When this is entered, the relevant invoice appears and the user can save/preview/print it. This is too long-winded. I have a form named maintenanceIndexOli. When in this form, I'd like a Print button which produces a report based on that record and prints it automatically.
I guess this would be achieved by taking the Invoice Number field data and copying this into the query enterAJobNumberautomatically. Quite how to do this is beyond me. I would be grateful if someone could help me with this.
I'd also like the user to be able to save a report as a PDF. Is this possible with Access? I'd like a button on the form maintenanceIndexOli which opens the relevant report and allows the user to save it as a PDF.
Any help is much appreciated.