Set up for each computer

[Kevbro7189]

I have a D-Base with multiple tables that get updated from multiple sources
i.e. Excel file, Access files. Using Macros I "hard wired" the location of
each file on my personal copy of the D-Base, and I can update the tables just
fine.

My problem; I'm about ready to send this D-Base out to other users. Some of
them will be on a network and others on standalone computers. I need to find
away to allow the user to define where these external files are. Any Ideas
how I should start to tackle this?

Note: I'm VBA DUMB (but willing)
Thanks.

 

[Gina Whipp]

Kevbro7189,

Well, that would depend on where you *hard wired* the file location. Also,
which version of Access are you using?

--
Gina Whipp
2010 Microsoft MVP (Access)

"I feel I have been denied critical, need to know, information!" - Tremors
II

http://www.regina-whipp.com/index_files/TipList.htm

I have a D-Base with multiple tables that get updated from multiple sources
i.e. Excel file, Access files. Using Macros I "hard wired" the location of
each file on my personal copy of the D-Base, and I can update the tables
just
fine.

My problem; I'm about ready to send this D-Base out to other users. Some of
them will be on a network and others on standalone computers. I need to
find
away to allow the user to define where these external files are. Any Ideas
how I should start to tackle this?

Note: I'm VBA DUMB (but willing)
Thanks.