RE: Parameter query question

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

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" wrote:

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" wrote:

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" wrote:

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


"Tina" wrote:

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!
--
Tina
.

Relevant Pages

  • RE: Parameter query question
    ... Do you get the enter parameter twice when directly opening the query or when ... Try copy and paste the SQL into a new blank query and see if you get ... prompted twice. ... "Duane Hookom" wrote: ...
    (microsoft.public.access.queries)
  • Re: Unable to link two tables in access having identical fields
    ... twice, so I got four records for two phone calls. ... "Rick B" wrote: ... > he need to duplicate the data in a new table. ... > tell you how to do it from a query. ...
    (microsoft.public.access.queries)
  • Re: search two fields
    ... asked twice, then you did not enter the exact same prompt. ... Either the history, or the notes field. ... once for each field before the query runs. ...
    (microsoft.public.access.gettingstarted)
  • Re: Double-ebtries in Update Query
    ... >However, for one particular office only, it is updating the field TWICE, ie ... >I have no idea why Leeds is being updated twice, ... Care to post the SQL code of the query? ...
    (microsoft.public.access.queries)
  • Re: the User-defined-function called once or twice
    ... the function code is never executed again after that. ... that it will be called twice for each row in the query. ... > executes twice for each row, ...
    (microsoft.public.sqlserver.programming)