I read somewhere about possibly using a transparent button, but that wouldn't work because the user needs to click on the record selector. I have an annoying oddity with the hourglass and not sure why. By including the DoEvents forces Access to break up this code into segments. so it can't be 'that' difficult..." -- Healdem "...teach a man to code and he'll be frustrated for life! " -- georgev Reply With Quote 12-14-07,08:58 #14 Marvels View Profile View Check This Out
Instead, at the end of the waiting period, the hourglass very briefly flashes (for less than a second) on the screen right before the second form opens. Paul Paul Ponzelli, Nov 8, 2005 #7 Marshall Barton Guest Re: Many thanks to Rick and Marsh Paul Ponzelli wrote: >Thanks for the clarification, Marsh. > >Yes, I tried both I can get the hour glass to work with other click events like with a command button, but for some reason the form click event doesn't work for me. I haven't been able to reproduce your situation, so I can't test all this myself.
Click Here to join Tek-Tips and talk with other members! Is this routine perhaps being called form another one? Delivered Daily Subscribe Best of the Week Our editors highlight the TechRepublic articles, galleries, and videos that you absolutely cannot miss to stay current on the latest IT news, innovations, and
Your name or email address: Do you already have an account? however, there is still no hourglass! The only visible effect of trying to open that > intermediate form is that the barest outline of the form perimeter > displays on the screen until the second form opens Docmd.hourglass Example Yes, I tried both DoCmd.Hourglass True Me.Repaint and DoCmd.Hourglass True Me.Repaint DoEvents and neither of those got the hourglass to display until the last split second in the process.
Paul Reply With Quote 12-13-07,22:30 #5 StarTrekker View Profile View Forum Posts Visit Homepage L33t Helpa Munky Join Date Nov 2007 Location Adelaide, South Australia Posts 4,049 We all know that Ms Access Vba Set Cursor Hourglass so it can't be 'that' difficult..." -- Healdem "...teach a man to code and he'll be frustrated for life! " -- georgev Reply With Quote 12-14-07,04:27 #12 Marvels View Profile View Find More Posts by wh00t
lol Owner and Manager of CypherBYTE, Microsoft Access Development Specialists. Docmd Echo My bad for not testing under your exact scenario. Close Reply To This Thread Posting in the Tek-Tips forums is a member-only feature. The Hourglass method carries out the Hourglass action in Visual Basic.
no event is triggered. wh00t View Public Profile Visit wh00t's homepage! Docmd.hourglass Vba I'm curious to see if you get the same thing. Vba Hourglass Excel You see, unlike Visual Basic, Access does not process one line at a time, what it attemps to do is to read all the lines of code into cache and then
Please join our friendly community by clicking the button below - it only takes a few seconds and is totally free. his comment is here Code: DoCmd.Hourglass True ResetCounter DoCmd.SetWarnings False DoCmd.RunSQL "DELETE * FROM tblList" If DLookup("ReportOption", "tblOptions") Then DoCmd.OpenQuery "qryAppendTypeA" Else DoCmd.OpenQuery "qryAppendTypeB" End If DoCmd.SetWarnings True DoCmd.OpenReport "rptReport", acViewPreview DoCmd.OpenForm "frmPrintOptions", acNormal DoCmd.Hourglass Add Stickiness To Your Site By Linking To This Professionally Managed Technical Forum.Just copy and paste the BBCode HTML Markdown MediaWiki reStructuredText code below into your site. Microsoft: Access Modules Click a blank Action cell after the last command in the macro and select Beep from the drop-down list. Vba Hourglass Cursor
Password Register FAQ Community Top Posters Today's Posts Search Community Links Social Groups Pictures & Albums Members List Calendar Search Forums Show Threads Show Posts Tag Search Advanced Search Find Access Echo On the other hand, when stepping through the code, the hourglass works, but the VB Editor is active at that time. Join & Ask a Question Need Help in Real-Time?
Stay logged in Welcome to PC Review! You currently have 0 posts. The answer is yes. When initiating the same code on the OnClick event of an image, the cursor does not change to an hourglass.
Openform Error Message IF no records found...not getting it Peter, Oct 12, 2009, in forum: Microsoft Access Form Coding Replies: 0 Views: 377 Peter Oct 12, 2009 Loading... no hourglass. Nov 13 '05 #4 This discussion thread is closed Start new discussion Replies have been disabled for this discussion. navigate here Select the macro and click the Design button.
It didn't help. I did not find a way to make the hourglass appear, even by changing the focus and other similar tricks, but I haven't tried WinAPI calls — I'm sure it's possible DoCmd.Hourglass True stDocName = "frmEmployeeTimeSheet" stLinkCriteria = "[EmployeeID]=" & "'" & Me![Combo0] & "'" DoCmd.OpenForm stDocName, , , stLinkCriteria DoCmd.Hourglass False Can anyone tell me why the Hourglass doesn't display during