D
Derek Wittman
Good morning
I've elected to try this code instead of Dev's. One of the 10 Access Commandments being to make sure one understands how the code works before inserting it. <g
Anyway, I am still not able to create conditions to cause the PlaySound to fire. OnTimer requeries every 10 seconds (and I am not sure if I want to change this to 30 or 60). The CurrentUsers form that contains the information I want to see (continuous form) will add a record or remove a record as a user connects or disconnects, respectively
The query, called "Active" is
SELECT Last(UserLog.Time) AS LastOfTime, Now() AS Now, UserLog.Use
FROM UserLo
GROUP BY Now(), UserLog.Use
HAVING (((Last(UserLog.[In/Out]))="In"))
My form has fields
Use
=Minute(Now()-[LastOfTime])+Hour(Now()-[LastOfTime])*6
I need the PlaySound to fire when a record is added or removed from the form, including the change from Null to 1 or 1 to Null
Can someone please help
Derek
I've elected to try this code instead of Dev's. One of the 10 Access Commandments being to make sure one understands how the code works before inserting it. <g
Anyway, I am still not able to create conditions to cause the PlaySound to fire. OnTimer requeries every 10 seconds (and I am not sure if I want to change this to 30 or 60). The CurrentUsers form that contains the information I want to see (continuous form) will add a record or remove a record as a user connects or disconnects, respectively
The query, called "Active" is
SELECT Last(UserLog.Time) AS LastOfTime, Now() AS Now, UserLog.Use
FROM UserLo
GROUP BY Now(), UserLog.Use
HAVING (((Last(UserLog.[In/Out]))="In"))
My form has fields
Use
=Minute(Now()-[LastOfTime])+Hour(Now()-[LastOfTime])*6
I need the PlaySound to fire when a record is added or removed from the form, including the change from Null to 1 or 1 to Null
Can someone please help
Derek