Parameter query question

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

Guest

I set up a parameter query where the user enters a date. For some reason,
the "enter parameter value" box now comes up twice and the user needs to
enter the date twice before viewing the query results. I looked at the query
in design view and nothing has changed on it. Any ideas why this might be
happening? This is the criteria I entered into the query's date field:

[Enter Reminder Date]

Thanks!
 
SELECT tbleLOCAgreements.ID, tbleLOCAgreements.Supplier,
tbleLOCAgreements.[Agreement #], tbleLOCAgreements.[Date Submitted],
tbleLOCAgreements.[Date Due], tbleLOCAgreements.[Date Received],
tbleLOCAgreements.[Next Reminder Date], tbleLOCAgreements.Status,
tbleLOCAgreements.[Member Group], tbleLOCAgreements.Name,
tbleLOCAgreements.[Bar Code], tbleLOCAgreements.[Last Name],
tbleLOCAgreements.[First Name], tbleLOCAgreements.Notes
FROM tbleLOCAgreements
WHERE (((tbleLOCAgreements.[Next Reminder Date])=[Enter Reminder Date]));

--
Tina


Duane Hookom said:
Post the SQL view of your query.
--
Duane Hookom
Microsoft Access MVP


Tina said:
I set up a parameter query where the user enters a date. For some reason,
the "enter parameter value" box now comes up twice and the user needs to
enter the date twice before viewing the query results. I looked at the query
in design view and nothing has changed on it. Any ideas why this might be
happening? This is the criteria I entered into the query's date field:

[Enter Reminder Date]

Thanks!
Click to expand...
Click to expand...
 
This looks ok to me (other than field names with spaces & symbols and a
field named "Name" ;-( ).

Do you get the enter parameter twice when directly opening the query or when
attempting to open a form or report?

Try copy and paste the SQL into a new blank query and see if you get
prompted twice.

--
Duane Hookom
Microsoft Access MVP


Tina said:
SELECT tbleLOCAgreements.ID, tbleLOCAgreements.Supplier,
tbleLOCAgreements.[Agreement #], tbleLOCAgreements.[Date Submitted],
tbleLOCAgreements.[Date Due], tbleLOCAgreements.[Date Received],
tbleLOCAgreements.[Next Reminder Date], tbleLOCAgreements.Status,
tbleLOCAgreements.[Member Group], tbleLOCAgreements.Name,
tbleLOCAgreements.[Bar Code], tbleLOCAgreements.[Last Name],
tbleLOCAgreements.[First Name], tbleLOCAgreements.Notes
FROM tbleLOCAgreements
WHERE (((tbleLOCAgreements.[Next Reminder Date])=[Enter Reminder Date]));

--
Tina


Duane Hookom said:
Post the SQL view of your query.
--
Duane Hookom
Microsoft Access MVP


Tina said:
I set up a parameter query where the user enters a date. For some reason,
the "enter parameter value" box now comes up twice and the user needs to
enter the date twice before viewing the query results. I looked at the query
in design view and nothing has changed on it. Any ideas why this might be
happening? This is the criteria I entered into the query's date field:

[Enter Reminder Date]

Thanks!
Click to expand...
Click to expand...
Click to expand...
 
Yes, I get the enter parameter twice when I click directly on the query and
also when I click on the command button on the switchboard that calls the
query.

I took your suggestion and pasted the sql into a new query and it seems to
be working fine now. Thanks for the suggestion.
--
Tina


Duane Hookom said:
This looks ok to me (other than field names with spaces & symbols and a
field named "Name" ;-( ).

Do you get the enter parameter twice when directly opening the query or when
attempting to open a form or report?

Try copy and paste the SQL into a new blank query and see if you get
prompted twice.

--
Duane Hookom
Microsoft Access MVP


Tina said:
SELECT tbleLOCAgreements.ID, tbleLOCAgreements.Supplier,
tbleLOCAgreements.[Agreement #], tbleLOCAgreements.[Date Submitted],
tbleLOCAgreements.[Date Due], tbleLOCAgreements.[Date Received],
tbleLOCAgreements.[Next Reminder Date], tbleLOCAgreements.Status,
tbleLOCAgreements.[Member Group], tbleLOCAgreements.Name,
tbleLOCAgreements.[Bar Code], tbleLOCAgreements.[Last Name],
tbleLOCAgreements.[First Name], tbleLOCAgreements.Notes
FROM tbleLOCAgreements
WHERE (((tbleLOCAgreements.[Next Reminder Date])=[Enter Reminder Date]));

--
Tina


Duane Hookom said:
Post the SQL view of your query.
--
Duane Hookom
Microsoft Access MVP


:

I set up a parameter query where the user enters a date. For some reason,
the "enter parameter value" box now comes up twice and the user needs to
enter the date twice before viewing the query results. I looked at the query
in design view and nothing has changed on it. Any ideas why this might be
happening? This is the criteria I entered into the query's date field:

[Enter Reminder Date]

Thanks!
Click to expand...
Click to expand...
Click to expand...
 
=?Utf-8?B?RHVhbmUgSG9va29t?= said:
(...) Try copy and paste the SQL into a new blank query and see if you get
prompted twice.

--
Duane Hookom
Microsoft Access MVP
Click to expand...
Thanks for the tip - this worked for me too!
 
Back
Top