Gerry

Thanks for your advice, wow there are so much I still need to learn!

Hi Thanks for your response, it worked. I had the following line: $Combo2 = GUICtrlCreateCombo("", 147, 47, 100, 25, BitOR($CBS_DROPDOWN, $CBS_AUTOHSCROLL)) which I then with a quick glance converted to : $ComboPrnType2 = GUICtrlCreateCombo("", 147, 47, 100, 25, $CBS_DROPDOWN) I then tested it and of course it did not work and I was ready to shout! After carefully rechecking your response noted your said $CBS_DROPDOWNLIST and not $CBS_DROPDOWN LOL, thanks for your help, I appreciate it. May the Springboks win the Rugby World Cup! Gerry

Hi All I created a Gui with a few Combo boxes, and then populated them with data. How do I stop the user from changing this data and only able to select from I options provided by me? Gerry

Thanks for your response I had a look at this but I think this is a bit over my head but I will try to make sense of it. LOL Gerry

Hi All I am using _INetSmtpMailCom() to mail some of our clients from a terminal server session. I have copied WAB.exe in the same folder as the script and added some of our clients email addresses to the addressbook in the same folder. My Gui will open a To field and a Cc field The Cc field I have an Ini which has all the account managers email addresses listed, a copy of the mail I'm sending goes to them in caae a client enquires about the email he has received. The To field opens the Windows address book but the user has to copy and paste the clients email address from the address book to the To field manually. I'm hoping to do it like Outlook Express does it but I don't have the faintest idea on how to achieve this. I'm including my code which works but need some help on how to get the address book function to work properly. Any help or suggestions would be appreciated. Gerry File Mailer.au3

Hi All I'm trying to write an app which must logon to a secure site using VPN and then reset certain PC logon sessions as required, this will be sent to the app via email. I am starting at he Logn to the secure site but I am already having problems here. Try as I may, I am unable to automate this. Here is some of my source code: #include <IE.au3> If Not WinExists("Authception Login Page", "" ) _ Then _OpenBrowser() Func _OpenBrowser() $oIE = ShellExecute ("iexplore.exe", "https://172.20.200.46/Authception/") _WinWaitActivate("Security Alert", "Information" ) ControlClick("Security Alert", "Information you exchange", "Button1") _WinWaitActivate("Authception Login Page - Microsoft Internet Explorer", "https://172.20.200.46/Authception/" ) EndFunc _WinWaitActivate("Authception Login Page", "" ) ControlClick("Authception Login Page", "", "[CLASS:Internet Explorer_Server; INSTANCE:1]", 100, 115) MouseClick("Primary", 100, 115) Send("LogonID") ControlClick("Authception Login Page", "", "[Class:IEFrame]", 100, 145) MouseClick("Primary", 100, 145) Send("Password") ControlClick("Authception Login Page", "", "[Class:Internet Explorer_Server]", 50, 170) MouseClick("Primary", 50, 170) Func _WinWaitActivate($title,$text,$timeout=0) WinWait($title,$text,$timeout) If Not WinActive($title,$text) Then WinActivate($title,$text) WinWaitActive($title,$text,$timeout) EndFunc I have tried to attach the source code of the logon page but I am unable to attach this as a text file, it under 4KB. Can someone please assist me or give me some directions on how to logon to this site? Gerry

Hi Stefan Thanks, I did as you said and it worked first time! I really appreciate your help. Gerry

Stefan, sorry to bug you again I tried your line and it works fine on the AutoIt CHM, I decompiled it and saw how the CHM was assembled and I can select different html files items in various folders. ShellExecute ("hh.exe", "mk:@MSITStore:C:\Program Files\AutoIt3\AutoIt3.chm::/html/faq.htm") Works like a charm. Problem is when I do my rotten CHM file, it opens the file but says "The page cannot be dispayed" Any ideas? Gerry

Thanks Stefan! I didn't suspect it would be that easy! ) Gerry

Hi All I have created a CHM file for my application. I open the CHM file with this line: ShellExecute(@ScripDir & "\Help.chm") I would ideally like to jump to a specific topic in the Help file, much like the context sensitive ehlp we AutoIt uses in its help file from the Scite editor. Can anyone please shed some light on how to do this please? Gerry

Thanks to all who read this post and to those who responded. I tied the tooltip in a loop but since I am actually having a problem with "GUICtrlSetTip", "Tooltip" won't do the job, I tried it though, no flicker as you said but with "GuiCtrlSetTip" it does flicker. I experimented with the delay and the sleep time in the loop, longer sleep times gives a better display but the response time suffers and it would actually apear if the App is hanging when exitting. I suppose the TrayIcon message is also related to "Tooltip"? Seems like I / we will just have to live with what Is not a "bug". Anyhow I still love AutoIt to bits! Have a greate day Gerry

Hi All I have created a Gui with some Tooltips. Some of these tooltips have lots of text in them and if the user takes to long to read them, the Tooltips disapear and won't dispay again. Is this normal? How can I overcome this problem? I also noted when using: Opt("TrayIconDebug",1)does the same thing and may also display too low as to be unreadable, it hides it self below the Taskbar. The debugging of scrips using this facility is then not possible. Is this a bug or how can I fix this. I am using Windows XP Pro, SP3. Regards Gerry

Hi Stefan Thanks for your assistance, modified slightly and it is working !! I also rethought Tunkey answer with Netstat and I eventually saw the value in her suggestion, I'm very slow . . . LOL, but using Netstat to check the status of Telnet connection could also work, one would need a bit more code to get a clean answer but yes it is workable too. Sorry I took so long to get back but as I said I'm slow and don't get too much time to spend on this. Thanks to everyone again Gerry

Thanks for your response Tunkey Netstat only shows already connected connections, not realy what I'm looking for . . . Thanks any way I thought one of the other Guru's would an easie option. Gerry

Hi All We are running some application that requires a SSL connection on port 443 at most of our clients. Clients install this application themselves but unfortunately some are not too PC leterate. Asssiting these users can be a nightmare since some OS's don't have Telnet installed by default. Getting users to get to the DOS command prompt is already a mission. We start of to check if the client is at least connected to the Internet with a ping to a known site, if all ok, we will do the next step Now we need to see if the client can connect to port 443 on our host site with Telnet. If Telnet is not installed we need to do this first. Simply copying Telnet.exe does not work and since there are so many variations, this might be problem too and besides that it still does not run on Windows 7 unless it is enabled . loaded. The ping part is easy since AutoIt has this built in but since Telnet is not, I need to be able to check this connectivity on port 443. I downloaded a a "command line" DTELNET.exe. This works fine on all OS's without too many pains but one can not read the GUI that it opens or its status bar, that is other than visual. I've seen a lot of example scripts on Telnet but not realy what I'm looking for. Is there perhaps another way of checking the port connectivity to my hosts or has anyone perhaps have a better suggestion on how to accomplish this? Any help or suggestions would be appreciated. Gerry

Hi Thanks for your response, it was realy informative and I foolwed your advice to read more on the subject I think I will stay with SqLite, I will create a file for each client and since only 4 consultants would work on any one clients file at atime, this should reduce the file sizes and possible simultanous access there of. >> It's still possible to wrap a server layer around it, but it doesn't come in the package I saw a few shareware / freeware server wrappers and also a commercial solution to network SqLite, I will probably use an implementation with access via sockets. If the worst case, I will have to put my hand deep in to my pocket for the comercial version . . . I don't know how viable it is to open a database, read / change it and immeadiately close it again, this may stop simultanous access but slow the process down. Sorry I'm just trying to sound clever. Regards Gerry

Wow, that was a mouthful! It settles it, I don't need to use Indexing then. I am trying to write program for a very small call centre, maybe 20 users. All fields will be less than 20 charackets but for one where notes are taken about the call. I'm deviding the database file into sections with a table for each client all his debtors details in that table about 30 columns. I don't think any of these entries will ever have 10 000 lines in them. Tipcally I don't think any one Client Table would be ever reach 1 000 entries. I weighting up between adding another column to containing scanned account attachments and I then havimg a separate folder for attachments. Would having the attachments in the Database slow down performance significantly? I know the database file will be larger but the attachments will be on the drive anyhow, it is just more convenient. I think I ahve answered my own question, attachemts included in the database impact the speed badly for networked users, you don't need to download one large file, you could just download the database and what attachments you need, when and if. Thanks for your responses so far. Gerry

Thanks for all the reponses I will looking out for your updates! Next question, class is in session . . . I was wondering the memory footprint of Indexing some columns of my tables. Indexing enlarges the database, is this index then kept in memory to speed up transactions? Sorry to ask it here, I should probably ask this in a SQLite forum. Gerry

Thanks Valuator for your response. If I look at all the projects you have are doing, I imagine you to be a very busy man. I wouldn't expect you to be doing updates, you already have a lot on your plate but your code has assited me great deal so far, thanks for that. ) Regards Gerry

Thanks, I realy appreciate your assistance. I have been to quite a few sites and looked at number of AutoIt example scripts. I would seem most of the examples provided assume a proficiency with both SQLite or SQL and AutoIt. I found most of the AutoIt scripts don't work anymore on the latest release. One can modify a lot of these settings and then hope to perhaps eventually get the scripts going again but it feels like you are re-inventing the wheel again as there is very little comments to understand why certain procedures were taken. Please I'm not knocking or intending this to offend anyone, scripts comments realy help wannabe programmers like me and I am apprciative for any examples provided. I now have something to work with, I was just about to abandon my idea of using SQLite. Wonderful what happens when one suddenly see the light, isn't it? Thanks again for your assistance Regards Gerry

Hi All I am trying to write a database program using SQLite and may I add the this is the first time I'm trying SQLite. I have managed to create a database file with 2 tables. Each table has a few columns to it but no data lines yet. I am able to see the tables when viewing it with SQLite Expert, so the tables do exist. Them I'm trying to see count and names of the tables I created. Searching for methods to quiery the database to extract the said info, resulted in me using this line: $aClientIndex = _SQLite_Exec(-1,"SELECT * FROM sqlite_master WHERE type='table'","_cb") I then displayed the $aClientIndex in a messagebox but it shows up as Zero MsgBox(0, "SQL Tables : " , $aClientIndex) Can anyone please point me on how I can get the amount of tables and their names? Any help greatly appreciated Gerry

Hi All Hope everyone had a good festive season. I need to create a program to send SMS from my PC to some clients. I also need to keep some client detail on record for this. I have never used an API but I will address that problem later. Valuater wrote an excellent address program (EZ Track) for a postal worker some time ago, and I was hoping to port his hard work for my purpose if that is ok with you Valuator? When I tested it initially I had a problem when one did a search for an item in the database (ini file) it would only find the 1st entry on simmular entries, I have not checked if thius still so in the latest version I could get (Ver 1.6). I am no fundi but think an ini file might be slow and one is limited to the amount of entries in a ini file? Has anyone perhaps reworked EZ Track to use SqLite rather than the original ini database? Thanks Gerry

Hi Thanks again for your response. Ok, the value I put there was wrong, sorry. 1. The point is when I do _ArrayDisplay the "/" are gonein the Date column. 2. Once saved to "TestBackup.xls", the "/" are gone too. 3. Opening "TestBackup.xls" bombs out from the excel udf. 4. Searching a 2D array does not show values which are in the array. I am using XP Pro, SP3, Office 2003 with all current updates in place. Could it have something to do with my locale settings because at home with XP Home, I get the same results? Thanks for your assistance. Gerry

Thanks for your response and the easy way to create a test file, I incorparated part of your script in to my demo. Please try the new demo and tell me if you get the same problems as I do. ; ******************************************** ; Test Script to demonstrate my problem start #include <Excel.au3> #include <Array.au3> Global $sFile = @ScriptDir & "\Test.xls" Global $avSheet, $avCol2, $oExcel Global $avData[5][5] = [[4, 3, "", ""], _ ["", "CH000180462", "26/11/2008 08:43", "Please supply Printer"], _ ["", "CH000180468", "26/11/2008 09:35", "Please upgrade 1 x PC"], _ ["", "CH000180471", "26/11/2008 09:41", "PLEASE UPGRADE 1 X PC IP"], _ ["", "CH000180474", "26/11/2008 09:46", "Install 8 port Trendnet switch"]] If Not IsDeclared("iMsgBoxAnswer") Then Local $iMsgBoxAnswer $iMsgBoxAnswer = MsgBox(260,"Create Test file","Would you like to create a new test file?") Select Case $iMsgBoxAnswer = 6 ;Yes _CreateFile() Case $iMsgBoxAnswer = 7 ;No EndSelect Func _CreateFile() ; Create file $oExcel = _ExcelBookNew() _ExcelWriteSheetFromArray($oExcel, $avData) _ExcelBookSaveAs($oExcel, $sFile, "xls", 0, 1) _ExcelBookClose($oExcel) EndFunc $File = FileOpenDialog("Please select a file to open", @ScriptDir & "\", "(Test*.xls)", 1) ; Select Test file If @error Then ;Error if no daily file was selected MsgBox(4096, "", "No file Selected!") Exit EndIf $oExcel = _ExcelBookOpen($File, 1) ; Open spreadsheet $aArraySheet = _ExcelReadSheetToArray($oExcel) ; Read spreadsheet to array $aArrayColumn = _ExcelReadArray($oExcel, 1, 1, $aArraySheet[0][0], 1) ; Read Column 2 $VarRow2Col2 = _ExcelReadCell($oExcel, 2, 2) MsgBox(0, "Values in Array vs. File", _ "File Row 2, Column 2 : " & $VarRow2Col2 & " vs. Array of sheet value : " & $aArraySheet[2][2] & @CR & @CRLF & _ 'Real value is actualy 26/11/2008 08:43"') _ArrayDisplay($aArraySheet, "Note Column date formatting slashes are gone.") $sSearch = _ExcelReadCell($oExcel, 2, 1) $iIndex = _ArraySearch($aArraySheet, $sSearch, 0, 0, 0, 0, 1) If @error Then MsgBox(0, "Not Found, $aArraySheet", '"' & $sSearch & '" was not found in 2D array, $aArraySheet.') Else MsgBox(0, "Found, $aArraySheet", '"' & $sSearch & '" was found in 2D array, $aArraySheet at position ' & $iIndex & ".") EndIf $iIndex = _ArraySearch($aArrayColumn, $sSearch) If @error Then MsgBox(0, "Not Found , $aArrayColumn", '"' & $sSearch & '" was not found in $aArrayColumn.') Else MsgBox(0, "Found, $aArrayColumn", '"' & $sSearch & '" was found in $aArrayColumn at position ' & $iIndex & ".") EndIf _ExcelWriteSheetFromArray($oExcel, $aArraySheet, 1, 1, 0, 1) _ExcelBookSaveAs($oExcel, @ScriptDir & "\TestBackup", "xls") _ExcelBookClose($oExcel) ; Open spreadsheet MsgBox(0, "Backup file format", "Please open the backed up file manually" & @CRLF & _ "to check column 2 or the date column. Mote the change from the original." & @CRLF & @CRLF & _ "After closing this file, open Test.au3 and then select the backup file." & @CRLF & _ "Note how the Test.au3 file bombs out!") ; End of my demo script ; *************************************** Gerry

Hi All It would seem I'm unable to add the demo Excel file. Wonder if I text to this and then it could be saved as Test.xls ? Here goes: 3 colums, 5 lines: Order No Create Date Description CH0000000180462 26/11/2008 08:43 Please supply Printer CH0000000180468 26/11/2008 09:35 Please upgrade 1 x PC CH0000000180471 26/11/2008 09:41 PLEASE UPGRADE 1 X PC IP CH0000000180474 26/11/2008 09:46 Install 8 port Trendnet switch. Sorry for this amateurish way of sending my demo Excel file. Can't blame anyone if you don't respond to this. Gerry