How to make table from filtered form

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

DavPet - 16 Feb 2006 19:49 GMT

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.

Reply to this Message

John Vinson - 16 Feb 2006 23:40 GMT

>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.

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]

Reply to this Message