Choose fields on a form for export report (table base)

[doran_doran]

Need some touch up help.

Please open the sample Zip File (Access 97 Database).

Basically the form is able to load queries and tables in the combo box
User selects a table or query and the text box gets populated with al
the fileds. Now end user can select field and run a report.

What do I want ???
1. Currently, it's limited to 6 fields. I would like take th
limitation off.
2. Also, I do NOT need report or preview. ALL I NEED A EXCEL EXPORT O
THE FIELDS END USER PICK FROM THE TEXT BOX.

Any suggession or detail help will be appreciated.

Thanks in advance. Dianna Goldsber

+----------------------------------------------------------------
| Attachment filename: choosereportfields.zip
|Download attachment: http://www.MSAccessForum.com.com/forums/attachment.php?postid=213950
+----------------------------------------------------------------

 

[Duane Hookom]

Everything you need can be imported from the Query By Forma application at
http://www.rogersaccesslibrary.com/OtherLibraries.asp#Hookom,Duane. You can
select up to 30 fields and set criteria. Results are two clicks away from
sending to print, Word Merge, Word Table, Excel, Graph, Html, or "all Access
Form Letter".