Easily go from one data set to another?

[Ron]

I've set up a front end and link to a back end where all the data is stored
at (sharednetworkdrive)\MyData\data1. On that same back end, I also have
another office's data in MyData\data2. And another's in MyData\data3, etc.
I would have preferred to set it up as one dataset and then just look for
office1ID, office2ID, office3ID, etc but due to reasons beyond my control,
it wasn't possible. I needed to completely separate the data even though
all the offices have the same data structures, reports, queries etc.

I'd like the user to be able to select office 1 off a menu of some sort, do
the work required and "close" that office, then select office 3, do work for
that office, "close" it, then select 2, etc. I'm stumped as to how to do
that within Access so it's easy for the user.

The kicker is an additional feature I'd like to have. If another data file
is added at a later date, say in MyData\Data4, the menu feature would
automatically now show 4 data files and allow the user to select 1 through 4
rather than me having to hardcode it into the menu each time a new office is
added. Possible?

Any suggestions for either? Both? I don't expect anyone to write code for
me, but can you point me to some examples of similar ideas I might be able
to adapt to my particular needs.

TIA
ron

[MGFoster]

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

Use the TransferDatabase method of the DoCmd object to link new tables
to the front end (first delete the links to the old tables).

You can fill a ListBox w/ the file names in a folder by using the Dir()
function and the ListBox's .AddItem method (if Access 2000, or higher
version. If an earlier version you can use the example in the Access
Help article on RowSourceType user-defined function).

--
MGFoster:::mgf00 <at> earthlink <decimal-point> net
Oakland, CA (USA)

-----BEGIN PGP SIGNATURE-----
Version: PGP for Personal Privacy 5.0
Charset: noconv

iQA/AwUBQdBrMIechKqOuFEgEQIvQACguGAXGJEaTJ3yZYIHPOxtBM sxlSgAoPpV
vrTzh0qrrKCSVgGtbzHJ7Bqp
=1GGt
-----END PGP SIGNATURE-----

Ron wrote:

I've set up a front end and link to a back end where all the data is stored
at (sharednetworkdrive)\MyData\data1. On that same back end, I also have
another office's data in MyData\data2. And another's in MyData\data3, etc.
I would have preferred to set it up as one dataset and then just look for
office1ID, office2ID, office3ID, etc but due to reasons beyond my control,
it wasn't possible. I needed to completely separate the data even though
all the offices have the same data structures, reports, queries etc.

I'd like the user to be able to select office 1 off a menu of some sort, do
the work required and "close" that office, then select office 3, do work for
that office, "close" it, then select 2, etc. I'm stumped as to how to do
that within Access so it's easy for the user.

The kicker is an additional feature I'd like to have. If another data file
is added at a later date, say in MyData\Data4, the menu feature would
automatically now show 4 data files and allow the user to select 1 through 4
rather than me having to hardcode it into the menu each time a new office is
added. Possible?

Any suggestions for either? Both? I don't expect anyone to write code for
me, but can you point me to some examples of similar ideas I might be able
to adapt to my particular needs.

TIA
ron