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.

 

[PieterLinden via AccessMonster.com]

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.

Macros. Yuck.
I would probably use a table for whatever file type/location you need. Then
you can use the BrowseFolder API to let the user select the proper folder and
then store that path back to the table. Then once you have that, you can run
your code no problem.
Can't be done without VBA. But the VBA is pretty much canned. All freely
available and documented on AccessWeb. www.mvps.org/access in the APIs
section. Either BrowseFolder (choose folder) or OpenSaveFileAPI (select
single file).