Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Andrzejek on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: kennedymr2
  • Order by date
  1. kennedymr2

    With Command Looping

    I have a form with 3 datagridView's ie DataGridView1 DataGridView2 etc With DataGridView1 .GridColor = Color.Red .CellBorderStyle = DataGridViewCellBorderStyle.None .BackgroundColor = Color.LightGray '.DefaultCellStyle.SelectionBackColor =...
  2. kennedymr2

    Datagridview Looping Through Multiples

    softhemc Really appreciate the help it worked fine on a normal page But i now find the the page i am trying to process is a TABPAGE ???How do i get the routine to work on a tabpage ????? Appreciate some help if you have time Regards Kennedymr2
  3. kennedymr2

    Datagridview Looping Through Multiples

    I have a form with 6 datagridview controls ie datagridview1 datagridview2 etc I need to loop through the 6 controls to set columnscount etc rather than doing 6 seperate loops , is there a way eg for ll= 1 to 6 With datagridview & str(ll) ???.columnscount=12 end with next ll Really...
  4. kennedymr2

    DownLoadFile Problem

    Using wc As New System.Net.WebClient() Try wc.DownloadFile(Server1 & FileName4, Filename3) AddHandler wc.DownloadProgressChanged, AddressOf pchanged AddHandler wc.DownloadFileCompleted, AddressOf done...
  5. kennedymr2

    Xml Attribute Problem

    strongm (MIS)... Thanks once again for the help, much appreciated...i did not think of subnode... Thanks also for the help you have offered me over the years with various other questions ... Regards Kennedymr2
  6. kennedymr2

    Xml VB6 Multiple Node Problem

    This is the abreviated xml '************************* <Pool Type="XX" Available="Y"> <Dividend Id="629" Amount="12.8000"> <DivResult No="1" RNo="2"/> </Dividend> <Dividend Id="6291" Amount="13.8000"> <DivResult No="1" RNo="4"/> </Dividend> </Pool> VB6 Code.... working ok Set oxmlNodeList =...
  7. kennedymr2

    Xml Attribute Problem

    This is the abreviated xml '************************* <Pool Type="XX" Available="Y"> <Dividend Id="629" Amount="12.8000"> <DivResult No="1" RNo="2"/> </Dividend> <Dividend Id="6291" Amount="13.8000"> <DivResult No="1" RNo="4"/> </Dividend> </Pool> VB6 Code.... working ok Set...
  8. kennedymr2

    Open Web Page in a form

    strongm , I originally thought i had worked out the solution, but i found i walked into some problems., i can see what you are getting at. I will have a good look at SendMessage(hwnd, WM_SETREDRAW, FALSE, 0) All that i am trying to achieve is run firefox or ie using shell in order to get ssl...
  9. kennedymr2

    Open Web Page in a form

    JustinEzequiel, Many thanks... i can now see how to do what i am trying.... Appreciate you time in looking into it for me. Regards Kennedymr2
  10. kennedymr2

    Open Web Page in a form

    JustinEzequiel... Thanks a lot , this has pointed me in the right direction. I need to position eg notepad ...in an exact position on the form.. The example just places the notepad over the top of the main form. I was thinking i could create say a picturebox on say the bottom of the form ...
  11. kennedymr2

    Open Web Page in a form

    I have a program running and would like to open say Firefox in a position on the existing form. I am trying to avoid using webbrowser...., ie. Shell ("C:\Program Files\Mozilla Firefox\firefox.exe c:\submit.html") Can i put say a ???picturebox on my form... and place the above shell exactly...
  12. kennedymr2

    Windows7 Excel Reference excel 5.0

    I am developing an vb6 program on a windows 7 computer which has office 2010 on it. To create an excel spreadsheet i need to reference excel 14 in windows 7 BUT If i send the program to say an old xp computer (with say office 2003 on it) the excel 14 referenced does not exist (it seems to...
  13. kennedymr2

    Export Access Pivot Table to Access

    Finally solved it !!!!! There is no docmd. for this in Access 2010 Solved... Public Function ExportPT() Dim BPT As Office.CommandBarPopup Dim BEPT As Office.CommandBarButton Set BPT = Application.CommandBars("Menu Bar").Controls("PivotTable") Set BEPT = BPT.Controls("Export to Excel")...
  14. kennedymr2

    Export Access Pivot Table to Access

    Just thought !!!! Ie the pivot table is a Form Maybe a form cannot be exported to excel
  15. kennedymr2

    Export Access Pivot Table to Access

    PVH Appreciate your giving time to my post... Not real sure about export a crosstab query....i am trying to export a pivot table... The acexport only seems to be able to export a table Regards Kennedymr2
  16. kennedymr2

    Export Access Pivot Table to Access

    PHV (MIS) I tried using this but it will not export a pivot table only a normal table Regards Kennedymr2
  17. kennedymr2

    Export Access Pivot Table to Access

    When the pivot Table is loaded and visual... There is a button at the top export to excel When this is pressed it creates a spreadsheet.. I also then need to save it auto as well Regards Kennedymr2
  18. kennedymr2

    Export Access Pivot Table to Access

    I am using Access 2010 Trying to write a function to include in a macro to export a pivot table to excel. something like !!!!! DoCmd.TransferSpreadsheet acCmdPivotTableExportToExcel, acSpreadsheetTypeExcel7, "datatabpivot", strFullPath & "Daily.xls", False I realize that...
  19. kennedymr2

    Multiple reports same query

    PWise Exactly what i was after... many thanks... helped a lot Regards Kennedymr2
  20. kennedymr2

    Multiple reports same query

    Mazeworx.. Thanks for your comments. A bit hard to do seperate query's in this instance. Looking for while ??????? report is open do events wend regards Kennedymr2

Part and Inventory Search

Back
Top