Parameter query question

[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!

 

[Guest]

Post the SQL view of your query.

 

[Guest]

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

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!

 

[Guest]

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

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

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!

 

[Guest]

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

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

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

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!

 

[Hasse]

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

--
Duane Hookom
Microsoft Access MVP

Thanks for the tip - this worked for me too!