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!

Register Log in
  • Congratulations derfloh 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
  • Content: Threads
  • 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

    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...
  3. 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...
  4. 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 =...
  5. 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...
  6. 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...
  7. 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...
  8. 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...
  9. kennedymr2

    Multiple reports same query

    in VBa i am printing several reports , but the problem i have is they are using the same query.. i keep getting a message that the table is already in use Is there a way of stopping the preview of the second report until the first report is printed and completed, This is the code Dim...
  10. kennedymr2

    Access Report Printing Completed

    Vba Code.. Is there code to determine if an access report has been completed. Ie hold up code in a Sub until report is completed Appreciate any help
  11. kennedymr2

    Convert Cents to Dollar/Cents

    Sorry for such a simple question.. i must be betting old. ?? Is there a "simple" function to convert say 1323 to 13.23 Regards kennedymr2
  12. kennedymr2

    Add Date to Time

    Using VB2008 I have a string #10:00:00# Need to add todays date to to above to get a datetime eg "#10/7/2011 10:00:00#" Is there a simple way of doing this ??? Appreciate some help regards Kennedymr2
  13. kennedymr2

    Pivot Table Access 2010

    I am having a slight problem wit Access 2010 and Pivot Table. When the amount of data in a "GROUPING" exceeds a certain size, it only visually displays a small number of items, and to look at data furthur down, it has a scroll bar on the right. Ie is a scroll bar on the right of the group...
  14. kennedymr2

    For ll = 0 To File3.ListCount - 1

    Is there any way of making the File3. variable Ie i want to run the for.... using eg File3. File4. File5. etc For ll = 0 To File3.ListCount - 1 vvv="File3" ?? For ll = 0 To vvv.ListCount - 1 Appreciate any help Regards Kennedymr2
  15. kennedymr2

    DataGridView Update Mdb

    I am using vb2008 Express Have setup a datagridview using the wizard.. and an Access MDB Have setup AllowEdit AllowAdd etc When i make an alteration it works fine while the program is still loaded, BUT, when i close the program and then reopen, the alterations have gone. It looks like the...
  16. kennedymr2

    Directory List http:// site

    Is there a simple way of getting a directory list of files on a http:// site Trying to avoid using: FtpGetCurrentDirectory If i download the url source all the files are there in the text retrieved, but i will have to parse the file. Appreciate any simple tip, if there is one. Regards...
  17. kennedymr2

    Remove DataSet

    I added a .mdb database to my project and created several datasets using the tables and queries in the .mdb.. just temporarily. I now need to remove it from my project. I seem to be able to remove the reference to the .mdb BUT am now stuck with several dataset references in Projext Explorer...
  18. kennedymr2

    DoCmd.DoMenuItem acFormBar, acRecordsMenu, acSaveRecord, , acMenuVer70

    I seem to be having a problem with: DoCmd.DoMenuItem acFormBar, acRecordsMenu, acSaveRecord, , acMenuVer70 If i immediately open the recordset again and find the last record entered, the above acsaverecord does not seem to be saved. If i wait for 10 seconds or so... it seems to be ok Is...
  19. kennedymr2

    Xml Problem

    I am trying to read the values of the field <VALUE RNR="1">0</VALUE> <VALUE RNR="2">555.5</VALUE> etc I can get NR_VALUES but not sure of how to get the above into the listbox <?xml version="1.0"?> <MAIN> <MN> <NR_VALUES>18</NR_VALUES> <VALUE RNR="1">111.0</VALUE> <VALUE...
  20. kennedymr2

    HttpWebRequest in VB6

    I have some sample code as below, which i need to emulate in vb6 ----------------------- HttpWebRequest httpRequest = (HttpWebRequest)WebRequest.Create("https://xxxxxxx.xxx.com/serv/wserv.ashx"); httpRequest.Method = "POST"; httpRequest.ContentType =...

Part and Inventory Search

Back
Top