Exporting single record from a FORM to PDF

I am having trouble exporting single records from a form to pdf.
I have the following code so far. but it gives:

Run time error 3464
Data type mismatch in criteria expression.

Debug highlights:
Me.RecordSource = "Select * From Propertyextract Where [propref] = " & _
![propref]

Private Sub cmdExportPDF_Click() Dim MyDB As DAO.Database
Dim MyRS As DAO.Recordset
Dim strSQL As String
strSQL = "Select Propertyextract.[propref] From Propertyextract;"
Set MyDB = CurrentDb
Set MyRS = MyDB.OpenRecordset(strSQL, dbOpenForwardOnly)
With MyRS
Do While Not MyRS.EOF
Me.RecordSource = "Select * From Propertyextract Where [propref] = " & _
![propref]
DoCmd.OutputTo acOutputForm, "FrmPropertyAttributes", acFormatPDF, "" & ![propref] & ".pdf"
.MoveNext
Loop
End With
MyRS.Close
Set MyRS = Nothing End Sub

Sponsored Links:

Related Topics

Exporting Reports Question
-Access 2007
-Adobe Acrobat 8 Professional

Currently our users are exporting reports one-by-one and then combining them after to a single pdf for printing.

Is there a way to export multiple reports to a single pdf file from Access?


Display pdf attachment in report
I have a table that contains data pertinent to parts which are manufactured. For each record I have a part number, revision, manufacturer etc. I also have an attachment dataset which contains a single pdf.

I would like to generate a report that has one record per page and displays the pdf attachment.

Generating and formatting the report is no problem, but my pdf attachment only shows up as the acrobat icon.

my vba is pretty weak. If there is a better way of going about printing pdf attachments I am open to suggestions.


Export Single Record
Is there a way to export a single record from an Access 2007 form? It can be exported to Excel or as a PDF or text file. For example if my data source has 100 records I just want to export record 5. If I need to explain this further just let me know.


Multiple Reports to Single PDF
I am working on a database for my company in Access right now and one of the Forms that I have created can generate a single PDF file based on a report. I would rather have this done another way though.

I want a user to be able to select multiple checkboxes on the form, which will determine what reports the user needs. The next thing that it will need to do is take all these reports and generate a single PDF containing each one of these selected checkboxes.


Export single record from a form to PDF
I am having trouble exporting single records from a form to pdf.
I have the following code so far. but it gives:

Run time error 3464
Data type mismatch in criteria expression.

Debug highlights:
Me.RecordSource = "Select * From Propertyextract Where [propref] = " & _
![propref]

Private Sub cmdExportPDF_Click() Dim MyDB As DAO.Database
Dim MyRS As DAO.Recordset
Dim strSQL As String
strSQL = "Select Propertyextract.[propref] From Propertyextract;"
Set MyDB = CurrentDb
Set MyRS = MyDB.OpenRecordset(strSQL, dbOpenForwardOnly)
With MyRS
Do While Not MyRS.EOF
Me.RecordSource = "Select * From Propertyextract Where [propref] = " & _
![propref]
DoCmd.OutputTo acOutputForm, "FrmPropertyAttributes", acFormatPDF, "" & ![propref] & ".pdf"
.MoveNext
Loop
End With
MyRS.Close
Set MyRS = Nothing End Sub


MACRO for emailing a single record
me please. I am very new to Access

I have created a database for recording Quality issues from various customers. I have also created a FORM for ease of entry of data. What I want to do is create a BUTTON for this FORM that when clicked will create a PDF of the current record only and attach it to an email. I have tried to use the SendObject action and have set up the email side of things but the problem I have is that the PDF that has been created has ALL of the records listed in it and not a singular record.

I suppose a macro similar to PRINT RECORD would be required.

Would this be able to be done as a macro or would VB be required?

I hope to hear from someone soon


Exporting Report to a word file or PDF or whatever
I get there is a button by the wizard that can make me export a report to ms word. Its quite cool but what I want to do is to ecport a report top ms word for a single record by this button.how do I code it


Link PDF files
What would be the best way to link pdf files in an Access database form?

For each record there could be more then one pdf file. I would like to automate the process as much as possible. The pdf file would exist on a network drive and the user would need to go to their record in Access and then link the pdf files.

I started but am having problems with Access not opening the pdf file, it will open word files but not pdf,


Exporting to PDF
I am using MS Access 2003. Is there a way to have an acces report automatically export to a pdf?


exporting report to PDF with specific results
I have a report which I need to export to a PDF with a certain filename. I have a PDF printer installed but its not the default so the code would need to specify the printer Named "PDF_Writer"
The report needs to be exported with a certain filename. 2 parts of the filename need to be derived from a form.


GO TO buttons on form
I have two forms based on a single table. One shows a list of records (with a few fields), the other in a single record with several fields. I'd like to create a button on each line of the record list form that will open the individual record on the single record input form. Also would like to have a button on the single record that would take me back to the list form


GO TO buttons on form
I have two forms based on a single table. One shows a list of records (with a few fields), the other in a single record with several fields. I'd like to create a button on each line of the record list form that will open the individual record on the single record input form.

Also would like to have a button on the single record that would take me back to the list form.)


Save to PDF Button?
For the final step of my purchase order program/form, I need a button that saves the form to a .PDF file. I don't want it to save as a new record, just have it go and save as a .PDF. When I would click the button, it would save just the form to a .PDF and it would come up with the window where you would select your save location.

What would be the event/code to be able to do this


Printing a Single Record in a Report
I have designed a simple database for printing out a standard letter using a table, a form and a report. I am using Access 2007. Everything works great except that when I set up a print button on the form, it prints out all the records and not just the one I have entered. I just wish to print the record that is currently on screen in the form, in the report I have created.
Additionally, it would be really useful if I could create a button that would create a .pdf of the single record and ask me to input an email address I wished to send it to, and then of course, to send it. I have the full MS Office 2007 suite.
Hope you can help, I will attach the database.


Small Project - Contractor Needed - Merge Access Data To PDF Form
I have a standard access database with customer records.
I have some PDF forms (to start with 3 forms).

I wish to create a facility that once my users navigate to a particular customers record, they can then merge that particular record to one of the three PDF forms.I am not conversant with VB, so I am happy to pay someone to create this functionality.

We are using Access 2007 and standard PDF forms.I am attaching one of the PDF forms for you to have a look. I will also supply a word document which outlines which field in my database pairs up with which field on the form.


Print linked pdfs with their associated reports
We have an Access form that we use to enter data. There are hundreds of records with their own seperate linked pdf (field notes). In each record there is a box that we "insert object" into (our scanned field notes-a pdf file)- a linked document in each record that is associated with that record.

At the end of each year we print out reports from each record. We then print out the pdf documents (field notes) seperately and then match them up and file them together.

This seems crazy and barbaric to me because the pdf is already associated to the records!

Is there a way to print out the reports so that each associated pdf prints out with each report? (so that at the printer I see report1, pdf1, report2, pdf2, etc.?

This way I can just grab the papers from the printer and staple each report with its associated pdf. <I mean this is 2011 right? It seems like there should be a way to do it. They are already associated!&gt


Automatically name a report when exporting to PDF
I have a form with a command button that opens my report in print preview mode in Access 2007. When I click the Export to PDF/XPS button, the default file name is the name of the actual report within Access. I've used VBA to change the report caption to match a field on my form called PROGRAM. However, this does not transfer over when I want to save my report to pdf.

How can I make it so that when I click export to pdf/xps, the default file name is named after a text box called PROGRAM?


Save current record on form as PDF and loop to next
I have a table and linked a form to it. My form looks nice (like a report) and has 1000's of records.

Currently I can save each record as a PDF but I have to type the file name (I use the print current record option on cute PDF) and doing this for 1000's of records is horrible.

Can someone help me to create a basic VBA code that I can click one command button and it then saves each record as a PDF using the main field and then move to the next using a loop. At the end I would like a folder with 1000's of PDF's of each of my records named after the main field.

If we can call my form "abc" and the main field / primary key for each record as "xyz" that would be great.

So with the primary key "xyz" this would have each record called "1", "2", "3" etc

I know it would have to open form abc, find xyz key and save record 1 as "1" repeat for next record and save as "2" etc

I use access 2010.


Populating Combo Box with delimited field
So I'm working on an Access 2007 application for my company's suppliers list, but I am restricted to using a single Excel worksheet for the back-end. One of the fields, called [Files], is a list of files in .pdf format related to a supplier.

The number of files can be 0, 1 or many. I currently have this field set up so that each file is separated by a semi-colon. A sample firstrecord in [Files] is:
K:\Users\test user\2008-12-24-ASTM D5857-08.pdf;
K:\Users\test user\2012-03-12APCPP25-Black.pdf;
K:\Users\test user\DIN_16901.pdf

The front-end contains a multi-item form. I'm trying to add a ComboBox (cboFiles) for each record, which is populated by the value in [Files]. Then, selecting an item in the ComboBox should automatically open that file.

I've tried a few approaches so far for populating the ComboBox: Setting [Files] as the Control Source results in a single item appearing as "K:\Users\test user\2008-12-24-ASTM D5857-08.pdf;K:\Users\test user\2012-03-12APCPP25-Black.pdf;K:\Users\test user\DIN_16901.pdf"


Form to PDF output
I have tried this code to a command button to save form as PDF in Access 2010
DoCmd.OutputTo acOutputForm, "form_name", acFormatPDF, _
me.textbox_name & ".pdf", True, "", 0
But it outputs all records to a PDF file. I just want to save current record to a file.