How to make table from filtered form

D

DavPet

I have a form that users can filter as they like.
How can I let the user make a table of his data when he has finished
filtering?
The application is on a LAN and is used by several people.
The created table needs to be on the users own harddrive.
 
J

John Vinson

I have a form that users can filter as they like.
How can I let the user make a table of his data when he has finished
filtering?
The application is on a LAN and is used by several people.
The created table needs to be on the users own harddrive.
Click to expand...

Don't.

A Table has no independent existance outside Access. Unless the user
has a separate .mdb file on their own disk (and has Access installed),
you can't give them an Access Table at all; even if they do, it's
probably not a good idea.

If they need the *information* stored in the table, it may be simplest
to create a Query (using criteria from the form, or some VBA to
convert the form's Filter property into a Query) and Export the query
to an appropriate external form - an Excel spreadsheet, a dBase table,
a comma-separated-values text file, or the like.

John W. Vinson[MVP]
 
Top