If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
How to make table from filtered form
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. |
#2
|
|||
|
|||
How to make table from filtered form
On Thu, 16 Feb 2006 14:49:29 -0500, "DavPet"
wrote: 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] |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Customers- Contracts form problem | GL | Using Forms | 10 | February 7th, 2006 04:05 PM |
Need to stop form from creating new records in table | Scott | General Discussion | 0 | December 15th, 2005 05:56 PM |
Multiple Options Group | Patty Stoddard | Using Forms | 19 | August 4th, 2005 02:30 PM |
strategy for data entry in multiple tables | LAF | Using Forms | 18 | April 25th, 2005 04:04 AM |
auto entry into second table after update | Tony | New Users | 13 | July 9th, 2004 10:42 PM |