Automating databases

  • Thread starter Thread starter Bob Seymour
  • Start date Start date
B

Bob Seymour

Can anyone help?,
I've been tasked with creating a database to hold information on changes to
drawings, designs etc. The database would be required (if at all possible)
to send an automatic email to some (or all) parties on a list when new
information pertaining to their department or section was input to the
database.

I was thinking along the lines of:
Table 1 - for holding the information
Table 2 - for list of persons and departments (to include email addresses)
Query 1 - to link data from Table 1 and Table 2
Form1 - to input information into Table 1
Report 1 - to be used by macro (as snapshot). Will show parties who need to
action new information input to table 1.

My problem is I've not written macros in Access 2003. Is there any way to do
this automation?

Thanks in advance.
Bob S.
 
Bob,

I haven't written a macro in Access for years, I prefer to do everything in
VB, however, if you want to use macro, sect the event you to run the macro
from the properties sheet of the form or the field, , click on the three
dots (..) select the "Macro Builder "Name the macro,it and use the builder
to it for you.

Regards/JK
 
Thanks JK, I'll give it a whirl.

JK said:
Bob,

I haven't written a macro in Access for years, I prefer to do everything
in VB, however, if you want to use macro, sect the event you to run the
macro from the properties sheet of the form or the field, , click on the
three dots (..) select the "Macro Builder "Name the macro,it and use the
builder to it for you.

Regards/JK
Click to expand...
 
Back
Top