Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Dynamically connecting to a remote database | Excel Discussion (Misc queries) | |||
Connect to Access Database On Remote Server | Excel Discussion (Misc queries) | |||
client information database | Excel Discussion (Misc queries) | |||
Remote Filtering | Excel Discussion (Misc queries) | |||
how do I set up a database for client information | Excel Discussion (Misc queries) |