Item 1 pseudo code
form load event
execute passthru query into recordset
calendarBox1 = recordset(date1)
calendarBox2 = recordset(date2)
me.refresh 'if necessary
me.requery 'if necessary
Item 2 query
SELECT * FROM tblSomething WHERE Date1 = Forms![frmMain]![calendarBox1];
Item 3
If you used the wizard, it may have set parameters in the query based on
your responses. look at the code in the wizard
Good Luck
Hal
Hal McGee
Engineering Data Manager
Group Engineering - Process and Compliance
Seating Products Group
B/E Aerospace
Winston-Salem, NC
"bitschon"
<[EMAIL PROTECTED]
l.net> To
Sent by: [email protected]
AccessDevelopers@ cc
yahoogroups.com
Subject
[AccessDevelopers] set date of
06/23/2005 03:43 calendars via query and some newby
PM questions
Please respond to
AccessDevelopers@
yahoogroups.com
I want to set the start dates of two calendars at open of form by a
pass-through query. How do I do this?
How do you pass parameters from the calendar to another (main) query?
Why am I getting prompted for parameters when I am executing a query
from a form/command button when I have not set up any and do not want
them?
Thanks,
John
Please zip all files prior to uploading to Files section.
Yahoo! Groups Links
To visit your group on the web, go to:
http://groups.yahoo.com/group/AccessDevelopers/
To unsubscribe from this group, send an email to:
[EMAIL PROTECTED]
Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.
Please zip all files prior to uploading to Files section.
Yahoo! Groups Links
<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/AccessDevelopers/
<*> To unsubscribe from this group, send an email to:
[EMAIL PROTECTED]
<*> Your use of Yahoo! Groups is subject to:
http://docs.yahoo.com/info/terms/
