query- selecting a table...

[giladweil]

Hi,




1. How do I create a query that selects all data from a table, when the user selects what table will be displayed (using - [] at the Table line in the qurey does not work)?

2. If I want to make the choice in the query by the table codes, and not the name of the table (I have a separate MetaData table showing the code of each table), how do I create the connection?

Thank Watch so match...

[orange]

A query to select all data in the table can be written

SELECT * FROM TableName

But I think there is much more to your requirement than this.

What exactly are you trying to do? What experience do you have?

Who is "the user"?

How many such "users" will there be?

We need more context to be helpful to you.

[giladweil]

I am building a small database (50-60 tables of medium size). The database is Based on access and is part of an- "personal geo database" of ESRI format, though it is not relevant for this question. I built a form that appears automatically when opening the access file, and I want to create a link to a query that selects all the data in a specific table, that the user selects. (I have no programming background, I have used in similar queries [] to express a variable in aspecific field, but it does not work in choosing a table out of several different tables).

I have a table that gives index numbers for each table name, and I would like the query (=the user input) to search by the numeric code and not by name table.

[orange]

Do you have a data model?
You may want to look at
http://www.databaseanswers.org/data_models/index.htm
and
http://www.databaseanswers.org/approach2db_design.htm

for some general guidelines.

As for your query, you should post the SQL you are trying to use, and
show some details of your table structure.

[giladweil]

I'll try to explain the central issue of the question, the rest is less important:

How do I build a query (in SQL syntax, or with access interface) that shows me all the data in a table which is selected by the user (table name is variable).

Thanks

[NoellaG]

Hi,

to to this you will need some simple lines of code:
I presume the user chosses the tables out of a list or combo box on a form, and the data are shown in a subform. In this case you can add some code to the After Update event of the list that resembles:

Me.NameSubForm.Form.RecordSource = me.NameList

gr
NG