Date Form

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

dhoover - 16 Jan 2007 19:15 GMT

I've created several Queries with a paramter [Date]. In the criteria line of
this field, I put "Is Not Null And Between [Forms]![Reporting Dialog]!
[MonthBeginning] And [Forms]![Reporting Dialog]![MonthEnding]" so that it
will open a form called Reporting Dialog that already has the dates plugged
in and all the user has to do is click ok.

This works just fine for some queries, but for others, it prompts the user to
actually input the parameter. Why would this only work with some queries?

Reply to this Message

Douglas J. Steele - 16 Jan 2007 19:27 GMT

Is the form open when you're prompted? (Access won't open it for you if it
isn't).

If it is open, might you have mistyped the form name or the control names?

Signature

Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no e-mails, please!)

> I've created several Queries with a paramter [Date]. In the criteria line
> of
[quoted text clipped - 7 lines]
> to
> actually input the parameter. Why would this only work with some queries?

Reply to this Message

dhoover - 16 Jan 2007 19:37 GMT

No the form isn't open prior to running the queries in any of the cases.
Sometimes the form automatially opens and sometimes it doesn't when the query
is ran.

>Is the form open when you're prompted? (Access won't open it for you if it
>isn't).
[quoted text clipped - 6 lines]
>> to
>> actually input the parameter. Why would this only work with some queries?

Reply to this Message

John Vinson - 16 Jan 2007 19:50 GMT

>No the form isn't open prior to running the queries in any of the cases.
>Sometimes the form automatially opens and sometimes it doesn't when the query
>is ran.

Something else is opening the form (or making it visible) then,
because the query will NOT do so.

John W. Vinson[MVP]

Reply to this Message

dhoover - 16 Jan 2007 19:52 GMT

hmm, I'm have to dig to see what would be causing that. Thanks!

>>No the form isn't open prior to running the queries in any of the cases.
>>Sometimes the form automatially opens and sometimes it doesn't when the query
[quoted text clipped - 4 lines]
>
> John W. Vinson[MVP]

Reply to this Message

fredg - 16 Jan 2007 19:52 GMT

> No the form isn't open prior to running the queries in any of the cases.
> Sometimes the form automatially opens and sometimes it doesn't when the query
[quoted text clipped - 10 lines]
>>> to
>>> actually input the parameter. Why would this only work with some queries?

You are mistaken about the query opening the form.
Queries do not open forms! Queries do not open reports. Queries do not
open anything. Queries display or manipulate or alter data.

Perhaps your query is used as the record source for a report.
Report's can (if you have coded it to do so) open a form to be used as
parameter entry. Check the report's Open event.

Signature

Fred
Please respond only to this newsgroup.
I do not reply to personal e-mail

Reply to this Message