Results 1 to 2 of 2

Thread: Choose Fields

  1. #1
    Join Date
    Dec 2002
    Location
    Houston, Texas
    Posts
    74

    Unanswered: Choose Fields

    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
    Attached Files Attached Files

  2. #2
    Join Date
    Oct 2003
    Location
    Canada
    Posts
    574
    You are limited to 6 only because your report has 6 fields. If you do not need a report then just export to text using transfer text in vba code. You can use this to export the entire query.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •