open form when data is added

wizkid

New member
Local time
Today, 09:04
Joined
Sep 11, 2005
Messages
6
I have a log and i need to be able to have a pop up when new job has been added to database
 
WizKid,

You can use the form's BeforeInsert event:

DoCmd.OpenForm "YourPopUpForm"

Wayne
 
Are all your users using forms or do some of them enter the data directly to tabels?
 
there all using forms but if someone enters new data on another machine is there away to automaticaly display that a new entre has been made.
 
Not without a lot of overhead. You could add a new table to the database with two columns - TableName and RecordCount. You would then need a new form which was left open all the time. This form would have a timer event. Every n clicks it would run a count query for each table you wanted to be notified about. It would then check the current count with the stored count. If they are different, it would pop up a notification form and save the newest count.

If it is possible to delete records from this table as well as add them, you need to track the Max() autonumber value and compare and store that rather than the record count.
 

Users who are viewing this thread

Back
Top Bottom