This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(128, 8%, 22%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EA%3C/text%3E%3C/svg%3E)
My organization is using MS Word form to create a client questionnaire. Each Word doc form is saved as PDF file and stored in the Client's folder. I created a form in Access to capture and parse the questions but I cannot find a way to create and output a PDF file from Access. This requires me to repeat the entry process manually into the Word document. My IT department won't let me roll this out to other employees because of A) the double entry issue and B) they fear other users apparently will have to learn and use VBA to output individual records.
My question is: Can Access output individual records as a printable PDF format and cannot it be done without VBA?
A family of Microsoft relational database management systems designed for ease of use.
Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.
I can answer the one question... You can set two Primary Keys by highlighting both rows and then pressing Primary Key.
David,
Me <--no degree in Computer Science.
I did have a great teacher who was a co-worker. I learned a lot for her but more from the great help I received in newsgroups as there were no forums at the time. If I were a beginner now I would start with Crystal's book which is free...
http://allenbrowne.com/casu-22.html
You can also go here for free Data models...
http://www.databaseanswers.org/data_models/
https://www.access-diva.com/tips.html#bmDataModels
Access is simple enough for non-technical Users but once you start getting *serious* you do need to do some reading. And those hundreds of hours are over time with the help of the many Forums where free help is given including helping you create a data model. So if you ever decide it's worth the time, we are here to help.
I also noticed you said you created a Form and tried to add fields from another table which sounded like it was unrelated to the record source of the Form. Well, this can only be done when table is part of the record source. You can create a query which can include multiple tables from which you need fields and build your form though most would just use a subform in a typical one-to-many scenario.
...........but I cannot find a way to create and output a PDF file from Access.
You might like to take a look at InvoicePDF.zip in my public databases folder at:
https://onedrive.live.com/?cid=44CC60D7FEA42912&id=44CC60D7FEA42912!169
Note that if you are using an earlier version of Access you might find that the colour of some form objects such as buttons shows incorrectly and you will need to amend the form design accordingly.
If you have difficulty opening the link, copy the link (NB, not the link location) and paste it into your browser's address bar.
Nothing much has changed.
What you should do is switch to the SQL view for the query and then copy and paste the SQL into a message that you post back here so that we can see it.
Aside from that, if you want to create individual pdf documents from each record, you could use the Merge to Individual Documents facility onmy Merge Tools Add-in that is contained in the MERGE TOOLS ADD-IN.zip file that you can download from the following page of my One Drive:
Extract the files from the archive and read the:
“READ ME – Setting up and using the Merge Tools Add-in.pdf
to see how to install and use the various tools. Using those tools, it is possible to perform the following types of merge that cannot be done with Mail Merge “out-of-the-box”:
● Merge to e-mail messages either with or without attachments, with the documents created by the merge being sent as either Word or PDF attachments or as the body of the e-mail message.
● Merge to individual documents in either Word or PDF format with the filenames being supplied by the data in one of the fields in the data source
● Many to One type merges, which can be used for creating documents such as invoices where there are multiple records in the data source that have common data in one of the fields
● Merging to a document that will include a chart that is unique to each record in the data source
● Merging a document with Content Controls
● Merging a document that contains Legacy FormFields
● Duplex Merges
● Merging to a printer that will collate and staple the output created from each record in the data source.
The requirements for using the system are:
● The mail merge main document must be of the Letters type, though that does not mean that the output cannot be sent as an e-mail message where relevant.
● For the Many To One, Merge with Attachments and Merge to Individual Docs utilities, the data source may be either a table or query in an Access database, or in the form of an Excel worksheet and that worksheet must be the first sheet in the Excel workbook. If the data is on some other sheet, you can easily move that sheet so that it is the first sheet in the workbook by clicking on the sheet tab and dragging it to the left. For the Chart Merge utility, see the Mail Merging with Charts document that is included in the Merge Tools Add-in Zip file for additional requirements for the data source for use with that utility
● For a data source in the form of an Excel worksheet, the field names must be in the first row of the worksheet and there must be a field name in all of the cells in that row that are within the range of columns that contain the data.
● For both types of data source, the field names must contain only alphanumeric characters (No @,#,$,%,&,(,), etc) and the field names must not start with a numeric character (0-9). The number of characters in the field names, including spaces, must not be more than 40
.
I attempted the looking at the SQL but I'm not sure if I understand how to use it. I don't use the Microsoft Support help resource because those instructions are outdated and are not relevant to my version of Access. Can you direct me to a help source for Access 2016?