Results 1 to 5 of 5
  1. #1
    redbull's Avatar
    redbull is offline Competent Performer
    Windows XP Access 2003
    Join Date
    Mar 2012
    Location
    Missouri
    Posts
    480

    Random Message box pops up in access... for some people... Oy!

    So, I have a front end with about 100 people on it... and a small number of them are telling me about a weird problem... I cannot find any common ground between these users either.

    So The application has a timer. This timer checks some IE variables.. If the IE variables are the same, it does nothing.. if the variables are different it does something else.



    For these people they are getting a message box every 4.5 seconds... right on queue with the timer
    Click image for larger version. 

Name:	LIFT error.JPG 
Views:	17 
Size:	4.1 KB 
ID:	13790
    I don't know what is causing it.. the timer, has zero message boxes within the code. I can attach the code if you guys think it will be beneficial... But I am hopeful this is an access thing and someone has dealt with it before.

  2. #2
    ItsMe's Avatar
    ItsMe is offline Sometimes Helpful
    Windows XP Access 2003
    Join Date
    Aug 2013
    Posts
    7,862
    Where does your timer function reside? The MsgBox you are getting may be triggered in another module. Maybe you can search your code for the declared variable that becomes 0. Like intIE_Variable or lngIE_Variable. There could be a MsgBox nearby this variable result.

  3. #3
    Missinglinq's Avatar
    Missinglinq is offline VIP
    Windows 7 64bit Access 2007
    Join Date
    May 2012
    Location
    Richmond (Virginia, not North Yorkshire!)
    Posts
    3,018
    First off, does

    ...I have a front end with about 100 people on it...
    mean that each user has a copy of the Front End on their machine, or are they all using a single file on a shared drive?

    And, yes, if you have code that is misbehaving and you want help debugging it, letting us see it would be a good thing. At this point I'm talking about the code in the Timer event, as well as the code of any Function that may be called from the Timer event.

    Linq ;0)>
    The problem with making anything foolproof...is that fools are so darn ingenious!

    All posts/responses based on Access 2003/2007

  4. #4
    Renaud's Avatar
    Renaud is offline Novice
    Windows 8 Access 2010 32bit
    Join Date
    Sep 2013
    Location
    Hong Kong
    Posts
    4
    You do need to post the code involved. It's hard to help with just a description of the problem.
    What do you actually mean by "checking some IE variables" exactly ?

  5. #5
    redbull's Avatar
    redbull is offline Competent Performer
    Windows XP Access 2003
    Join Date
    Mar 2012
    Location
    Missouri
    Posts
    480
    Alright, everyone has a local copy of the front end. I reviewed the code, and there is no msgbox anywhere near the timed event.. So i just compact & repair and put out an update to the users... The problem seems to have resolved itself.

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Access pops up briefly before Display Form
    By buttonsrtoys in forum Access
    Replies: 3
    Last Post: 05-05-2013, 12:07 PM
  2. VBA Code pops up unexpectantly
    By francisdm@state.gov in forum Access
    Replies: 1
    Last Post: 04-06-2012, 08:55 AM
  3. Hello Access People
    By redbull in forum General Chat
    Replies: 2
    Last Post: 03-22-2012, 12:06 PM
  4. Number of people able to Access DB
    By noelrobb in forum Forms
    Replies: 4
    Last Post: 02-07-2011, 08:01 AM
  5. Replies: 0
    Last Post: 12-28-2009, 12:14 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums