How to run a form to execute expired dates at the opening of a database?

[Patrick Ndimuku]

Hi
I have a database which i want to execute expired records which are tagged a date,at the opening of the database these expired i want them to be displayed on a form

many many thanks to my rescue
Patrick

[patjones]

Hi Patrick,

You're asking a pretty general question, so I can give you a general answer that really has multiple steps to it.

Essentially, you want to

1. set the form in question to open when the database opens
2. have a date query that runs in the On Open event of the form and,
3. display the results of that query on the form.

You may or may not know how to complete any number of these steps, which we could help you with further. But I would suggest looking into how to accomplish these steps and letting us know if you are having problems with a particular part of the process.

Pat

[Patrick Ndimuku]

Hi pat

thanks i was able to follow your steps it did right but, i was a bit wrong to generalise the question but my issue is that am building a database for loan management, i have worked on other issues like giving a loan with interest, they work fine but one problem i got is that i want the database when it is opening to be able to execute loans which are due and when i click on it, it opens a form with that loan which has expired, if in case there is no loan which due the form should appear that is my big problem thanks alot

[patjones]

Patrick,

You just need to have your form open and display the expired loans in say a list box using a simple query.

This being said, I think you are still asking way too general of a question. I'm pretty sure I understand what you're trying to do, but the steps I laid out previously should work. You have to teach yourself how to do each component of what you need to make this work, and then we can help you with specific issues that arise.

Pat