Solved Selected fields from a table/query to generate Report and export to Excel & PDF in MS Access

[mrk777]

Hi Team, Please help me build this up! I have a Master DB Table with about 34 fields and I have specific requirements filtering out the data and export the fields to Excel or PDF. I have built the queries with the requirements of the criteria. The requirement is to create a form with ListBox of all the field Headers from Master DB Table and whatever the fields I select, only those fields have to be opened in a table view, and then the user should be able to filter the values if needed from that table fields and click on Export button to Export to PDF or Excel.

I have created a form to get all the field header names.

 

[theDBguy]

This is like tempting with candy!

Did you send a PM as requested by the author?

 

[ClaraBarton]

uh... PM?

 

[ClaraBarton]

OK, guessing that's a personal message. How do I do that? I don't see his address.

 

[Isaac]

OK, guessing that's a personal message. How do I do that? I don't see his address.

He said "send me a PM if interested" in the first line of his message..................Go to the envelope icon which is immediately to the left of the Notification icon (that icon that shows a red # of notifications near upper right by Search button).

 

[arnelgp]

not same but almost.
indulge. don't take a pinch. take it all.

 

[ClaraBarton]

Believe me, arnelgp, I'm indulging. Although yours is a lot prettier, I got hold of Majp's form and started reworking it. I had been working on my own mess for HOURS and DAYS and now am starting over with his. Thank you so much.

 

[arnelgp]

i updated mine, so it will only export fields available in Selected fields listbox.
the export will obey the List arrangement of that listbox.

also on exporting, it will obey the filtering of the subform.

 

[BAntar]

thank to you all!

 

[evictme]

i updated mine, so it will only export fields available in Selected fields listbox.
the export will obey the List arrangement of that listbox.

also on exporting, it will obey the filtering of the subform.

This is brilliant! Was easy to setup and get going almost immediately. Just one question, how would I adjust the code to allow users to select the folder for export?

 

[ClaraBarton]

i updated mine, so it will only export fields available in Selected fields listbox.
the export will obey the List arrangement of that listbox.

also on exporting, it will obey the filtering of the subform.

I have been working long on an export/import form that actually works. I took yours, arnelgp, and ran. I added import capability, file pickers, and prettied it up to match the rest of my forms. The import function is rather specific to my needs but could be easily modified by anyone else. I can't thank you enough for allowing me to use it. Thanks anyway.

 

[arnelgp]

i like Clara's version, clean code.
still old (messy code). added SQL view.
will show on SQL whether filtered and/or sorted.
added image to the buttons.

also added FileDialog.

 

[BAntar]

Thank a lot!

 

[arnelgp]

you're welcome.
on another test, i got error when selecting a Query on the table listbox.
i modified fnUpdateZZTable to accept Query and table.

 

[ClaraBarton]

you're welcome.
on another test, i got error when selecting a Query on the table listbox.
i modified fnUpdateZZTable to accept Query and table.

I think that
Public Function fnUpdateZZTable(ByVal tName As String)
needs to clear the zztable before appending records.