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: *

  1. garths2

    Expression column in datagridview

    Since it has been a while since you posted this question I don't know if you already figured it out. I ran your code as is and it concatenated the column values; I am guessing that is the same issue you had. Just change the data type of the columns right after you add them to the data table...
  2. garths2

    SaveAs method vbcode

    nick, This should get you the rest of the way. Use the "mkdir" method to create the folder. Here is an example: folderName = "c:\bob" mkdir(folderName) -GS
  3. garths2

    SaveAs method vbcode

    I didn't do any error checking or cleanup but here is what I think you are after. ' begin code Dim oFolderSource As Outlook.MAPIFolder Dim oFolder As Outlook.MAPIFolder Dim oMsgItem As Outlook.MailItem Dim NewFileName As String Set onsMapi = Application.GetNamespace("MAPI")...
  4. garths2

    VB6 & Excel with different versions of OS and Excel

    I don't think I would attempt to install two versions of the Excel object, they will probably interfere with each other. Could you instead install VB on the XP Home machine with Excel 2000, reference the Excel 9.0 object and re-compile it. -GS
  5. garths2

    VB6 & Excel with different versions of OS and Excel

    I am assuming you are referencing the Microsoft Excel object in your VB project. I would try using the lower version of the object to see if it is compatible with both Excel versions. Just a thought, GS
  6. garths2

    TransferDatabase Erorr 3011 when late binding

    RobS23, Since you are using late binding and you are no longer referencing the Access object you need to declare "acExportDelim" or just substitute its name with its value, as in: apAccess.DoCmd.TransferText 2, , "exp", "C:\myfile.txt", True Hope that helps, -GS
  7. garths2

    MSChart - 2 graphs on one chart

    Check to see if the "SeriesColumn" setting in the MSChart control properties is set to column 1. If it is, try setting it to column 2. -GS
  8. garths2

    Activex or code for financial calculation ?

    Here is another link where they post code for a yield function (towards the bottom of the post) http://www.experts-exchange.com/Programming/Programming_Languages/Visual_Basic/Q_20385382.html -GS
  9. garths2

    Activex or code for financial calculation ?

    tdong, Not sure what functions you are looking for but here is a good link. http://home.comcast.net/~rthamper/html/financialfunctions.htm -GS
  10. garths2

    SaveAs method vbcode

    For clarification: In the code I posted above "writePath" in the "Open" statement is a string that is meant to hold the path of the file to be stored. -GS
  11. garths2

    SaveAs method vbcode

    aspag, Strings do not have a "saveAsFile" method, that would be my guess why you are getting a compile error. The code below would save the string to a text file. The code would go where the "MsgBox StrReport" line is. ' start code Dim fileNumber As Integer fileNumber = FreeFile...
  12. garths2

    DataReport Designer - Using Parameters

    see thread709-88923 It's a long post so do a search for RowSet on that page. There was never a reply to the fix so I don't know if it fixed the problem but I thought I would point you to it anyway since I could not reproduce your problem in my environment. Hope it helps. -GS
  13. garths2

    Refresh a GUI

    You can set the form to be on top by using the win32 API function "SetWindowPos" as in: Private Declare Function SetWindowPos Lib "user32" (ByVal hwnd As Long, ByVal hWndInsertAfter As Long, ByVal x As Long, ByVal y As Long, ByVal cx As Long, ByVal cy As Long, ByVal wFlags As Long) As Long...
  14. garths2

    Copy Db Image from one table to another

    Here is how I would do it. I would use two recordsets. You also need to use labels when referencing fields because the order is not predictable when using "SELECT *" ' begin code Dim fnum As Integer Dim bytesLeft As Long Dim bytes As Long Dim tmp() As Byte Dim readRS As...
  15. garths2

    Module question

    Shannan, There is a book, "Upgrading Microsoft Visual Basic 6 to Microsoft Visual Basic .NET" that is very usefull when migrating a project. It contains a solution to the Forms Collection class you are using. -GS
  16. garths2

    Module question

    Shannan, Have you tried using "Visual Basic 6.0 Code Advisor"? You can download it from: http://msdn.microsoft.com/vbasic/downloads/codeadvisor/default.aspx It is a plug in for VB6 that comments most of the problem areas in your code. It then steps you through the comments allowing you to...
  17. garths2

    Datagrid - can't REFRESH!!!!

    Hi LiLgUrL, The reason the following code does not work is that you can not delete records while opening a recordset. .Open "DELETE * FROM Temp_Table", conn, adOpenForwardOnly, adLockPessimistic You could however do what you want with the connection object you are using: conn.Execute...
  18. garths2

    Flexgrid to Table - Compare contents

    LiLgUrL, Good catch! I didn't even notice you were trying to update the primary key. When I set up an example I didn't use a primary key so I didn't get an error. Glad you found it. -GS
  19. garths2

    Flexgrid to Table - Compare contents

    LiLgUrL, Here's the way I would do it: ' start code Set rs = New ADODB.Recordset With rs .Open "Select * from tblPartNumber", conn, adOpenDynamic, adLockPessimistic For i = 1 To flgPartNum.Rows - 2 rs.Find "PartNumber = '" & flgPartNum.TextMatrix(i, 0) & "'" If rs.EOF Then...
  20. garths2

    Opening an Access Database from VB

    Lisette, You may try moving the Dim statement to the beginning of your Form source code, because it looks like you still want Access open after the button has been pressed. Right now you have objAccess local to the scope of the subroutine. VB may be destroying the object after the subroutine...

Part and Inventory Search

Back
Top