Simple Query Question - Access 2003

C

c02homer

I have a Tours database with an input form was set up with radio
buttons with text answers like this: "Horseback Riding on the Pony
Express Trail" or "White Water Rafting Down the Snake River."

I can create a query on the Tours field and I can put Like "*Horse*"
and get all the horseback riders. Then I can create a report just for
the Horseback riders. But that will give me some 18 different reports
and I don't want that. I would rather the tour director type in the
name of the tour via a prompt under the Tours field [Enter Tour Name]
so he can pull information on Tours as he needs it. Unfortunately,
although the director is familiar with the tours, he has to know the
exact language of the field, or he won't get any hits.

So, is there a way to use the prompt[] where the person querying
doesn't have to type "Horseback Riding on the Pony Express Trail" but
instead can just type "Horse"?
I would HUGELY appreciate any assistance!!

Thanks!
 
C

c02homer

Thank you Douglas for your reply!! I copied and pasted your prompt
into the query under the Tours field, but when I type "horse" I get no
hits. So I tried typing the entire field contents to test - and still
no hits. I removed the prompt and typed the string in the field and
got all the hits. Any other ideas? <hope> <hope> <hope> :eek:)
 
V

Van T. Dinh

"Horseback Riding on the Pony Express Trail" or "White Water Rafting Down
the Snake River" are probably only Label Captions on your Form and not what
you store in the Table. Note that the Query will only look at the data in
the Table and you may store (in the Table) something different from the Text
about, e.g. 1 for "Horseback Riding on the Pony Express Trail", 2 for "White
Water Rafting Down the Snake River".
 
C

c02homer

Thank you for taking time to examine my problem. However, "Horseback
Riding on the Pony Express Trail" IS the data in the field. It is
placed in the field when a user clicks the corresponding Radio Button
on an input form.

The prompting problem is one that comes up in other areas, too. Let's
say I have a Name field, and the field contains people's full names:
John T. Madden, Harry G. Reasoner, Jim J. Brown (I know, I know ... I
wouldn't put the full name in a single field, either, but I don't
always design these things - just have to design output reports - so
hang in there). I still would want the prompt to let me use only one
of the words in each field, e.g., Madden or Harry or J. It seems to me
that eons ago at some training class or the other that we were able to
adjust the prompt for partial entry - and when I saw Douglas Steele's
response, my heart jumped because it had that familiarity - but it
won't work. I even recreated it from scratch and it doesn't return any
hits. So, if you have any ideas, you'd have my eternal gratitude... ;o)
 
A

Albert D. Kallal

I still would want the prompt to let me use only one
of the words in each field, e.g., Madden or Harry or J. It seems to me
that eons ago at some training class or the other that we were able to
adjust the prompt for partial entry
Click to expand...

The suggestions made to you should work. Alternative, you likely are much
better off to make a search screen, as popping up a box is not that user
friendly anyway.

Here is some screen shots of how good searching should look

http://www.members.shaw.ca/AlbertKallal/Search/index.html

And, for reports...here is some good ideas also:
http://www.members.shaw.ca/AlbertKallal/ridesrpt/ridesrpt.html
 
T

Tom Wickerath

To add to Doug's original reply, add the Like keyword into the criteria:

Like "*" & [Enter Tour Name] & "*"

To add to Albert's suggestion to make a search screen, I think this is a much better suggestion
than forcing the user to type anything into a parameter box. For one thing, if your user has
dyslexic tendencies (for example types Jhon instead of John), then they still will not get any
hits. You can open a search form that includes a multi-select listbox. This will allow a user to
select one or more tour types and run the report. Achieving this goal will require that you learn
VBA code, but it's certainly a goal worth pursuing. If you'd like to have me send you a sample
report that works like this, just send me a personal e-mail message with a valid return e-mail
address.

Tom
_____________________________________


I have a Tours database with an input form was set up with radio
buttons with text answers like this: "Horseback Riding on the Pony
Express Trail" or "White Water Rafting Down the Snake River."

I can create a query on the Tours field and I can put Like "*Horse*"
and get all the horseback riders. Then I can create a report just for
the Horseback riders. But that will give me some 18 different reports
and I don't want that. I would rather the tour director type in the
name of the tour via a prompt under the Tours field [Enter Tour Name]
so he can pull information on Tours as he needs it. Unfortunately,
although the director is familiar with the tours, he has to know the
exact language of the field, or he won't get any hits.

So, is there a way to use the prompt[] where the person querying
doesn't have to type "Horseback Riding on the Pony Express Trail" but
instead can just type "Horse"?
I would HUGELY appreciate any assistance!!

Thanks!
 
C

c02homer

Thank You - Thank You - Thank You!!!

You have all helped me solve my immediate problem. Tom, I will send
you an email for your sample report because I agree that the search
window is much cleaner, clearer and nicer than the parameter box
(assuming I can decipher your address correctly!) But in the meantime,
the tour director can pull reports while work on learning to use this
new tool (AND I'm taking a VB class this spring ...)
Thanks to all again! You're wonderful!!
 
T

Tom Wickerath

Glad to help. Haven't received any message from you yet, so here is my temporary e-mail address.
Just get rid of the spaces, substitute the word "AT" with "@", and the word "dot" with a "."
(period):

AOS168 AT Comcast dot net

The second character is letter O, not zero. You should have an 18 character e-mail address. Can
you receive a file attachment at your indicated hotmail e-mail address? Perhaps I should just
try that....

Tom
____________________________________

Thank You - Thank You - Thank You!!!

You have all helped me solve my immediate problem. Tom, I will send
you an email for your sample report because I agree that the search
window is much cleaner, clearer and nicer than the parameter box
(assuming I can decipher your address correctly!) But in the meantime,
the tour director can pull reports while work on learning to use this
new tool (AND I'm taking a VB class this spring ...)
Thanks to all again! You're wonderful!!
 
Top