Search found 22 matches

by Ben
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...
by Ben
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...
by Ben
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...
by Ben
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...
by Ben
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...
by Ben
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 ...
by Ben
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.
by Ben
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...
by Ben
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...
by Ben
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...
by Ben
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

Re: Want to add animated GIF to post but "Broken Link for safety" appears

nnnik wrote:
04 Oct 2019, 03:53
Well if its not a .gif but instead an html that you linked why do you expect it to work?
I tried using it as an attachment, which didn't work, as well as a link to Google Drive, which I incorrectly assumed was a pointer to a file.
by Ben
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...
by Ben
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...
by Ben
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...
by Ben
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,...
by Ben
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

ricardo231 wrote:
04 Sep 2019, 02:26
Could the tolerance percentage be changed?
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.
by Ben
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...
by Ben
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...
by Ben
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...

Go to advanced search