Recurring Dates

[tjtj]

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?

[Rabbit]

Set up reoccuring dates for what? What is it that you want to do on those dates?

[tjtj]

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.

[Rabbit]

In the On Load event of the form it would check to see if the current date matches your chosen reoccuring series.

[tjtj]

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));

[Rabbit]

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.

[tjtj]

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.

[Rabbit]

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.

[tjtj]

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?

[Rabbit]

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.

[tjtj]

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.....