Results 1 to 10 of 10

Thread: Alarm? (2002)

  1. #1
    2 Star Lounger
    Join Date
    Nov 2002
    Location
    Monroeville, Pennsylvania, USA
    Posts
    152
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Alarm? (2002)

    I have a networked data base that is used by 15-20 users. I have been asked to provide a popup alarm on certain users screens, when a particular entry has been made in a field on some other users screen. Is this possible, and if so, how. Thanks for any help.
    <img src=/S/help.gif border=0 alt=help width=23 height=15>

  2. #2
    Silver Lounger
    Join Date
    Jun 2002
    Location
    Cheadle, Staffordshire
    Posts
    2,177
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Alarm? (2002)

    Could you be a little more descriptive ?

  3. #3
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Alarm? (2002)

    You would have to use a table, for forms are held in memory on the user's PC. The users who need to be notified would need to have a form open all the tim; this form does not need to have the focus, it might even be hidden. Write code in the On Timer event of this form to check if a certain field in a certain table has a certain value, and pop up a message box if so. Set the Timer Interval property of the form to the number of milliseconds between checks, for example 60000 if you want to check once a minute. You will have to decide for yourself what is to happen once the user has been notified - you can turn the timer off by setting the Timer Interval to 0, or you can toggle a boolean variable...

  4. #4
    2 Star Lounger
    Join Date
    Nov 2002
    Location
    Monroeville, Pennsylvania, USA
    Posts
    152
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Alarm? (2002)

    If the rental department is shipping a unit and they enter the info into the rental data base, how does the service department know this unit needs to ship. We currently are sending E-Mails. If we had a Pop-Up Alarm, we could eliminate the need for E-Mails.

  5. #5
    2 Star Lounger
    Join Date
    Nov 2002
    Location
    Monroeville, Pennsylvania, USA
    Posts
    152
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Alarm? (2002)

    Can you give me an example of the code I would have to use? Thanks

  6. #6
    Silver Lounger
    Join Date
    Jun 2002
    Location
    Cheadle, Staffordshire
    Posts
    2,177
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Alarm? (2002)

    <P ID="edit" class=small>(Edited by D Willett on 16-Feb-04 17:11. Reference to MSPAPI32.ocx)</P>If you're happy using E.Mail, you could automate this process on the after update event of the text control.

    :Select More Tools and select the MAPI session and message tools.
    :Place one of each on your form.
    :Set MapiSession property "DownLoadMail" to "No"
    :Make sure each is named MAPISession1 & MAPIMessages1
    : & Me!RefID is a reference your your case reference or Whatever reference system you use, remove if not required.
    : Check you have MSMAPI32.ocx in your system folder (System32 for XP) and it is registered

    Lets say, you have txtCase

    In the after update event you could have something like:

    MAPISession1.SignOn
    With MAPIMessages1
    .SessionID = MAPISession1.SessionID
    .Compose
    .MsgSubject = "File Updated: " & Me!RefID
    .RecipDisplayName = "Joe.Bloggs@SomeEmailAddress.com.uk"
    .MsgNoteText = Space(2) & vbCrLf & "File Has Been Updated "
    .Send True
    End With
    MAPISession1.SignOff

    Now when the text is updated, your E.Mail application pops up with your details, the user only has to press send.
    If you need this to work only if a certain value is entered into your form, you can use a "Select Case" statement to
    differentiate.

    Hope this helps.
    Dave

  7. #7
    2 Star Lounger
    Join Date
    Nov 2002
    Location
    Monroeville, Pennsylvania, USA
    Posts
    152
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Alarm? (2002)

    I think that upper mgmt wants to quit using email altogether, and have the notification pop up thru Access, which will always be open on the recieving individuals computer.

  8. #8
    Plutonium Lounger
    Join Date
    Dec 2000
    Location
    Sacramento, California, USA
    Posts
    16,775
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Alarm? (2002)

    Upper management tends to believe in database magic. Since databases don't work by magic, upper management sometimes gets disappointed. <img src=/S/shrug.gif border=0 alt=shrug width=39 height=15>
    Charlotte

  9. #9
    Silver Lounger
    Join Date
    Jun 2002
    Location
    Cheadle, Staffordshire
    Posts
    2,177
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Alarm? (2002)

    Here's a very crude method of messaging attached.
    I presume your tables reside on a server somewhere.

    :Copy the tables to the server database and link the tables to teh local PC's.
    :Copy the query and form to each PC.
    :Each PC needs to have a User, you could use there initials or first name or department etc (Check the criteria in the query under MsgTo),
    with each user, you need to change this criteria to there identification. So if Alan sits at his desk all the time and he uses the same machine all the time,
    he will only recieve messages with his ID from the query.

    Open the form and write a message, ensuring you fill in the MsgTo box.
    When he opens the form from his machine, only he will see the message which is intended for him.
    If your users move around alot, then this method will not work.

    Now to get the pop-up msg depends what forms you are using at the moment.
    We have a counter on our main for which basically states " You Have [3] Messages" etc.

    When the reader fills the "MsgRead" checkbox, his msg disapears.

    As I said, it's a crude example, but with a little work, you should manage to make is suit your needs.
    Good Luck.
    Attached Files Attached Files

  10. #10
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Alarm? (2002)

    You have been given some alternative suggestions. If you would still like to get some code, you will need to provide more details.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •