Force input box with blank field names

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

Guest

Can I write a query to force a popup with a missing field name? I know a
missing value will force a popup.

I've tried this but it doesnt work

Select * from home
where [Enter Field Name] is null


(e-mail address removed)
 
Let me add to that. A popup will apear. It will give you a blank table instead
of a query with null values.
(e-mail address removed)
 
You can't use a parameter like this. You could change the criteria to
something like:
WHERE Choose([Enter 1-Last Name 2-First Name 3-City], [LastName],
[FirstName], [City]) Is Null
 
Dear Spam:

In a situation like this, you could initiate the query from a form.
On that form you could then have a combo box with a Value List of the
various column names the user might choose for [Enter Field Name].

Then, when the usere initiates the query (probably with a command
button on that same form) you could generate the SQL string filling in
the selected field name. Just what you do with that SQL string
depends on where you are going with this. Your could, for example,
assign the SQL as the RecordSource of a subform right on that form, in
which to display the query results. Or it could become the
RecordSource for a report, or the RowSource for a combo box.

Can I write a query to force a popup with a missing field name? I know a
missing value will force a popup.

I've tried this but it doesnt work

Select * from home
where [Enter Field Name] is null


(e-mail address removed)
Click to expand...

Tom Ellison
Ellison Enterprises - Your One Stop IT Experts
 
Nice. Don't know why I missed that. Almost obvious. I'm always making pulldowns
on forms. I guess I was used to the way the people who did it before me did it.
Always forcing values popping up. So the answer is, no, not with a forced
popup, but yes, supplying field names and letting them pick from a list. Cool.
Thanks.

Subject: Re: Force input box with blank field names
From: Tom Ellison (e-mail address removed)
Date: 10/3/2003 12:08 AM Eastern Standard Time
Message-id: <[email protected]>

Dear Spam:

In a situation like this, you could initiate the query from a form.
On that form you could then have a combo box with a Value List of the
various column names the user might choose for [Enter Field Name].

Then, when the usere initiates the query (probably with a command
button on that same form) you could generate the SQL string filling in
the selected field name. Just what you do with that SQL string
depends on where you are going with this. Your could, for example,
assign the SQL as the RecordSource of a subform right on that form, in
which to display the query results. Or it could become the
RecordSource for a report, or the RowSource for a combo box.

Can I write a query to force a popup with a missing field name? I know a
missing value will force a popup.

I've tried this but it doesnt work

Select * from home
where [Enter Field Name] is null


(e-mail address removed)
Click to expand...

Tom Ellison
Ellison Enterprises - Your One Stop IT Experts







(e-mail address removed)
 
Not for column names, only for values.

Nice. Don't know why I missed that. Almost obvious. I'm always making pulldowns
on forms. I guess I was used to the way the people who did it before me did it.
Always forcing values popping up. So the answer is, no, not with a forced
popup, but yes, supplying field names and letting them pick from a list. Cool.
Thanks.

Subject: Re: Force input box with blank field names
From: Tom Ellison (e-mail address removed)
Date: 10/3/2003 12:08 AM Eastern Standard Time
Message-id: <[email protected]>

Dear Spam:

In a situation like this, you could initiate the query from a form.
On that form you could then have a combo box with a Value List of the
various column names the user might choose for [Enter Field Name].

Then, when the usere initiates the query (probably with a command
button on that same form) you could generate the SQL string filling in
the selected field name. Just what you do with that SQL string
depends on where you are going with this. Your could, for example,
assign the SQL as the RecordSource of a subform right on that form, in
which to display the query results. Or it could become the
RecordSource for a report, or the RowSource for a combo box.

Can I write a query to force a popup with a missing field name? I know a
missing value will force a popup.

I've tried this but it doesnt work

Select * from home
where [Enter Field Name] is null


(e-mail address removed)
Click to expand...

Tom Ellison
Ellison Enterprises - Your One Stop IT Experts







(e-mail address removed)
Click to expand...

Tom Ellison
Ellison Enterprises - Your One Stop IT Experts
 
It works for column names. Just have to populate a combobox and pass it to the
query.
(e-mail address removed)
 
Back
Top