HeXetic

I guess it would depend on what kind of data your are sharing. You could use SQLite if you need a whole database to store data (See SQLite Management). Alternatively you could also use an ini file to store the information (See IniRead and IniWrite). If you'd rather not have any kind of file you can always use the Windows Registry (See Registry Management).

This works great, thanks a lot man. It looks like StringSplit was the function I need, I don't know how I missed that.

I'm trying to format a string using StringFormat but i'm not sure how to do it properly. The string I'm formatting is this: \\Servername\HP Laser Color 3500 What I want to end up with is the "Servername" as one string and "HP Laser Color 3500" as another string. Of course if there is a better way of doing this instead of using StringFormat let me know.

Ah yes I didn't look at the "stop a started service" & "start a stopped service". I have it working now, thanks.

This is exactly what I've been looking for. However, is there any way to check if just one service is running (or not running)? Or even better, can you specify a selection of services to check?

This function does not appear to work when you try and get information from a table. Each time I get the following message: _sql.au3 (262) : ==> Error in expression.: $hQuery = $hConHandle.Execute($vQuery) $hQuery = ^ ERROR I'm using AutoIt 3.3.0, I notice the fimction used AutoIt 3.2. Is this the cause of the problem?

Edit: Oh man clearly I haven't had enough sleep, this was meant to go to General Help and Support not here I tried to submit this to trac but it kept on returning the error "Submission rejected as potential spam". Anyway the syntax in the _SQLite_GetTable example in the AutoIt help contains an extra bracket which prevents the script from running. I know its not major but new users won't find it very helpful. It is on Line 49 just below the _ArrayDisplay function. _ArrayDisplay($aResult, "Query Result") ) ;<---- This bracket should not be here! Else MsgBox(16, "SQLite Error: " & $iRval, _SQLite_ErrMsg ()) EndIf

That was just what I needed, I have it working perfectly now. All I did was add two lines in the WM_SIZE function to delete the existing Item column, and then recreate it with the $iWidth variable minus the size of the other two columns. I'm not sure if this is the most efficient way of doing it, but it definitely works. For anyone that's interested, here is an example. Edit: Found a better way, the old method ended up removing everything in the Item column, it now just resizes the column without deleting it. See below: #include <GUIConstantsEx.au3> #include <WindowsConstants.au3> #include <GuiListView.au3> #include <WinAPI.au3> $Gui = GUICreate("Gui", 500, 500, 100, 100, BitOr($GUI_SS_DEFAULT_GUI, $WS_MAXIMIZEBOX, $WS_SIZEBOX)) $List = _GUICtrlListView_Create($Gui, "", 10, 10, 480, 480) _GUICtrlListView_SetExtendedListViewStyle($List, BitOR($LVS_EX_GRIDLINES, $LVS_EX_FULLROWSELECT, $LVS_EX_SUBITEMIMAGES)) _GUICtrlListView_InsertColumn($List, 0, "No", 70) _GUICtrlListView_InsertColumn($List, 1, "Item", 310) _GUICtrlListView_InsertColumn($List, 2, "Status", 100) GUIRegisterMsg($WM_SIZE, "WM_SIZE") GUISetState() While 1 $Msg = GUIGetMsg() If $Msg = $GUI_EVENT_CLOSE Then Exit WEnd Func WM_SIZE($hWnd, $Msg, $wParam, $lParam) Local $iWidth = BitAND($lParam, 0xFFFF) Local $iHeight = BitShift($lParam, 16) _WinAPI_MoveWindow($List, 10, 10, $iWidth - 20, $iHeight - 20, True) _GUICtrlListView_SetColumn($List, 2, "Item", $iWidth - 260) Return $GUI_RUNDEFMSG EndFunc

Hmm OK I will have a look into this as i'm not too familiar with GUIRegisterMsg(), but thats for the help, much appreciated.

Well that works just fine. I didn't know you could combine GUICtrlCreateListView with the _GUICtrlListView UDF. I have incorporated this method into my program and the data retrieval and editing all still works. Just one last question though. When the window is resized or maximized I need the Item column to resize according. The rest of the columns always need to stay the same size, is this possible to do?

I have a GUI with a listview created with _GUICtrlListViewCreate, but I need to get it to resize when the window is resized or when the window is maximized. I have tried to use the GUICtrlSetResizing method but that only seems to work with the built in GUI Control Creation. Below is an example of what i'm trying to do: #include <GuiConstantsEx.au3> #include <WindowsConstants.au3> #include <GuiListView.au3> $GUI = GUICreate("Resizing", 500, 200, -1, -1, $WS_OVERLAPPEDWINDOW) $TodoListView = _GUICtrlListView_Create($GUI, "", 10, 20, 480, 160) _GUICtrlListView_SetExtendedListViewStyle($TodoListView, BitOR($LVS_EX_GRIDLINES, $LVS_EX_FULLROWSELECT, $LVS_EX_SUBITEMIMAGES)) _GUICtrlListView_InsertColumn($TodoListView, 0, "No", 70) _GUICtrlListView_InsertColumn($TodoListView, 1, "Ref", 70) _GUICtrlListView_InsertColumn($TodoListView, 2, "Item", 270) _GUICtrlListView_InsertColumn($TodoListView, 3, "Status", 70) GUICtrlSetResizing(-1, BitOR($GUI_DOCKHEIGHT, $GUI_DOCKTOP, $GUI_DOCKLEFT, $GUI_DOCKBOTTOM)) GUISetState(@SW_SHOW, $GUI) While 1 Switch GUIGetMsg() Case $GUI_EVENT_CLOSE Exit EndSwitch WEnd

Yeah they are all in the format of IT Manual ## so stringtrimleft should work just fine. Thanks very much.

Hopefully there is a quick an easy solution to this but I couldn't see any solution in the help file. Basically I want to get the integers values out of a string. For example I have the string "IT Manual 18" but I jut want to get the number 18 from it. Thanks in advance.

That wasn't quite the right function but it was right next to _GUICtrlListView_GetSelectedIndices which is exactly what I needed. Thanks for the help.

I am trying to get the index number of a selected item in a list view. In other words if a user selects one of the rows in the list view that can press a button and it will return the index number of the selected row. I looked at the _GUICtrlListView_GetHotItem function but that only appears to return the index of the item that the mouse is hovering over, however, this is the kind of thing i'm looking for.

Thanks very much weaponx, works perfectly.

Yeah exactly like that. This is definitely one way of doing it but I was hoping there would be some kind of function to get the amount of minutes based on what the user has already entered.

I'm busy writing a task management tools that functions as a time sheet. The users enters in all the details and it gets stored in a SQLite database. Two of the details that the users enters is the time they Started a task and the Time they Ended the task. What I need to do is get the amount of minutes spent on the task. For example if a user started a task at 09:00 and ended it at 10:25 I need the program to return 85 Minutes.

Thanks just what i needed!

Is it possible to create an input field for entering the time but make it function like the Windows Clock time field? For example if you look at the screenshot below the hours minutes and seconds are all separated by a colon that cannot be removed, and each part of the time (i.e. hours, minutes, seconds) is edited separately.

Ah never mind I figured it out you just have to run the _EventLog__Read function again and it will move on.

I'm busy putting together a script that will run through the event log and find any errors in the past 24 hours but I'm stuck right at the start. I am able to read one record but how to you get it to move on to another. Below is just a quick bit of code that I put together to experiment with. #include <EventLog.au3> $hEventLog = _EventLog__Open ("", "Application") $Read = _EventLog__Read($hEventLog, True, False) $Output = "Did you read the event: " & $Read[0] & @CRLF $Output &= "The event log ID is : " & $Read[1] & @CRLF $Output &= "Date and Time: " & $Read[2] & " " & $Read[3] & @CRLF $Output &= "Error Type: " & $Read[7] MsgBox(64, "Info", $Output)

Very nice but is there any way to copy the entire contents of the folder or maybe the folder itself?

Ah yes Sleep was exactly the function I needed. I tried searching for Pause, Delay, Wait but not Sleep. Thanks guys its working great now.

I'm currently writing a script that will perform a restore using NTBackup. So far all is fine until I get to adding a new backup catalog. When you add a catalog there is about a 5 - 10 second wait before the program becomes responsive again. The problem is the script doesn't wait for this and makes the rest of the script useless. I can't use WinWaitActive because the backup window is always active. And I can't use WinWaitClose because nothing closes. I tried to use Opt("WinWaitDelay", 10000) but that didn't seem to work. The only other thing I can think of is a message box asking the user to click OK when ready to continue but I'd really rather not have that. $answer2 = MsgBox(4, "New Catalogue", "Do you want to add the new catalogue?") If $answer2 = 7 Then Exit Else Send("!t") Send("t") Send ("{ENTER}") ; Needs to wait here for about 10 seconds Send("{TAB}") Send("{DOWN}")