Question Auto add new data on new day-period

[optionone]

Hi,

I have been asked to build a database to capture client information - the difference being that the data would need to 'update' every day (or period) itself, where as I am used to only building databases that I control - eg transferring data, manipulating with a query etc.

As an example if the client is booked in on day 1, then when day 2 hits it would automatically add new info (etc until the client is booked out). I guess this doesnt have to happen in realtime or everyday as long as it fills in the data from last run on next db open.

Could someone advise whether access is best for this and where I could look to try and understand this better? I am quite lost

Thanks

 

[vbaInet]

Thoughts:

You could use the form's Timer event of a form.

OR

Create a scheduled task that would open the database at a time noone would be at work, say in the very early hours of the morning and have an event that performs the check on opening the database. This event could run in your splash screen or switchboard.