help needed for a beginner

harky

Hi
I need some serious help!!
I am a beginner with very little knowledge of access
I am looking to get a database to tell me who has not payed their bill, they have 30 days to pay it. if possible this could be a pop up alert telling me who hasnt paid. Then I need to send a email to that Id(client) asking them to settle the outstanding bill.

Thanks claire

Rabbit

How much experience do you have using the visual basic editor?

harky

Quote:

Originally Posted by Rabbit

How much experience do you have using the visual basic editor?

Not much i used it for a project in second yr of university

Rabbit

Are you able to design a query that returns records for those that are overdue?

harky

Quote:

Originally Posted by Rabbit

Are you able to design a query that returns records for those that are overdue?

Yes i can do that, although i haven't created it yet. Is it possible to run the query from the database on a webpage? If so do you know what code i should use if it is written in ASP?

Rabbit

Sorry, I don't know ASP, could transfer you to that forum if you want.

But in VBA I would do something along the lines of:

1) Set a recordset equal to that query.

2) If said recordset has a record count larger than 0 then pop up a message saying there are overdue records.

harky

Quote:

Originally Posted by Rabbit

Sorry, I don't know ASP, could transfer you to that forum if you want.

But in VBA I would do something along the lines of:

1) Set a recordset equal to that query.

2) If said recordset has a record count larger than 0 then pop up a message saying there are overdue records.

Thank you so much i would be very grateful if u could send me to the other forum

help needed for a beginner

re: help needed for a beginner

re: help needed for a beginner

re: help needed for a beginner

re: help needed for a beginner

re: help needed for a beginner

re: help needed for a beginner

Similar ASP / Active Server Pages bytes

/bytes/development

/bytes/it

/bytes/about