By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,988 Members | 1,367 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,988 IT Pros & Developers. It's quick & easy.

Recurring Dates

P: 9
I am new to access, can some tell me how to setup "reoccuring Dates". I need to setup a PM schedule every week, month, year?
May 8 '07 #1
Share this Question
Share on Google+
10 Replies


Rabbit
Expert Mod 10K+
P: 12,349
Set up reoccuring dates for what? What is it that you want to do on those dates?
May 8 '07 #2

P: 9
Set up reoccuring dates for what? What is it that you want to do on those dates?
I need to show a "memo" field on a weelky , mounthly, yearly bases.
Example, "Clean macine each week" listed from my form memo field.
May 8 '07 #3

Rabbit
Expert Mod 10K+
P: 12,349
In the On Load event of the form it would check to see if the current date matches your chosen reoccuring series.
May 8 '07 #4

P: 9
I am new to access, can some tell me how to setup "reoccuring Dates". I need to setup a PM schedule every week, month, year?

SELECT DISTINCTROW PMPRINTMONTHLY.AssetDescription, PMPRINTMONTHLY.[Initial Start Date PM], PMPRINTMONTHLY.[Sum Of Weekly] AS [Sum Of Sum Of Weekly], PMPRINTMONTHLY.[First Of PM Task List Weekly] AS [First Of First Of PM Task List Weekly], PMPRINTMONTHLY.Comments AS [First Of Comments], Assets.[PM Task List Weekly], PMPRINTMONTHLY.[Sum Of Monthly] AS [Sum Of Sum Of Monthly]
FROM Assets INNER JOIN PMPRINTMONTHLY ON Assets.AssetDescription = PMPRINTMONTHLY.AssetDescription
WHERE (((PMPRINTMONTHLY.[Initial Start Date PM]) Between [START DATE OF WEEK] And [END DATE OF WEEK]) AND ((PMPRINTMONTHLY.[Sum Of Weekly])=Yes));
May 8 '07 #5

Rabbit
Expert Mod 10K+
P: 12,349
SELECT DISTINCTROW PMPRINTMONTHLY.AssetDescription, PMPRINTMONTHLY.[Initial Start Date PM], PMPRINTMONTHLY.[Sum Of Weekly] AS [Sum Of Sum Of Weekly], PMPRINTMONTHLY.[First Of PM Task List Weekly] AS [First Of First Of PM Task List Weekly], PMPRINTMONTHLY.Comments AS [First Of Comments], Assets.[PM Task List Weekly], PMPRINTMONTHLY.[Sum Of Monthly] AS [Sum Of Sum Of Monthly]
FROM Assets INNER JOIN PMPRINTMONTHLY ON Assets.AssetDescription = PMPRINTMONTHLY.AssetDescription
WHERE (((PMPRINTMONTHLY.[Initial Start Date PM]) Between [START DATE OF WEEK] And [END DATE OF WEEK]) AND ((PMPRINTMONTHLY.[Sum Of Weekly])=Yes));
I have no idea what this is for. Other than that it selects records and filters for a date range, I don't know what you want to do with this query.
May 8 '07 #6

P: 9
I have no idea what this is for. Other than that it selects records and filters for a date range, I don't know what you want to do with this query.
Sorry, I have a date range that will show a report with in a date range. I need to have the report run weekly. The report represents task weekly.
May 8 '07 #7

Rabbit
Expert Mod 10K+
P: 12,349
Sorry, I have a date range that will show a report with in a date range. I need to have the report run weekly. The report represents task weekly.
Well, then you can do what I mentioned earlier and in the On Load event of a form, like the switchboard, it will check to see if it's the last day of the week and if it is, opens the report.
May 8 '07 #8

P: 9
Well, then you can do what I mentioned earlier and in the On Load event of a form, like the switchboard, it will check to see if it's the last day of the week and if it is, opens the report.
Thanks...I am unclear what you mean , can you tell me what I need to do at the "on load" part of my form. I opened the form and and found onload, do I select on event?
May 8 '07 #9

Rabbit
Expert Mod 10K+
P: 12,349
Thanks...I am unclear what you mean , can you tell me what I need to do at the "on load" part of my form. I opened the form and and found onload, do I select on event?
In the On Load property, if you click the little box with 3 dots on the far right, there'll be a popup, choose code builder and it will bring you to the VBA editor.

That's where you do the coding.
May 8 '07 #10

P: 9
In the On Load property, if you click the little box with 3 dots on the far right, there'll be a popup, choose code builder and it will bring you to the VBA editor.

That's where you do the coding.
Thank you.....
May 8 '07 #11

Post your reply

Sign in to post your reply or Sign up for a free account.