Ahh, I get you,

thats perfect, thanks all

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

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

garry wrote:@JackPJ, sorry I don't really understand the function 'EnableGuiDrag' , have just basic knowledge with ahk- commands

No Worries, thanks anyway

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?

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

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

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

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

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

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

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

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

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

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

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

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

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