MsgBox window when you receive a new record in an IM type of DB Iram 12/17/2008 4:07:10 PM Hello. I have created an Access database that will be shared by a few people that will work almost as an Instant Messanger. The querey on the "Main" form pulls all records created by the person logged in to the computer (using a module that pulls the LAN login ID) and any record assigned to the person logged in. The "Main" screen also refreshes automatically every 60 seconds. I would like to add a feature and need your help. I need a pop up window to appear indicating "A new task has been sent to you" and a beep sound occur when a person recieves a new record from someone else. This feature is needed since most folks have the access database minimized most of the time. I was thinking of creating a "MsgBox" macro that would run on "After Update" of the "Main" form however since the person logged in will create records to the MsgBox will appear everytime. I would rather have it created in VB that does something like.... After Update on form "Main", If new record's "Assigned To" equals me fOsUserName() (fyi, I am currently using the fOsUserName() module which pulls the LAN Login ID and puts it into a different field called "Created By") Then Run a MsgBox that says "A new task has been sent to you" with an "OK" button and with a beep sound. Is this possible? Your help is greatly appreciated. Iram/mcp

Re: MsgBox window when you receive a new record in an IM type of DB "Stuart McCall" <smccall[ at ]myunrealbox.com> 12/17/2008 5:57:50 PM "Iram" <Iram[ at ]discussions.microsoft.com> wrote in message news:FD768D51-F19B-4D1C-BB37-F00D3E65979B[ at ]microsoft.com... [Quoted Text] > Hello. > I have created an Access database that will be shared by a few people that > will work almost as an Instant Messanger. The querey on the "Main" form > pulls > all records created by the person logged in to the computer (using a > module > that pulls the LAN login ID) and any record assigned to the person logged > in. > The "Main" screen also refreshes automatically every 60 seconds. > > I would like to add a feature and need your help. I need a pop up window > to > appear indicating "A new task has been sent to you" and a beep sound occur > when a person recieves a new record from someone else. This feature is > needed > since most folks have the access database minimized most of the time. > > I was thinking of creating a "MsgBox" macro that would run on "After > Update" > of the "Main" form however since the person logged in will create records > to > the MsgBox will appear everytime. > > I would rather have it created in VB that does something like.... > > After Update on form "Main", If new record's "Assigned To" equals me > fOsUserName() > > (fyi, I am currently using the fOsUserName() module which pulls the LAN > Login > ID and puts it into a different field called "Created By") > > Then Run a MsgBox that says "A new task has been sent to you" with an "OK" > button and with a beep sound. > > > Is this possible? > > Your help is greatly appreciated. > > Iram/mcp The way I normally handle this is to use the API. You can try it by grabbing the code here: http://www.smccall.demon.co.uk/MiscApi.htm#Netsend The only caveat is that you need to know the user's machine name.