Message box

[bp17]

I have SQL table where people enter items needed for orders, upon entry SQL
grabs their user ID from the network and adds a time and date. All this is
stored in the "orders" table. A material handeler uses a form view of this
table that shows them where find the items. Once they fill the order they
enter the quantity filled in the QTY field, SQL then runs a stored procedure
to move this information to a "filled" table ( also in SQL) where it records
the persone who filled it and what time and date the filled it on.
What I would like to happen is have a message box pop up if their is
anything on the "orders" table that has been there longer then 30 minutes.

 

[PieterLinden via AccessMonster.com]

I have SQL table where people enter items needed for orders, upon entry SQL
grabs their user ID from the network and adds a time and date. All this is
stored in the "orders" table. A material handeler uses a form view of this
table that shows them where find the items. Once they fill the order they
enter the quantity filled in the QTY field, SQL then runs a stored procedure
to move this information to a "filled" table ( also in SQL) where it records
the persone who filled it and what time and date the filled it on.
What I would like to happen is have a message box pop up if their is
anything on the "orders" table that has been there longer then 30 minutes.

You would have to use the OnTimer event of the form to do something like...
If DCount(...DateDiff("n",EntryTime,Now())>30 Then
MsgBox
End If