Thanks John - Will give it a shot!
-----Original Message-----
From: [email protected] [mailto:[EMAIL PROTECTED] On Behalf
Of John Viescas
Sent: Thursday, February 02, 2006 8:51 AM
To: [email protected]
Subject: RE: [ms_access] Pop-Up Windows for notification purposes
Mike-
Perhaps use the DCount function to do the test in the Timer event:
If 0 < DCount("*", "tblWorkOrders", "Status=0") Then
' pop open the form
DoCmd.OpenForm "fpopNewWorkOrders"
End If
The form should be based on a query that filters for Status = 0.
John Viescas, author
"Building Microsoft Access Applications"
"Microsoft Office Access 2003 Inside Out"
"Running Microsoft Access 2000"
"SQL Queries for Mere Mortals"
http://www.viescas.com/
-----Original Message-----
From: [email protected] [mailto:[EMAIL PROTECTED] On Behalf
Of Mike Bisson
Sent: Wednesday, February 01, 2006 8:13 PM
To: [email protected]
Subject: RE: [ms_access] Pop-Up Windows for notification purposes
Hi John,
The query will look for "Status=0" in my "WorkOrders" table.
-----Original Message-----
From: [email protected] [mailto:[EMAIL PROTECTED] On Behalf
Of John Viescas
Sent: Wednesday, February 01, 2006 7:06 PM
To: [email protected]
Subject: RE: [ms_access] Pop-Up Windows for notification purposes
Mike-
How do you plan to determine a Work Order is new?
John Viescas, author
"Building Microsoft Access Applications"
"Microsoft Office Access 2003 Inside Out"
"Running Microsoft Access 2000"
"SQL Queries for Mere Mortals"
http://www.viescas.com/
-----Original Message-----
From: [email protected] [mailto:[EMAIL PROTECTED] On Behalf
Of Mike Bisson
Sent: Wednesday, February 01, 2006 5:37 PM
To: [email protected]
Subject: [ms_access] Pop-Up Windows for notification purposes
Hi All,
I am currently in the throws of setting up a "Work Order" database for my
company. What I need to accomplish is have a query run every so often that
looks for "New" work orders (this I can handle, using the OnTimer event),
the next step would then be to have a form "pop up" indicating that there
are new work orders entered since the last time the query was run (this is
where I'm having difficulty). I only want the form to pop up if there are
new work orders when the query is run. If there are no new workorders, then
I don't want the form to pop up. Can someone get me started on how to go
about accomplishing this task?
As usual, thanks for any help/advice in advance :)
==================================
Mike Bisson
Manager of IT & Logistics
Carthuplas, Inc.
V: 207-985-4972 x658 F: 207-985-2105
[EMAIL PROTECTED] http://www.carthuplas.com
Yahoo! Groups Links
Yahoo! Groups Links
Yahoo! Groups Links
Yahoo! Groups Links
Yahoo! Groups Links
<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/ms_access/
<*> To unsubscribe from this group, send an email to:
[EMAIL PROTECTED]
<*> Your use of Yahoo! Groups is subject to:
http://docs.yahoo.com/info/terms/
