D
dgodfrey
I hope this is not asking too much, and I may need a step-by-step here. I
have several requirements I need a little help on.
Let me start with the basics. I have a database that is setup with 4 tables
currently. My main form is bound to the "Suspects" table. On my main form, I
have several tabs. The "BOLO" tab has a subform on it called sfrmBolo. Each
"Suspect" can have more than one BOLO. The subform is bound to the "Bolo"
table.
What I want is this (and I am new and not a programmer):
1. When the user starts-up/logs on to the database (I currently have a
startup screen and a switchboard), I would like for the user to be alerted
that a new "BOLO" has been added. I believe a pop-up form or msgbox would
work. The user is alerted a new "Bolo" record, or records, has been
added...they need to know this immediately...and they are given a list of all
those new records. The user can then click a button and view each bolo
(including suspect information from main form), one at a time in a report
view (printable, no editing allowed)...without having to reload the list.
2. When a new Bolo is issued (added), an e-mail alert is sent to the whole
department with the report attached to the e-mail.
3. The report must contain all information from the main form and tabs in a
preferably one page printable format, including the person's photo.
4. When a Bolo expires or is cancelled, I need an e-mail sent to the entire
department to alert of this change.
I am sure I will need to add to these requirements, but this should get me
started.
Thanks,
Derek
have several requirements I need a little help on.
Let me start with the basics. I have a database that is setup with 4 tables
currently. My main form is bound to the "Suspects" table. On my main form, I
have several tabs. The "BOLO" tab has a subform on it called sfrmBolo. Each
"Suspect" can have more than one BOLO. The subform is bound to the "Bolo"
table.
What I want is this (and I am new and not a programmer):
1. When the user starts-up/logs on to the database (I currently have a
startup screen and a switchboard), I would like for the user to be alerted
that a new "BOLO" has been added. I believe a pop-up form or msgbox would
work. The user is alerted a new "Bolo" record, or records, has been
added...they need to know this immediately...and they are given a list of all
those new records. The user can then click a button and view each bolo
(including suspect information from main form), one at a time in a report
view (printable, no editing allowed)...without having to reload the list.
2. When a new Bolo is issued (added), an e-mail alert is sent to the whole
department with the report attached to the e-mail.
3. The report must contain all information from the main form and tabs in a
preferably one page printable format, including the person's photo.
4. When a Bolo expires or is cancelled, I need an e-mail sent to the entire
department to alert of this change.
I am sure I will need to add to these requirements, but this should get me
started.
Thanks,
Derek