Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

LookTableName Onle

Status
Not open for further replies.
Rick4077

Rick4077

Technical User
Oct 19, 2004
149
US
I have a small program that I would like to have the ability, each time the program runs (basically a query) where I can have a pop up window present me with a list of tables (all in one directory) that I can select (just one) and pass to the query as a variable. I think?

Thanks .. . Rick
 
Sort by date Sort by votes
What I'm trying to do here is run a query, have it stop, open a window and present me with a list of tables.

Each of the tables that I'm looking for have two fields OFFICE NAME | CITY CODES

I would like to pass each field value for each occourance as a variable to the query.

Right now I run a separate query for all of my clients, but if I could select theie unique table and run the office names and city codes in that table I could use just one query for ALL of my clients.

People who know me understand that I work backwards. Ha!

Thanks . . . Rick
 
Upvote 0 Downvote
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top