Query By Form - Questions

[Roger Tregelles]

I have a question in connection with Queries By Form.

I have created a simple QBF based on the KB Article 304428. The query works
just fine as long as you type in the exact text of what you are searching
for. It appears that you cannot use any wildcard expressions (ex. John*) or
other common parameters (ex. between 1/1/05 and 2/1/05). When you use these
expressions the query comes back empty. Does anybody know how I can use these
expressions and parameters in QBF query?

Also, when I created the Query I entered an exact string in the criteria
(based on the KB article) such as:

Forms![frm_QBF_Supplier]![WhatNCR] Or Forms![frm_QBF_Supplier]![WhatNCR] Is
Null

When I go to look at the Query in design view (after using it) the string I
entered no longer looks like above, but is in some cases now up to 4 lines
which read:
[Forms]![frm_QBF_Supplier]![WhatNCR]
[Forms]![frm_QBF_Supplier]![WhatNCR]
[Forms]![frm_QBF_Supplier]![WhatNCR]
[Forms]![frm_QBF_Supplier]![WhatNCR]

Is this normal? The query works correctly (it has three other fields to
query on) but I do wonder why it has changed the string I entered.

The reason I am using the QBF function is that I do not want the Users of
the front-ends I create to be dropped out of the Switchboard (part of my
compnay's validation requirements) when running a Query. Any help, advice or
direction would be greatly appreciated. Thanks in advance for any and all
help received.

Roger Tregelles
Quality Assurance Engineer
Respironics Inc.

 

[Roger Tregelles]

Can anybody please help me out with my question here? Is there another way to
do what I am asking to do other than using QBF? Thanks so much.

 

[Duane Hookom]

Consider using an applet like the one at
http://www.rogersaccesslibrary.com/OtherLibraries.asp#Hookom,Duane. This
query by form can be used and re-used without issues like you are
experiencing.