Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
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

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Dynamically connecting to a remote database Tony Excel Discussion (Misc queries) 0 April 14th 08 05:35 PM
Connect to Access Database On Remote Server UT Excel Discussion (Misc queries) 0 August 21st 07 10:42 PM
client information database BluesMan Excel Discussion (Misc queries) 1 February 5th 07 12:44 PM
Remote Filtering [email protected] Excel Discussion (Misc queries) 1 April 6th 06 01:52 AM
how do I set up a database for client information Insurance Tracie Excel Discussion (Misc queries) 1 May 13th 05 05:11 PM


All times are GMT +1. The time now is 05:46 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"