How complicated is it to set up an Access form for customer complaints with security and email alarms? Entries should be visible to selected individuals with email going out when certain conditions are not met. Currently we are using Vantive 8.0.2 for management of these complaints and the alarm daemon hangs up. I've designed some complex databases and set up forms on our Intranet for data submission but have not worked with anything that requires security and alarms. Is this a major project????
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations bkrike on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
using Access for Customer Relations
- Thread starter Roz
- Start date
Well it's quite straight forward but if your new to Access you may well have difficulty designing it.
Unlike other Office packages it it difficult to learn Access on the fly. Mistakes made in the earlier stages will bite you back later when it's more complex.
I would advise training for at least 1 person (I would, I'm a Trainer) just be warned that whilst setting up the database is fairly straight forward the e mail alerts and security require more than basic knowledge.
It may be worth paying someone to get the data structure designed as if this is done correctly then everything else is easier.
Hope that helps and I have not scared you off
Neil Berryman
IT Trainer
neil_berryman@btopenworld.com
Unlike other Office packages it it difficult to learn Access on the fly. Mistakes made in the earlier stages will bite you back later when it's more complex.
I would advise training for at least 1 person (I would, I'm a Trainer) just be warned that whilst setting up the database is fairly straight forward the e mail alerts and security require more than basic knowledge.
It may be worth paying someone to get the data structure designed as if this is done correctly then everything else is easier.
Hope that helps and I have not scared you off
Neil Berryman
IT Trainer
neil_berryman@btopenworld.com
I did something close to this for a customer of mine...
Basically the complaints were sent by email in a certain format,
Access reads these emails, gets the relevant data, assesses all parts
and sends back the result:
if each element in the complaint matches, then Access sends an email
to the management, notifying them about a 'valid' complaint
if not, the 'plaintiff' is notified about the inconsistencies.
The bad part is that the system has to use Outlook as email program.
That's because Outlook exposes itself as an ActiveX object and everything
is well documented.
This is the idea. The 'real thing' depends on the structure of your database
and on the VBA skills of the IT guys there...
![[pipe]](/data/assets/smilies/pipe.gif "[pipe] [pipe]")
Daniel Vlas
Systems Consultant
danvlas@yahoo.com
Basically the complaints were sent by email in a certain format,
Access reads these emails, gets the relevant data, assesses all parts
and sends back the result:
if each element in the complaint matches, then Access sends an email
to the management, notifying them about a 'valid' complaint
if not, the 'plaintiff' is notified about the inconsistencies.
The bad part is that the system has to use Outlook as email program.
That's because Outlook exposes itself as an ActiveX object and everything
is well documented.
This is the idea. The 'real thing' depends on the structure of your database
and on the VBA skills of the IT guys there...
Daniel Vlas
Systems Consultant
danvlas@yahoo.com
- Thread starter
- #4
- Status
Similar threads
