Results 1 to 4 of 4
  1. #1
    TOPSie is offline Competent Performer
    Windows 10 Access 2016
    Join Date
    Mar 2021
    Posts
    153

    Hourglass - revolving cirlce - whatever

    I have a very complex form displaying "today's" data. It takes a second or too to load due to the complexity. On the screen are two buttons (commands). Press the left hand one and the date is reset to yesterday and the screen refreshes with yesterday's data. Press the right hand one and you get tomorrow. As soon as you press either of these two buttons the cursor changes from the little arrow to a revolving circle. But nowhere in the code or the button properties can I see anything which indicates a change in the pointer.



    If (for experiment) I create another button and add code to click one of these buttons (cmdTomorrow_Click) then the pointer does not change????

    So what causes a comand to show the revolving circle when pressed??

  2. #2
    Join Date
    Jan 2017
    Location
    Swansea,South Wales,UK
    Posts
    6,552
    Isn't that the standard cursor for 'working on it'?

    I can get that momentarily when opening a form from the navigation panel.
    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

  3. #3
    jojowhite's Avatar
    jojowhite is online now Competent Performer
    Windows 11 Access 2021
    Join Date
    Jan 2025
    Posts
    433
    the Busy cursor appears when it Requery your Form (like you said it takes a second or two to output the result).
    maybe after the code of your Left and right arrow, you explicitly change the cursor to Normal:
    Code:
    DoCmd.Hourglass False

  4. #4
    June7's Avatar
    June7 is offline VIP
    Windows 11 Access 2021
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    53,770
    It does seem odd you would see circle cursor when clicking button directly but not when calling button click from another procedure.
    I cannot replicate this. Could provide your db for analysis. Follow instructions at bottom of my post.
    How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.

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

Similar Threads

  1. DoCmd.Hourglass not working
    By GraeagleBill in forum Programming
    Replies: 10
    Last Post: 02-24-2022, 12:28 PM
  2. Database Relationships or whatever!
    By BaldFox in forum Reports
    Replies: 8
    Last Post: 06-07-2011, 09:04 PM
  3. Exporting Report to a word file or PDF or whatever
    By AccessDatabaseGuy in forum Access
    Replies: 1
    Last Post: 05-03-2011, 02:03 PM
  4. Revolving list
    By beau_daniel in forum Access
    Replies: 1
    Last Post: 02-26-2010, 04:18 PM
  5. No Report, Hourglass Disappears
    By EdSwartz in forum Reports
    Replies: 0
    Last Post: 02-19-2010, 11:38 AM

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