Search results

Works great - I like it!!! (in 64-bit). I imported your module and then I added: Sub FlashIcon() FlashWindow (Application.hWndAccessApp) End Sub One thing odd is that .uCount seems to be a bit off. You had it set to 10 and it seemed to flash 8 times for me. I set it to 12 and it flashed 10...

@sonic8 - Appreciate it. Unfortunately, there were several non-working attempts and I deleted them after I got the FlashWindow non-EX working. Documentation showing the duration is here: http://allapi.mentalis.org/apilist/354B35E13B1AEE7522455E5478278369.html The main thing I attempted was the...

Appreciate it - it works the way I posted it, but probably not always reliably. For completeness, in case the other thread dies, for 32-bit it is: Declare Function FlashWindow Lib "user32" (ByVal hWnd As Long, ByVal bInvert As Long) As Long I think I know why ... It is supposed to flash the...

Concur, depending on your purpose. In my case, I'm using it for an idle timeout if someone leaves the database up and walks away and/or walks away with the computer running. Without the flashing the database gained focus AFTER the pop-up to cancel the form closing appeared. Another recommended...

Very old thread, but I wanted to do the same thing and found a working solution here: https://www.tek-tips.com/threads/can-i-make-the-application-titlebar-flash.1064502/ I also saw references to FlashWindowEx which allowed you to set the duration of the flashing, but couldn't get that to work...

Okay - It's not atomic. That said, it works well for us. I'm not sure exactly how to do it differently. Our team is used to putting the version number after the document number. Obviously, I could have two fields - document number and version number and separate labels and text boxes for each...

Essentially atomic ... We let the users add a version number at the end of the field while the document is in draft form. (Yes, we could/maybe should add a separate field for VersionNum, but we didn't.)

@Pat Harman - Valid points and appreciated. At some point I will probably add in full validation to the forms BeforeUpdate Event. (Presently, that event has a "Confirm that you want to save?" prompt. Doc Number is a string and is essentially atomic. The problem was in the quote positions as...

@cheekybuddha - THANK YOU!!!!

I'm getting there, but I'm running into problems. My usual method of checking for duplicates is to use Nz(Elookup(...), 0) <> 0 rather than Dcount - b/c I don't care HOW many duplicates there are, I just care if there is at least one. DocNumber is a string variable with the value of Me.Field1...

@The_Doc_Man - New issue with the Idle Timers. The timers load with the form. I have a button that sets "Dev Mode" and shuts down all idle timers for all open forms and sets a global variable "TimersAreOff" to true. But if I close and re-open a form, the timer is reset and I get errors if the...

@The_Doc_Man - Thanks I think I figured it out. For issue two, I didn't realize Dcount can have multiple criteria, so I should be able to just use that: https://www.access-programmers.co.uk/forums/threads/dcount-multiple-criteria.142068/ That simplifies the process and I don't need to create a...

Anyone have any ideas on Reply #49. @isladogs? @The_Doc_Man? I did some more testing and I somewhat see what the issue is, but not why or how to prevent it. I moved the banner width control to Form_Resize and I still see the issue. Then I added msgboxes for Open in Form Open, Resize in Form...

@The_Doc_Man - Yes, that helps with the concept, I still don't understand the mechanics. I think I can figure out the SQL Select query - something like "SELECT 'Field1', 'Field2' FROM Table1 WHERE Table1.Field1 = <Like, not sure how to do that in SQL> Me.Field1. Syntax is probably not quite...

I obfuscating a bit, but here are my requirements: If Field1 contains an "X" as part of the field.value, I don't want it to be duplicated. (The field may have a v (version numbers) and some trailing numbers and I want to ignore those.) If the field value exists in the table, I want to display...

Have a new issue and I'm adding an example database. In the example database, when I open a form, I have to click TWICE on the next button before the database goes to the next record. After that, it seems to work properly. We made two changes to the Form Load procedure: We were having an...

@The_Doc_Man - Thank you - I'll take some time to digest this and see where it takes me!

Okay - To clarify some things: IT replied back and confirmed the server that the BE is on is SMB. It appears to be web-enabled, but none of our users access it from a web interface. I spoke with someone else in our department and I think I misunderstood and the FE for Citrix users is not on an...

Using Rob Day's code:

I needed this for another forum that I can't post images to. See https://community.adobe.com/t5/indesign-discussions/remove-border-from-selected-item-in-scriptui-dialog/td-p/14715321