[mso] Re: Date in Access
- From: "Colli, Anthony G" <Anthony.Colli@xxxxxxx>
- To: <mso@xxxxxxxxxxxxx>
- Date: Fri, 31 Jan 2003 09:08:39 -0500
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).
//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).
//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:
