Pop Up Alert on Data Change

[fenhow]

Hi,

Looking for a solution. I have a txtBox that is updated via ASP. The ASP and LAN (Access GUI) use the same BE.

On the ASP users can add text to one field. txtUpdate. When this is done of course it writes back to the BE.

When the LAN user opens the DB with the access GUI is there a way that I can have a popup for every record txtUpdate that was updated via ASP?

I am looking for some action like the outlook reminders...

For each one the user can click on the pop up for that record and go directly to it..

I have searched the forum but it seems all popups are for on timer events..

Thanks.

Fen How

 

[GolferGuy]

Are you looking for a pop-up to happen whenever the field is changed, or do you want a pop-up for each changed field when the database is opened on the LAN? And if there have been 15 records changed, do you want 15 pop-ups, or one pop-up with 15 lines on it?

 

[fenhow]

Thanks, I want a pop up to happen for the changed field when teh database is opened on the LAN. Yes I want 15 pop ups. One for each record. Best case scenairo, on the pop up the user can double click and they are taken to that order..

Thanks again.

Fen

 

[GolferGuy]

You need to be sure you have all your bases covered here. For example, are you going to erase the data from this txtUpdate field after you have processed it with the user clicking on the pop-up? Or will you set another field in the table that is a Yes/No field named "UpdateProcessed"?
Which ever way to chose to go, write a query that will present to your routine a list of the records that a web user has updated. Then, you read through this query and for each record in the query you would open another popup form. This is not as easy as one would hope, but here is some help with the matter: http://allenbrowne.com/ser-35.html. I would suggest you put all of them on one form because it would be a whole lot easier. And I think more manageable for the user rather than having a whole lot of little forms on the screen.