Search found 18 matches

by JackPJ
07 Feb 2018, 11:08
Forum: Ask For Help
Topic: Set cursor Location in edit box? Topic is solved
Replies: 5
Views: 184

Re: Set cursor Location in edit box? Topic is solved

Ahh, I get you,

thats perfect, thanks all
by JackPJ
07 Feb 2018, 10:09
Forum: Ask For Help
Topic: Set cursor Location in edit box? Topic is solved
Replies: 5
Views: 184

Re: Set cursor Location in edit box? Topic is solved

Thanks, I just realised I worded my question poorly and didn't cover all options, I'd ideally like to keep the cursor wherever it is when the text gets removes. i.e if I went back to a box that has "123456789" and entered a % in the middle like "12345%6789" I'd still want my cursor to stay in the sa...
by JackPJ
07 Feb 2018, 09:55
Forum: Ask For Help
Topic: Set cursor Location in edit box? Topic is solved
Replies: 5
Views: 184

Set cursor Location in edit box? Topic is solved

HI all, I'm trying to move the cursor to the end of an edit box after my g-label triggers and removes the non-"a-z0-9" characters. currently, the G-label triggers, removes the * from the string, and updates the editbox. but the cursor is back at the start of the box. I know I could end the g-label w...
by JackPJ
05 Feb 2018, 10:01
Forum: Ask For Help
Topic: Listview is deleting my tabs? Topic is solved
Replies: 8
Views: 279

Re: Listview is deleting my tabs? Topic is solved

garry wrote:@JackPJ, sorry I don't really understand the function 'EnableGuiDrag' , have just basic knowledge with ahk- commands
No Worries, thanks anyway
by JackPJ
05 Feb 2018, 09:37
Forum: Ask For Help
Topic: Listview is deleting my tabs? Topic is solved
Replies: 8
Views: 279

Re: Listview is deleting my tabs? Topic is solved

Thanks Garry, that's a tonne of help! I should be able to port the dragging code over to mine easily enough now

I don't suppose you know what part of the dragging code in my example is causing the conflict or why? so I can learn a bit from all this?
by JackPJ
05 Feb 2018, 08:35
Forum: Ask For Help
Topic: Listview is deleting my tabs? Topic is solved
Replies: 8
Views: 279

Re: Listview is deleting my tabs? Topic is solved

Thanks Garry, I've managed to now condense the issue down to the following code Gui, 1:color, f7f7f7 ;~ ===== Sets the background colour of the window (F5F5F5) gui, 1:-border ;~ ===== Turns off the border ;~ ===== Changes the font temporarily to add the Tabs, then changes back Gui, 1:font,s12, Verda...
by JackPJ
05 Feb 2018, 05:18
Forum: Ask For Help
Topic: Listview is deleting my tabs? Topic is solved
Replies: 8
Views: 279

Re: Listview is deleting my tabs? Topic is solved

Apologies, I left that in from before when I was trying to differentiate between two different listviews, but I forgot to remove it when it didn't work.

It doesn't solve my issue though :(
by JackPJ
02 Feb 2018, 11:04
Forum: Ask For Help
Topic: Listview is deleting my tabs? Topic is solved
Replies: 8
Views: 279

Listview is deleting my tabs? Topic is solved

Hi all, I've got some code where I set up a gui with multiple tabs, I then try to add a listview to one of the tabs. But by adding in the bold line below, the listbox appears, but all my tabs disappear? :( What am I missing here? ;~ ===== Changes the font temporarily to add the Tabs, then changes ba...
by JackPJ
07 Aug 2017, 04:53
Forum: Ask For Help
Topic: Using Excel COM to paste from an object into cell range?
Replies: 1
Views: 329

Using Excel COM to paste from an object into cell range?

Hi all, I'm trying to work out how to paste or insert an object (returned data from a SQL query) into excel. This is an example of the code I have so far : lrAllDataSQLQuery := "SELECT * FROM EXAMPLETABLE" lrAllDataObject := ADOSQL(ConnectionString,lrAllDataSQLQuery) I can access individual items li...
by JackPJ
26 Jun 2017, 07:47
Forum: Ask For Help
Topic: help converting text to CSV Topic is solved
Replies: 5
Views: 431

Re: help converting text to CSV Topic is solved

You guys are geniuses!
That example works perfect for me, I should be able to 'bodge it' to display as I need. Thanks all for your time, I'll mark this as solved unless I get stuck.

Looks like I need to spend some time on google learning JSON. It still looks Greek to me
by JackPJ
26 Jun 2017, 07:17
Forum: Ask For Help
Topic: help converting text to CSV Topic is solved
Replies: 5
Views: 431

Re: help converting text to CSV Topic is solved

Thanks both, I'll have a play around with it with the info you've given me and fingers crossed I can get somewhere In hindsight, had I have know what JSON is or if it would be relevant, the part on the API doc saying The API is implemented as a standard JSON web service would have probably been of u...
by JackPJ
26 Jun 2017, 05:01
Forum: Ask For Help
Topic: help converting text to CSV Topic is solved
Replies: 5
Views: 431

help converting text to CSV Topic is solved

Hi All, I'm having a problem formatting some text I get from a website. I use a send request (not sure what the correct term is) to get data from https://data.police.uk/ If I use the example below from their API docs, I get this wall of text. https://data.police.uk/api/crimes-street/all-crime?lat=52...
by JackPJ
26 Jan 2017, 09:46
Forum: AutoGUI
Topic: AutoGUI - Script Editor, GUI Designer, Debugger and Tools
Replies: 327
Views: 159752

Re: AutoGUI - GUI Designer and Script Editor

Hi,

could someone tell me if I'm doing something clearly wrong/stupid here?

I've just downloaded the zipped file, unzipped it and tried to run AutoGUI.ahk.

Yet all I get is the attached error?

Am I missing something simple here?

Thanks

Jack
by JackPJ
09 Dec 2016, 05:17
Forum: Ask For Help
Topic: Excel ComObject leaves excel.exe open after closing?
Replies: 10
Views: 1117

Re: Excel ComObject leaves excel.exe open after closing?

I've tried the display alerts already but no luck :( Really? Like this? Xl.DisplayAlerts := false ; Ignore the warning that a macro enabled workbook (.xlsm) is being saved as .xlsx Xl.ActiveWorkBook.SaveAs(SaveLoc, 51) ; xlOpenXMLWorkbook = 51 Xl.DisplayAlerts := true Yes exactly like that. I often...
by JackPJ
08 Dec 2016, 10:25
Forum: Ask For Help
Topic: Excel ComObject leaves excel.exe open after closing?
Replies: 10
Views: 1117

Re: Excel ComObject leaves excel.exe open after closing?

Thanks for the reply, but I think that's what the 'xl.quit' was doing in my code as xl := excel.application? I've tried the display alerts already but no luck :( I thought I had narrowed it down to a certain part , but it turns out, it's just sporadic in deciding when to leave the process open or no...
by JackPJ
08 Dec 2016, 09:30
Forum: Ask For Help
Topic: Excel ComObject leaves excel.exe open after closing?
Replies: 10
Views: 1117

Excel ComObject leaves excel.exe open after closing?

Hi all, I'm trying to work out how to close an excel comobject correctly without it leaving open a process in the background. I cant use the get around of ending any process named excel.exe because I may have other copies of excel open at the time. Could anyone take a look at the below and let me kn...
by JackPJ
01 Dec 2016, 12:25
Forum: Ask For Help
Topic: Excel Com Object Causing script to hang on exit?
Replies: 0
Views: 155

Excel Com Object Causing script to hang on exit?

Hi all, I have a really strange issue with my program right now that I've never heard nor come across before. I have a gui, containing some buttons and lists. The buttons take the selected item from the list, open an excel doc (comobjcreate), run a macro with the list item as the variable then save ...
by JackPJ
26 Oct 2016, 07:38
Forum: Ask For Help
Topic: How to synchronize list-box scroll positions?
Replies: 0
Views: 341

How to synchronize list-box scroll positions?

Hi all, I have a 5 list-boxes side by side, which all have an array with the same amount of items in it. Currently, i can make it so all list boxes highlight the same row when you click one, but I cant get the scrollbars to synchronize. i.e if I manually scroll down one box and select an item, the o...

Go to advanced search