Date Changes

[HandSam]

What code should I use for the system to carry out a certain action every time it is a certain date of every month. eg if the date is 5th, the system should invoice all tenants with rent of the value of the house they live in. I am unable to work with the date changes.

Every time we get to a new month, I want the rent system to update the rent balance value. Please assist

 

[John Big Booty]

Assuming your DB is closed down at the end of each day, you could test the date in the On Load event of your Menu form, and fire the code from there.

 

[Estuardo]

G'd afternoon,
For a complete automated process you may want to use the windows task manager to run a bat file to open a db built an designed only to send/print the invoices, stored in a 24/7 pc/server.
What John suggest may work for workdays and will always be dependent on human intervention, plus if is a multiuser db may imply a different FE for at least one PC or change all FE's do add a routine to check if the task is active or not.
But all this depends more on your environment than anything else.