I am a memberships manager and I need to build a database in ACCESS that tells me:
1. Their names and contact info
2. When their memberships expire.
I also want to be able to scan in their original application and see a pop-up when they are about to expire in 24 hours. I would also like to send them an email through the database. Can anyone help?
2006-09-20 04:41:52 · 4 answers · asked by Queen G 1 in Computers & Internet ➔ Programming & Design
check your reference guides for code blocks that look at NOW() functions and other functions. In all likelihood you'll need to build a VB Code block to check the date/time stamp against current system and initiate the pop-up screen as you mouse over or open the record.
I've done some similar programming but not for some time so I am bit rusty on the VB exact syntax.
2006-09-20 04:52:18 · answer #1 · answered by Anonymous · 0⤊ 0⤋
What kind of help are you looking for? If you already have some experience with Access or other DBMSs, I might be able to give you some guidance towards how to go about doing what you want. But if you have no prior knowledge of working with Databases, then this could be one challenging task.
rohit.chaurasia@tcs.com
2006-09-20 04:45:38 · answer #2 · answered by SmartSpider 4 · 0⤊ 0⤋
Are you asking the "schema" of it?
The abstract is membership(name, physical_address, EMAIL_ADDRESS, expiry_date, member_id)
What suppose to go in their original application? Don't exactly matter if you know exactly what to program.
2006-09-20 05:01:00 · answer #3 · answered by Andy T 7 · 0⤊ 0⤋
This is a challenging question. But Imay be able to help you.
2006-09-20 05:13:02 · answer #4 · answered by Briseis 1 · 0⤊ 0⤋