[mso] Re: Date in Access

Glenda-

 Depending on how you set up your queries you have a few options.=20

 If your queries are querying other queries, use the same name for all =
the input parameters. If QryOne has a parameter of [Enter Date] and =
qryTwo has a parameter of [Enter Date] and the select statement is some =
thing like SELECT qryOne.*, qryTwo.* FROM qryOne INNER JOIN..... you =
will only be prompted once. Access will 'remember' the value.

 Also in code use an inputbox to input the date. But then you would have =
to create your own SQL statement and execute it. Possibly like=20
=20
 value =3D InputBox"Enter a Value"
 SQL =3D "SELECT * FROM tblOne WHERE Criteria =3D " & value
 db.Execute SQL
 SQL =3D "SELECT * FROM tblTwo WHERE Criteria =3D " & value
 db.Execute SQL


-Anthony





-----Original Message-----
From: Glenda Wells [mailto:gwells@xxxxxxxxxxx]
Sent: Thursday, January 30, 2003 7:21 PM
To: 'mso@xxxxxxxxxxxxx'
Subject: [mso] Date in Access


Hi All.  Things are going nicely in my new job...never a dull moment. =20
=20
I've got several queries to run with date as a parameter value.  The =
user
must type the desired date 8 times.  Is there a way to gather the date =
just
once then have all the queries pull from that?
=20
Thanks. /g


*************************************************************
You are receiving this mail because you subscribed to mso@xxxxxxxxxxxxx =
or MicrosoftOffice@xxxxxxxxxxxxxxxx

To send mail to the group, simply address it to mso@xxxxxxxxxxxxx

To Unsubscribe from this group, send an email to=20
mso-request@xxxxxxxxxxxxx?Subject=3Dunsubscribe

Or, visit the group's homepage and use the dropdown menu.  This will =
also allow you to change your email settings to digest or vacation (no =
mail).
http://www.freelists.org/webpage/mso

To be able to use the files section for sharing files with the group, =
send a request to mso-moderators@xxxxxxxxxxxxx and you will be sent an =
invitation with instructions.  Once you are a member of the files group, =
you can go here to upload/download files:
http://www.smartgroups.com/vault/msofiles
*************************************************************
*************************************************************
You are receiving this mail because you subscribed to mso@xxxxxxxxxxxxx or 
MicrosoftOffice@xxxxxxxxxxxxxxxx

To send mail to the group, simply address it to mso@xxxxxxxxxxxxx

To Unsubscribe from this group, send an email to 
mso-request@xxxxxxxxxxxxx?Subject=unsubscribe

Or, visit the group's homepage and use the dropdown menu.  This will also allow 
you to change your email settings to digest or vacation (no mail).
http://www.freelists.org/webpage/mso

To be able to use the files section for sharing files with the group, send a 
request to mso-moderators@xxxxxxxxxxxxx and you will be sent an invitation with 
instructions.  Once you are a member of the files group, you can go here to 
upload/download files:
http://www.smartgroups.com/vault/msofiles
*************************************************************

Other related posts: