5 replies to this topic

[tlatix]

Hi, i'm starting up a small business but having trouble finding the software for my need.

Basically i will use an ID scanner that will input information like Driver ID into something like MS Access. But my business will have a 1 per day promotion for every members, so to avoid that 1 per day promotion overuse i need some sort of alert for database software to tell me that member already used that promotion for today.

Sorry i don't really know how to be more clear, but is it possible to setup MS Access for some sort of Alert? Or is there any alternative method beside writing a custom software (which i can't do :) ?

Thanks for the help in advance.

[WingedPanther]

It sounds like you need a table with a primary key of member_id and scan_date.

[tlatix]

you have any programs in mind? or how to do it in access? thanks for reply.

[WingedPanther]

Based on the limited info you gave, I indicated what you'll need in Access. You'll still need (to write) another program that will use the database, however.

[LuthfiHakim]

You can implement WP's suggestion in MS Access, don't need to develop new program. I assume you are using Access including its form and report features. Note that there is another option to implement member_id + scandate as unique index instead of primary key.

[markhenry115]

which important features do you use in that once ? which program did you develop yet or in progress !