John Nurick [Microsoft Access MVP]-Static/Global usage

[C. Pete Straman via AccessMonster.com]

1) I go out and read the data base name which will always include the
facility number IE-060002 Kansas, 060003 New York, etc.
2) I concatenate that name and use only facility number to make my new
table and append data to it IE-060002, 060003, etc.
3) This variable/table name is used all thru my program/sub routines.

Can you offer some help on coding this into my form?

The facility number is also part of the original table I start with. I
could search, find, and concatenate it to make my variable as well.

Currently I hard code the facility id in all locations of my code. I use
find/replace when I transfer the form from one mdb to another.

Thanks in advance.

C. Pete Straman

John Nurick [Microsoft Access MVP]-Looping through linked tables 3rd request

 

[John Nurick]

Answered in another group. Please don't start up so many threads, I'm
confused enough already.

1) I go out and read the data base name which will always include the
facility number IE-060002 Kansas, 060003 New York, etc.
2) I concatenate that name and use only facility number to make my new
table and append data to it IE-060002, 060003, etc.
3) This variable/table name is used all thru my program/sub routines.

Can you offer some help on coding this into my form?

The facility number is also part of the original table I start with. I
could search, find, and concatenate it to make my variable as well.

Currently I hard code the facility id in all locations of my code. I use
find/replace when I transfer the form from one mdb to another.

Thanks in advance.

C. Pete Straman

John Nurick [Microsoft Access MVP]-Looping through linked tables 3rd request