Is this possible?

[chestyxbond]

Even though I have no formal training in Access, every day what I have to do with this program gets more and more complicated. If anyone can help me out with this I would be very appreciative.

I have a form that contains a command button that will export a report to a file. I used the wizard to make this button, so there shouldn't be anything weird with it. Now, what my boss would like to do is be able to select which columns actually appear on the exported report.

Now, these people don't know thing one about Access, so they want to be able to click the command button, have a list of available fields with check boxes next to them. Theoretically you would be able to click the fields (aka columns in the table) you want to appear in the exported file, and when you click an ok button at the bottom all of the info you want goes to the file.

Is this possible at all? I've been going through help all morning, and I can't find anything even close to want I want to do here.

Daniel

 

[LonnieJohnson]

You could add a step that would run a make a table query based on the fields that you choose. Now we export our file based on the new table. Each time it is run the make a table query would overwrite the prior one.

That's one way of doing it. Fortunately Access usually has more than one way to skin a cat.

If we need to go into greater detail, then email me with your specs and I will try to make more sense and give you some actual code to work with.

Be sure to re-state your problem in your email as I get a number of emails sometimes.

Good luck....


ljprodev@yahoo.com
ProDev, MS Access Applications B-)

http://www.galaxymall.com/software/PRODEV

 

[mymou]

Hi chestyxbond

You could give them access to a query (in design view) if they really needed flexibility.

From there they can use the links with office.

Stew "Even a stopped clock tells the right time twice a day."

 

[LonnieJohnson]

I have emailed a demo that will show you how to create a form that will allow you to view the columns that you need. It only opens a query not a report. This will need to be done with the CreateReport and CreateControls functions. Hope this gets you started. ljprodev@yahoo.com
ProDev, MS Access Applications B-)

http://www.galaxymall.com/software/PRODEV