Page 1 of 2 12 LastLast
Results 1 to 15 of 25
  1. #1
    kathiepreston is offline Advanced Beginner
    Windows 10 Access 2016
    Join Date
    Jul 2021
    Posts
    33

    Form seems to keep refreshing.

    Good Morning,


    I hope I can explain this. I have an Access database, several actually, that seem to have a problem with their forms. The database opens just fine and the selected form opens as well.
    The problem is once the form opens it keeps "flashing" like it is being refreshed. When it does this the curser will jump back the field you started in. Even using the FIND pop-up from Microsoft doesn't help. You can enter a couple characters then the screen "flashes" and the curser returns to the field you selected to start from.
    I am don't have a lot of knowledge when it comes to actual programming. I took these databases over when the fellow who created them left.
    If I had to guess, I would have said that a Refresh/Repaint event is going nuts, But the form I'm trying to fix now doesn't have that type of event.
    The form is even doing this "flash" thing in Design mode. Even opening the Ribbon is difficult.

    This started yesterday and I have no idea what to do.

    If anyone can help I would really appreciate it.

    Thanks,
    Kathie

  2. #2
    Minty is online now VIP
    Windows 10 Office 365
    Join Date
    Sep 2017
    Location
    UK - Wiltshire
    Posts
    3,001
    Have a look at the timer event on any of the forms that are open when this happens.
    DLookup Syntax and others http://access.mvps.org/access/general/gen0018.htm
    Please use the star below the post to say thanks if we have helped !
    ↓↓ It's down here ↓↓

  3. #3
    kathiepreston is offline Advanced Beginner
    Windows 10 Access 2016
    Join Date
    Jul 2021
    Posts
    33
    The Timer Interval is 0 (zero). I have never messed with that. Should it be set to something other than Zero?

  4. #4
    Minty is online now VIP
    Windows 10 Office 365
    Join Date
    Sep 2017
    Location
    UK - Wiltshire
    Posts
    3,001
    No - if a form has a timer event it will fire every time that interval passes (it's in milliseconds, so 1000 is a second) 0 means it never fires.
    So that's a good starting point.
    Form timers can cause the sort of random refreshes you described, if you have none that eliminates one possible cause.
    DLookup Syntax and others http://access.mvps.org/access/general/gen0018.htm
    Please use the star below the post to say thanks if we have helped !
    ↓↓ It's down here ↓↓

  5. #5
    kathiepreston is offline Advanced Beginner
    Windows 10 Access 2016
    Join Date
    Jul 2021
    Posts
    33
    So what are some other possibilities?

  6. #6
    Minty is online now VIP
    Windows 10 Office 365
    Join Date
    Sep 2017
    Location
    UK - Wiltshire
    Posts
    3,001
    Make sure there are no forms open, but hidden.

    If you open one of the databases while holding down the shift key, it should bypass the start up events.
    If the problem disappears (e.g. you can now open the ribbon without it going mad), then some code or macro is running somewhere in the background in normal use.

    You will need to examine the DB to see if it has an Autoexec macro, or a form in the start up options.
    (Goto File¬ Options¬ Current Database and look at the "Display Form" drop down.)
    DLookup Syntax and others http://access.mvps.org/access/general/gen0018.htm
    Please use the star below the post to say thanks if we have helped !
    ↓↓ It's down here ↓↓

  7. #7
    Join Date
    Jan 2017
    Location
    Swansea,South Wales,UK
    Posts
    4,859
    Any windows updates yesterday?
    Please use # icon on toolbar when posting code snippets.
    Cross Posting: https://www.excelguru.ca/content.php?184
    Debugging Access: https://www.youtube.com/results?sear...bug+access+vba

  8. #8
    isladogs's Avatar
    isladogs is offline MVP / VIP
    Windows 10 Access 2010 32bit
    Join Date
    Jan 2014
    Location
    Somerset, UK
    Posts
    5,954
    I agree that this is almost certainly due to a timer event.
    It may be that the Timer Interval is set to be other than zero in VBA ... or possibly a saved / embedded macro (?)

    Another symptom of timer event irritation is that the cursor can jump around erratically in the visual basic editor whilst a timer event is running.
    Colin, Access MVP, Website, email
    The more I learn, the more I know I don't know. When I don't know, I keep quiet!
    If I don't know that I don't know, I don't know whether to answer

  9. #9
    kathiepreston is offline Advanced Beginner
    Windows 10 Access 2016
    Join Date
    Jul 2021
    Posts
    33
    There is an Auto Exec that opens the database. I opened the database while holding the shift key. The Ribbon opened fine. I opened the form from the Navigation Pane and it is still jumping around and the Ribbon is being difficult as well.
    There are 2 events on this form, one in Before Update (LastModified1) which adds the date the record is modified as well as the user information. The other one On Open has a Go To Record (Embedded Macro) that opens the form to the last record. I have added screen shots of the macros. Hope they help.
    Embedded Macro LastModified1
    Click image for larger version. 

Name:	Embedded Macro.png 
Views:	27 
Size:	7.6 KB 
ID:	46166Click image for larger version. 

Name:	LastModified1.png 
Views:	25 
Size:	11.8 KB 
ID:	46167

  10. #10
    isladogs's Avatar
    isladogs is offline MVP / VIP
    Windows 10 Access 2010 32bit
    Join Date
    Jan 2014
    Location
    Somerset, UK
    Posts
    5,954
    Your test seems to confirm the issue is in your form (or perhaps a subform if there is one)
    There is nothing obvious in your macro. If there isn't any timer events elsewhere, it may be corruption.
    Try creating a new copy of your form and see if that helps
    Colin, Access MVP, Website, email
    The more I learn, the more I know I don't know. When I don't know, I keep quiet!
    If I don't know that I don't know, I don't know whether to answer

  11. #11
    kathiepreston is offline Advanced Beginner
    Windows 10 Access 2016
    Join Date
    Jul 2021
    Posts
    33
    Making a new form did not help. I think I will try an older version to see if that is ok. Wish me luck!

  12. #12
    kathiepreston is offline Advanced Beginner
    Windows 10 Access 2016
    Join Date
    Jul 2021
    Posts
    33
    Well using an older version of the database kinda worked. It is working just perfect for me, but not for another person who also uses it. Hers' does the "flashy" thing.
    Hmmm. I cannot find any macros or functions that use the time interval function or have a time interval in the programming itself.

    If you have anymore ideas, I would greatly appreciate the help!

  13. #13
    isladogs's Avatar
    isladogs is offline MVP / VIP
    Windows 10 Access 2010 32bit
    Join Date
    Jan 2014
    Location
    Somerset, UK
    Posts
    5,954
    Just a thought. Is it a navigation form? If so, try creating your own standard form with similar functionality.
    Otherwise, are you able to upload a cut down version of your database?
    Colin, Access MVP, Website, email
    The more I learn, the more I know I don't know. When I don't know, I keep quiet!
    If I don't know that I don't know, I don't know whether to answer

  14. #14
    kathiepreston is offline Advanced Beginner
    Windows 10 Access 2016
    Join Date
    Jul 2021
    Posts
    33
    This data base has 2 backends and a front end. I don't think it will work with the linked tables if I upload it.
    I was thinking about recreating the form from scratch and see it that works.
    I had a copy working for a little while but it's not back to the same "flashy" thing.
    I am about to sign off for the day. I will work the new form and let you know.

    thanks for all help!! it is greatly appreciated.

  15. #15
    isladogs's Avatar
    isladogs is offline MVP / VIP
    Windows 10 Access 2010 32bit
    Join Date
    Jan 2014
    Location
    Somerset, UK
    Posts
    5,954
    My suggestion is to just provide the items need to make the form usable in the uploaded copy. Convert any linked tables needed to local tables.
    Change any confidential data.
    Check that the copy also shows the same issue
    Colin, Access MVP, Website, email
    The more I learn, the more I know I don't know. When I don't know, I keep quiet!
    If I don't know that I don't know, I don't know whether to answer

Page 1 of 2 12 LastLast
Please reply to this thread with any new information or opinions.

Similar Threads

  1. continuos form not more refreshing
    By diegomarino in forum Access
    Replies: 7
    Last Post: 05-05-2020, 09:52 AM
  2. Refreshing a form using the primary key.
    By doneill in forum Forms
    Replies: 2
    Last Post: 04-08-2020, 10:47 PM
  3. Refreshing Form and Subform
    By faythe1215 in forum Forms
    Replies: 6
    Last Post: 04-21-2016, 04:51 PM
  4. Refreshing a form upon opening
    By an1bone in forum Forms
    Replies: 5
    Last Post: 08-07-2015, 06:39 AM
  5. Refreshing the form vs. requerying
    By Access_Novice in forum Forms
    Replies: 9
    Last Post: 01-01-2014, 07:24 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