Need ideas: Alert user when record hasnt been updated in over an hour

paindivine

Registered User.
Local time
Yesterday, 17:58
Joined
Dec 13, 2006
Messages
23
I have a form in continuous forms mode...
Each entry is something the user is supposed to check on once and hour and update.
I have a "Last updated" field.
Now() goes into that field every time the record is updated.
I have a querry that will show the users records that are over an hour old.

How can I get Access to pop-up a window or something to alert the user they need to look at something? It would be really nice if Aspect would start blinking in the task bar or something.

Thanks!
 
PD,

Use the TimerEvent of your form(s) and do the following:

Code:
If DCount"[SomeField]", "YourQuery") > 0 Then
   DoCmd.OpenForm "YourPopUpForm"
End If

Basically, if your query returns anything, then open up
the form for the user.

The Popup form could be modal, displaying anything from the
query, or even alter/trigger something on your main form.

hth,
Wayne
 
PD,

Use the TimerEvent of your form(s) and do the following:

Code:
If DCount"[SomeField]", "YourQuery") > 0 Then
   DoCmd.OpenForm "YourPopUpForm"
End If

Basically, if your query returns anything, then open up
the form for the user.

The Popup form could be modal, displaying anything from the
query, or even alter/trigger something on your main form.

hth,
Wayne

Ok, I put this code in the "Ontimer" event:

Code:
    If DCount(Ticket, Qry_Alert) > 0 Then
        DoCmd.OpenForm Frm_Alert
    End If


"Ticket" is the field I was going to count (Any field in the query will work right?)
Qry_Alert is the Query that finds old records
Frm_Alert is the form I want to open

This errors out. I think I have the "DCount" portion mixed up. Could someone straiten me out on the syntax?
 
If DCount("*", "Qry_Alert") > 0 Then
 
That worked... The only problem is I put it on the "On open" and "On timer" events. The timer works great... but the "On Open" opens the second form in the background. Any way to open it on top?
 
Presumably because the first form isn't done opening yet. You can try setting the popup and or modal settings on the second form.
 

Users who are viewing this thread

Back
Top Bottom