View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
battle battle is offline
external usenet poster
 
Posts: 1
Default Database Filtering and Import or Copy to Remote Client Workbook

This is a complex database, data filtering, and data import or copy
question.

Workbook Files: 3
1. Database located on Server (Workbook)
2. Data Entry Form on multiple computers (Templates)
3. Report Generator on multiple computer (Templates)

VBA Coding problem as follows:
1. Copy an ID on the Data Entry Form to an newly opened copy of the
Report Generator (the easy part).
2. Have the Report Generator open the database, filter the data based
on the ID, and copy the filtered data back to the Report Generator.
3. Run #2 from a macro in the Data Entry Form after the new data has
been passed to the database.

I am not unfamiliar with VBA, but I am kind of new and this level of
complexity is beyond me.

Does anyone have an example code that would be helpful?

Thanks
Battle