dumping data set to local drive for multiple users

[gwog]

Using Access 97

I have a form that the user can query table based on timeframe. (ie: pull data for 2/01/04 - 2/08/04).

What I want to do is to take that data from the query and make that the record set for everything else that happens on the form. I want to do this to speed up the rest of the activitiy on the form.

1st I'm not sure how to do this - I don't know much about VBA.

2nd There will be multiple users - so the only thing I can think to do is to dumpt the dataset onto their hard drive and link to it for remaining form operations. So that each user will have the data they select.

Any suggestions on a way to accomplish this that my next to zero knowledge of VBA could accomplish would be so appreciated.

Thanks.

 

[smedvid]

Just a suggestion... My approach is to create individual tables for each user. Upon login, I capture their login name/code and then have tables that are tagged with their login name/code. These are the tables they use for processing/analysis/reporting/etc. If you have a menu switchboard form, perhaps keep their logn name as a hidden field that can be referenced by all other forms. In the OnLoad event, select the correct table(s) to use. htwh,

Steve Medvid
"IT Consultant & Web Master"

http://www.saveourfarm.com

Chester County, PA Residents
Please Show Your Support...