Search found 22 matches
- 27 Sep 2022, 22:08
- Forum: Scripts and Functions (v1)
- Topic: SQL Pretty Formatter
- Replies: 7
- Views: 2394
Re: SQL Pretty Formatter
I updated the code today in the original post. It now has better handling of putting spaces around commas. It will skip commas that are inside quotes, parenthesis, brackets, and double braces. There is also a new function called RegExReplaceExcludeNoWordBoundary() to allow Regex calls to exclude som...
- 11 Aug 2022, 00:37
- Forum: Scripts and Functions (v1)
- Topic: SQL Pretty Formatter
- Replies: 7
- Views: 2394
Re: SQL Pretty Formatter
Ben wrote: ↑ I used to like the look of the comma at the end but a friend showed me that having the comma at the beginning makes it easier to comment out a column (as long as it's not the first column). I thought I heard something like this too, but it seems to me that any column in the middle of a...
- 10 Aug 2022, 20:57
- Forum: Scripts and Functions (v1)
- Topic: SQL Pretty Formatter
- Replies: 7
- Views: 2394
Re: SQL Pretty Formatter
Very nice. I will make regular use of this. It happens to match my preferred formatting, other than I typically put the comma at the end of the line (although that has been a subject of debate), but it sounds like that is configurable. Yes, on lines 226-227 you can adjust whether the comma is a pre...
- 09 Aug 2022, 00:35
- Forum: Scripts and Functions (v1)
- Topic: SQL Pretty Formatter
- Replies: 7
- Views: 2394
SQL Pretty Formatter
I have created a hotkey script that will format the selected SQL statement by adding carriage returns and indents. This greatly improves my sanity when I'm trying to troubleshoot a SQL query. Imagine this example... SELECT DATE() AS Today_Date ,NOW() AS Today_Now ,CDate(DateUpdate) AS DateUpdate_CDa...
- 08 Aug 2022, 23:31
- Forum: Scripts and Functions (v1)
- Topic: Faster Image Search in Active Window - A wrapper function for FindText
- Replies: 6
- Views: 4462
Re: Faster Image Search in Active Window - A wrapper function for FindText
When I created this Active Window function I was using FindText() to find all of the header dividers in the Access Query Designer. I noticed a significant speed improvement when searching was limited to the active window. image.png Besides a speed improvement, finding images in just the active windo...
- 12 Oct 2020, 14:27
- Forum: Ask for Help (v1)
- Topic: How to simply encrypt a piece of text without using a password? Topic is solved
- Replies: 13
- Views: 5049
Re: How to simply encrypt a piece of text without using a password? Topic is solved
I use AHK scripts everyday with encryption that is based on unique properties of my computer so that the scripts will only execute correctly on my computer. The unique properties of my computer is the key to the encryption. The scripts have lots of secret stuff but I never have to enter a password ...
- 01 Oct 2020, 13:13
- Forum: Scripts and Functions (v1)
- Topic: [GAME] Snake
- Replies: 9
- Views: 6016
Re: [GAME] Snake
Thanks for sharing this. I have a few issues with the responsiveness of the keyboard but it's a cool proof of concept of what AHK is capable of.
- 08 Feb 2020, 17:42
- Forum: Ask for Help (v1)
- Topic: FindText unable to determine if box is checked
- Replies: 1
- Views: 352
Re: FindText unable to determine if box is checked
I spent more time monkeying around and found a pattern that worked using the ColorPos2Two method that looks like it inverses the pixels. Even with that method I had to adjust the Similarity setting and test multiple times. I'm still puzzled why FindText had so much trouble detecting a difference bet...
- 08 Feb 2020, 15:07
- Forum: Ask for Help (v1)
- Topic: FindText unable to determine if box is checked
- Replies: 1
- Views: 352
FindText unable to determine if box is checked
I'm using FindText with the Find dialog of Notepad++ . I want to determine if a check box contains a check and if not, mark it. I've used FindText a lot and find it unusual to have a false positive. I've tried adjusting various tolerances (randomly) and can't find a way to only detect the unmarked b...
- 13 Oct 2019, 21:07
- Forum: Forum Issues
- Topic: Want to add animated GIF to post but "Broken Link for safety" appears
- Replies: 16
- Views: 7160
Re: Want to add animated GIF to post but "Broken Link for safety" appears
My GIF doesn't show the 'place inline' option, probably due to the size. As you saw in my last email, the attachment didn't show up at all, though there was no warning that it was too big, I was short on permissions, or anything. The Status was just a green bar. It stayed that way a few minutes. I w...
- 13 Oct 2019, 20:56
- Forum: Forum Issues
- Topic: Want to add animated GIF to post but "Broken Link for safety" appears
- Replies: 16
- Views: 7160
Re: Want to add animated GIF to post but "Broken Link for safety" appears
Test uploading my GIF.
- 07 Oct 2019, 18:16
- Forum: Forum Issues
- Topic: Want to add animated GIF to post but "Broken Link for safety" appears
- Replies: 16
- Views: 7160
- 07 Oct 2019, 18:08
- Forum: Forum Issues
- Topic: Want to add animated GIF to post but "Broken Link for safety" appears
- Replies: 16
- Views: 7160
Re: Want to add animated GIF to post but "Broken Link for safety" appears
So, what I think I'm hearing here is: 1) I need to have more posts, roughly 30. 2) I need to make sure the link is to a source where it is still a .GIF and now a link to a viewer (or whatever Google Drive gave me for my example). 3) Uploading an image may work instead of using a link, but I can't te...
- 25 Sep 2019, 15:54
- Forum: Forum Issues
- Topic: Want to add animated GIF to post but "Broken Link for safety" appears
- Replies: 16
- Views: 7160
Want to add animated GIF to post but "Broken Link for safety" appears
I want to share a script and I've made an animated GIF that shows what it does. My image is stored on Google Drive with a public link. When I put the link between img tags and preview the post, it says "Broken Link for safety" and does not show the image. I have seen other posts on this site with an...
- 25 Sep 2019, 15:18
- Forum: Scripts and Functions (v1)
- Topic: Faster Image Search in Active Window - A wrapper function for FindText
- Replies: 6
- Views: 4462
Re: Faster Image Search in Active Window - A wrapper function for FindText
I'm still not sure what you are asking. My wrapper function accepts the err1 and err0 parameters and just passes them on to the the official FindText() function. If you want to pass them in a different order they you would need to adjust the code. There are some parameters that I'm not accepting and...
- 15 Sep 2019, 20:38
- Forum: Scripts and Functions (v1)
- Topic: FindText - Capture screen image into text and then find it Topic is solved
- Replies: 1087
- Views: 571927
Re: FindText - Capture screen image into text and then find it Topic is solved
ricardo231 @Ben if I use your code I can search the converted image on any screen without failing? If you have a monitor to the left of your primary monitor the default code will fail. FindText( 0, 0 , A_ScreenWidth, A_ScreenHeight, 0, 0, Text) 0,0 is the top-left coordinate of the primary monitor,...
- 15 Sep 2019, 20:26
- Forum: Scripts and Functions (v1)
- Topic: Faster Image Search in Active Window - A wrapper function for FindText
- Replies: 6
- Views: 4462
Re: Faster Image Search in Active Window - A wrapper function for FindText
Can you elaborate on your request? I didn't mention tolerance or percentage in my post so I'm not sure what you're asking for.
- 26 Aug 2019, 09:01
- Forum: Scripts and Functions (v1)
- Topic: FindText - Capture screen image into text and then find it Topic is solved
- Replies: 1087
- Views: 571927
Re: FindText - Capture screen image into text and then find it Topic is solved
I want to report a quirk or minor bug in the Capture interface. I want to point this out in case there people are experimenting with Capture and Test and can't figure out why it seems inconsistent (like I did). If I am using multiple monitors and I search for an image on another monitor, the boilerp...
- 25 Aug 2019, 23:25
- Forum: Scripts and Functions (v1)
- Topic: Faster Image Search in Active Window - A wrapper function for FindText
- Replies: 6
- Views: 4462
Faster Image Search in Active Window - A wrapper function for FindText
FindText is a function similar to the AHK built-in command "ImageSearch", but it can convert images into strings, written into the script without saving as an external image, so it is easier to use than "ImageSearch". https://www.autohotkey.com/boards/viewtopic.php?t=17834 I am really impressed wit...
- 01 Aug 2019, 17:04
- Forum: Scripts and Functions (v1)
- Topic: MS Access Manager - SQL Query
- Replies: 3
- Views: 2883
Re: MS Access Manager - SQL Query
This topic caught my interest. Are you still developing your scripts? I just found your post but haven't tried it yet. I am also an Access Developer and have made a few scripts that I'd like to share. I don't know if there is already a thread for this or not, but here's one: Switch between Access ob...