How can I create a hyperlink or button in on an MS Access form to create a fax cover sheet?
I am creating an Access database for a customer service phone line at work. I would like to put a hyperlink or button on the form that would automatically generate a fax cover sheet from the contact information in the form/database. Can this be done?
Tagged with: access database • customer service phone • fax cover sheet • hyperlink
Filed under: Fax Cover sheets
Make your form.
Make a report (i.e. your fax cover sheet in the "reports" section of MS. Make sure the data source is the same as the datasource of the form you made earlier.
Put a new button on your form. A dialog box comes up. Select "report operations"–> Open report–>specific data
In the next section, select a UNIQUE field from the list about your form, then click the SAME unique field from the list about your report. Then click the funny little double ended arrow.
Click finish.
Now, when you open the form and click the button, the report will pop up with the data included from your form (and only that data). You can print in the normal way (file, print), or click the print button.