Parameter Queries

[tinab]

I am using Acces XP and am trying to run a parameter query using a
form that I made to enter criteria. The problem is the default MS
Access form asking for criteria always opens instead. I am not trying
to run the query and hope that the form opens. I open the form and
enter my parameter and the Access box opens instead of my form or in
addition to my form (I have tried many scenarios). I tried doing this
on another computer with Access 2000 and it worked OK. Does anyone
know if this is a bug in Access XP??

ALso, I tried to do the tutorial at
http://support.microsoft.com/kb/q209645 with Access 2000 and the first
few times searches returned the correct records but after that it did
not. When I looked at the query again it had changed and the Is Null
part of the parameter that I entered in the criteria of the
WhatCustomer and WhatEmployee fields had then become a column. I am
trying desperately to make sense of all this!

 

[John Vinson]

I am using Acces XP and am trying to run a parameter query using a
form that I made to enter criteria. The problem is the default MS
Access form asking for criteria always opens instead. I am not trying
to run the query and hope that the form opens. I open the form and
enter my parameter and the Access box opens instead of my form or in
addition to my form (I have tried many scenarios). I tried doing this
on another computer with Access 2000 and it worked OK. Does anyone
know if this is a bug in Access XP??

Please open the Query in SQL view and post it here. Also post the Name
properties of the form you're using, and of the control on that form
you're using for the criterion. You say "the default MS Access form
asking for criteria" - do you mean the parameter popup box? That will
open if Access cannot find an form or control exactly matching your
criterion. For instance, if you have a form named My Form, and use a
criterion

=[Forms]![MyForm]![txtCriterion]

you'll get a prompt for [Forms]![MyForm]![txtCriterion] because the
text strings "My Form" and "MyForm" are not identical.

It's conceivable that your database is corrupted (2000 was notorious
for subtle infuriating corruption :-{( ); have you tried Tools...
Database Utilities... Compact and Repair?

ALso, I tried to do the tutorial at
http://support.microsoft.com/kb/q209645 with Access 2000 and the first
few times searches returned the correct records but after that it did
not. When I looked at the query again it had changed and the Is Null
part of the parameter that I entered in the criteria of the
WhatCustomer and WhatEmployee fields had then become a column. I am
trying desperately to make sense of all this!

It will do that. The extra columns are just how the query design
window displays the SQL when you use the OR IS NULL logic. It's
actually easier to understand the SQL than it is to understand the
grid, once you get the hang of it!

John W. Vinson[MVP]
Join the online Access Chats
Tuesday 11am EDT - Thursday 3:30pm EDT
http://community.compuserve.com/msdevapps