We help IT Professionals succeed at work.
Get Started

Access 2003 - Notification of new record created

bobrossi56
bobrossi56 asked
on
815 Views
Last Modified: 2012-05-09
Looking for ideas experts. Working on a DB that is used by a company that owns 300 school buses. The main office is responsible for the repair and maint of all these busses. The busses are parked in 8 different locations across the state.When a bus breaks,  each manager from the 8 offices creates a record using the Defect Report form I developed, stating the bus#, mileage, and problem.

The fleet manager sitting in the main office is at any one time juggling repairs of 15-20 busses. He says this DB structures all this better for him, but he asked me if there was a way for Access to notify him every time a newDdefect record is created. Currently he has to keep running a report of NEW defects, but he wanted an easier, on-screen visual way to see when a new record is created.

Is this even possible?
thx experts...
BobR
Comment
Watch Question
Retired IT Professional
CERTIFIED EXPERT
Commented:
This problem has been solved!
Unlock 2 Answers and 11 Comments.
See Answers
Why Experts Exchange?

Experts Exchange always has the answer, or at the least points me in the correct direction! It is like having another employee that is extremely experienced.

Jim Murphy
Programmer at Smart IT Solutions

When asked, what has been your best career decision?

Deciding to stick with EE.

Mohamed Asif
Technical Department Head

Being involved with EE helped me to grow personally and professionally.

Carl Webster
CTP, Sr Infrastructure Consultant
Ask ANY Question

Connect with Certified Experts to gain insight and support on specific technology challenges including:

  • Troubleshooting
  • Research
  • Professional Opinions
Did You Know?

We've partnered with two important charities to provide clean water and computer science education to those who need it most. READ MORE