select field

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Heres what im looking to do

I make a new query, and go into Design View
In the Field area i want to be able to make a prompt for a use to type in what field they want shown. Kind of like doing a ["question"] but for the field area

Whenever i try putting in ["please insert field"] it adds it as an Exp1: ["please insert field"

This does not work

Is there any way to make a prompt for a user so they can type in the field that they would like shown

Thanks much in advance

--Crazy
 
we have a unknown Field..

using [Please Insert Field] in the criteria row you must have a field

Im needing it to prompt for a Field not a Criteri

any other suggestions


----- Marin Kostov wrote: ----

In the Criteria row for that Field type [Please Insert Field
 
This is interesting... How could the user select a Field, if he/she has NO
IDEA which fields are in the database? And how would be able the DB display
a "Field", that for example does NOT EXIST?
Maybe this will solve your problem:
First, when the form opens, you need to populate a List Box or a combo box
with the fields in your database.
Then, when the user select a field from that control and clicks a button,
the query will have the following syntax:
"SELECT" & lstRecordSource.Value & "FROM tblMain;"
At that time I could not write a code, or make a suggestion, how to populate
the List or Combo Box with the fields of the table.
 
-----Original Message-----
we have a unknown Field...
Click to expand...

I'm with Marian's statement. If your prompting the user
for a field, most likely you'll get upset users since they
don't know what your talking about nor know what a field
or a table is (in Access terms).

If your going to do this, I'd think of all the
possibilities and make query's off of that. Then prompt
the user (using Yes/No message boxes) for the correct type
of data that they need.
 
Back
Top