Choose unlimited fields from table for excel export.

[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 all 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 the limitation off.
2. Also, I do NOT need report or preview. ALL I NEED A EXCEL EXPORT OF THE FIELDS END USER PICK FROM THE TEXT BOX.

Any suggession or detail help will be appreciated.

Thanks in advance. Dianna Goldsberg

 

[Kraj]

2. All you should need to do for this is to add a DoCmd to run the Analyze with Excel routine to the button/whatever instead of opening a report.