??popup message when a new record shows up in a subform??

[dennisell]

Is there a way to have a message popup to let a user know when something needs their attention. I have a main form that is always open with a couple of subforms in that form, I am trying to figure out how to go about having a form popup when a new record appears in the subform. The subforms are controlled by queries that are returning information that pertain to that user.

Any help would be greatly appreciated.

Dennis

 

[JeremyNYC]

Dennis,

The answer is yes, but you'll have to give some more information about how these records are being added before we can etell you how to go about it. If the record gets added by something this user is doing than it will be easy and won't have much impact. If the record is being added by a different user then the solution will be a little uglier, as it will require you to check for new records every so often, and that could cause some interruption to what the user is trying to do.

Jeremy =============
Jeremy Wallace
Designing, Developing, and Deploying Access Databases Since 1995

http://www.AlphaBetCityDataworks.com

Take a look at the Developer's section of the site for some helpful fundamentals.


Remember to reward helpful tips with the stars they deserve.

 

[dennisell]

Well, of course it would have to be the more complicated one. Other users are adding the records. Basically, the subform is a list of things that need to be priced out as soon as possible, and controlled by a query to sort out only the records for that user. The Main form called "Menu" which holds the subform is always open but gets covered up by other forms that he is using. If I am able to have a popup form notify him that there is a "hot!" item to be priced then I won't have to rely on him to return to the "Menu" every 10-15 minutes and refresh the form data to see if there is anything in his box.

Dennis

 

[JeremyNYC]

Dennis,

OK, it's a little uglier, but it shouldn't really be a problem.

Look into help for "timer interval" and "ontimer". Basically, you'll want to set the timer to fire every 10-15 minutes (if that's often enough), and when it does, it will call code that refreshes the form data and lets the user know if the number of records has changed.

The way I would test for the change in number of records is to store the number of records in an invisible text box on the form every time the subform is populated. Then you repop the subform, check the number of records, test that against the number of records there are now, call your alert code if the numbers don't match, and update the text box.

Hope this helps.

Jeremy =============
Jeremy Wallace
Designing, Developing, and Deploying Access Databases Since 1995

http://www.AlphaBetCityDataworks.com

Take a look at the Developer's section of the site for some helpful fundamentals.


Remember to reward helpful tips with the stars they deserve.

 

[dennisell]

Thanks, I will give it a try.