Time Based Form Creation

[Brett Patterson]

Hi Guys.

Not sure if this is possible, but I'll ask anyway. I have a form that I
have made, and I want to dynamically send data to that form, automatically.
I say automatically because I want the form to be created when the date is
older than 14 days AND the status is "Awaiting Pickup".

I know that on a web-based service it is known as a Cron-Job, but what and
more importantly HOW would I go about doing this for Access?

Thanks for your help.

 

[Lynn Trapp]

Not sure if this is possible, but I'll ask anyway. I have a form that I

have made, and I want to dynamically send data to that form, automatically.
I say automatically because I want the form to be created when the date is
older than 14 days AND the status is "Awaiting Pickup".

Brett,
It sounds like what you need is a query that searches for all records that
are older than 14 days and have a status of "Awaiting Pickup." You could
then use that query as the Record Source for the form you build.

UMBC EHS Management Major

My wife got her bachelor's degree, in English, from UMBC

 

[Brett Patterson]

Brett,
It sounds like what you need is a query that searches for all records that
are older than 14 days and have a status of "Awaiting Pickup." You could
then use that query as the Record Source for the form you build.

Ok, I understand that. My question is this: is this a proper query? or am i
missing something?

SELECT * FROM

WHERE (Today()-14>

.[date_field]) AND

.[status] = "Awaiting Pickup";

My wife got her bachelor's degree, in English, from UMBC

What a small world.....

 

[Lynn Trapp]

The syntax of that query is quite correct. You will need to run it to verify
that you are getting the data that you expected.

--
Lynn Trapp
MS Access MVP
www.ltcomputerdesigns.com
Access Security: www.ltcomputerdesigns.com/Security.htm

Brett,
It sounds like what you need is a query that searches for all records that
are older than 14 days and have a status of "Awaiting Pickup." You could
then use that query as the Record Source for the form you build.

Ok, I understand that. My question is this: is this a proper query? or am i
missing something?

SELECT * FROM

WHERE (Today()-14>

.[date_field]) AND

.[status] = "Awaiting Pickup";

My wife got her bachelor's degree, in English, from UMBC

What a small world.....

--
Lynn Trapp
MS Access MVP
www.ltcomputerdesigns.com
Access Security: www.ltcomputerdesigns.com/Security.htm

 

[Lynn Trapp]

Oops... ignore my first response, Brett. The Where statement should be:

WHERE (Date() - 14 >

.[date_field]) AND

.[status] = "Awaiting
Pickup"

--
Lynn Trapp
MS Access MVP
www.ltcomputerdesigns.com
Access Security: www.ltcomputerdesigns.com/Security.htm

Brett,
It sounds like what you need is a query that searches for all records that
are older than 14 days and have a status of "Awaiting Pickup." You could
then use that query as the Record Source for the form you build.

Ok, I understand that. My question is this: is this a proper query? or am i
missing something?

SELECT * FROM

WHERE (Today()-14>

.[date_field]) AND

.[status] = "Awaiting Pickup";

My wife got her bachelor's degree, in English, from UMBC

What a small world.....

--
Lynn Trapp
MS Access MVP
www.ltcomputerdesigns.com
Access Security: www.ltcomputerdesigns.com/Security.htm

 

[Brett Patterson]

Thanks for the help. Will do!!

Oops... ignore my first response, Brett. The Where statement should be:

WHERE (Date() - 14 >

.[date_field]) AND

.[status] = "Awaiting
Pickup"

--
Lynn Trapp
MS Access MVP
www.ltcomputerdesigns.com
Access Security: www.ltcomputerdesigns.com/Security.htm

Not sure if this is possible, but I'll ask anyway. I have a form that I
have made, and I want to dynamically send data to that form,
automatically.
I say automatically because I want the form to be created when the date is
older than 14 days AND the status is "Awaiting Pickup".

Brett,
It sounds like what you need is a query that searches for all records that
are older than 14 days and have a status of "Awaiting Pickup." You could
then use that query as the Record Source for the form you build.

Ok, I understand that. My question is this: is this a proper query? or am i
missing something?

SELECT * FROM

WHERE (Today()-14>

.[date_field]) AND

.[status] = "Awaiting Pickup";

UMBC EHS Management Major

My wife got her bachelor's degree, in English, from UMBC

What a small world.....

--
Lynn Trapp
MS Access MVP
www.ltcomputerdesigns.com
Access Security: www.ltcomputerdesigns.com/Security.htm