Microsoft access 2007 print form current record

Under Actions, click Print Record. Click Next. Click Text. Enter cmdPrintRecord. Click Finish. Miss an Access tip? Check out the Microsoft Access archive and catch up on other Access tips. However you do, it, it is important that you save the current record before opening the reports, with Me. Otherwise any changes you've made to the data in the form but not yet committed to the table will not be reflected in the report, or, if the record is a new one nothing will be reported at all.

BTW never accept the default names such as Text1 which Access gives to a control. Always change the name property of the control to something indicative of its purpose like txtOwnerID; that way your code is more readable. Be sure to do this before writing any event procedures for the control, however. If you change the name afterwards the link with the code will be broken and you'll need to recreate the event procedure.

Ken Sheridan, Stafford, England. Tuesday, November 20, PM. Hi Ken, I used to rename all controls to make the code readable, using the same naming convention as you.

I seem to be having no luck.. Everything looks right Would anyone be willin to have a look at the db? It's too big to posture though 20mb. You have Thank you for that but that did not quite achieve the outcome I need. It still will open a report for every record still instead of 1 report for that current record only. What were the compile errors which u needed to fix and how were they affecting the DB overall?

Finally got it to work as I wanted it to. However I created another issue where a couple of the reports will print two pages of the same record. Can that be easily corrected? Wednesday, November 21, PM. That's probably due to the report being based on a query in which there are two rows in a referencing many-side table which reference a single row in a referenced one-side table.

You can follow the question or vote as helpful, but you cannot reply to this thread. I have the same question Report abuse. Details required :. Cancel Submit. Previous Next. Create a report as needed.

I would expect you want to add a command button to your form that prints the current record. There is a command button wizard to open the report. Add a line to the code to save the record: Me. OpenReport "your Report name", acviewpreview, , strWhere I don't know what you mean by clearing the field. How satisfied are you with this reply? Thanks for your feedback, it helps us improve the site. In reply to dhookom's post on October 2, But if they print single records often, the extra steps are going to become a nuisance, quickly.

You can easily automate the process of printing a single record using the form shown in Figure A. The form is bound to the Employees table in Northwind, the sample database that comes with Access, but you can use most any form.

Simply add a command button to the viewing form and then the user can click the button on the form instead of using the built-in printing options. Most likely, you'll inhibit those options anyway. This method's has one requirement: The table must include a field that contains a unique value for each record. A single-field primary key or an AutoNumber field will do nicely. Start by opening the example form in Design View and inserting a command button. Name the button cmdPrint and enter Print Record as its Caption property.

Next, click the Code button on the Form Design toolbar to launch the form's module and enter the code in Listing A. Return to Access so you can save and close the form. It's important to note that the passed EmployeeID value is a numeric value, so there's no need to delimit the field reference. When relying on a text or a date field, use the apostrophe ' or pound character, respectively, to delimit the value in the following forms:.

You'll also need a simple report, such as the one in Figure B. When you open this bound report from the Database window, it displays all of the data source's records.