exporting results

[scott_j_g]

Hi All

I need a bit of help ... i am trying to create a button in an access 2010 database that will export certain bits of information from within it, i have attached a screenshot, when a something is selected from the drop down list (highlighted in blue) the rest of the form fills in, i would like to export all the red sections, do you know of an easy way of achieving this? i do not have any coding experience

Thanks

 

[Severin]

Create a query that shows those fields and that is filtered on your id or code or whatever you have that is unique. If it was id then the criteria on the id field in the query would be something like forms!YourForm!id

Then go into the code for your button, select the code builder and enter something like:

Private Sub NameOfYourButton_Click()
DoCmd.SendObject acSendQuery, "NameOfYourQuery", acFormatPDF
End Sub

 

[Severin]

..or choose another format!~)

 

[scott_j_g]

Thanks Severin that has worked well . . . however ... the results that are being outputted are being multiplied hundreds of times, instead of having half a page with the results, i have full pages (just under 300 of them) ... any thoughts?

Thanks again

 

[scott_j_g]

ignore me, my mistake it was outputting the whole database not just the selected items, got it working now thanks a lot for your help

 

[Severin]

Excellent!~)