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 SkipVought 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. petherin

    Columns blank when importing CSV into recordset

    I have a similar problem to the one (which wasn't resolved) in thread183-883502, which I hope someone can clear up. I am attempting to import a CSV into a table in VB: Set objConn = New ADODB.Connection objConn.ConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & sPath & _...
  2. petherin

    ROW-00014: Cannot update row as the data in the database has changed

    Hello. I am opening a recordset using ADO 2.6 in a program written in VB6 Service Pack 5 on Windows XP Professional SP2. The database I'm using is Oracle 9i. I open the recordset like this: oRSItems.Open sSQL, Globals.adoConnection, adOpenKeyset, adLockPessimistic, adCmdText This returns...
  3. petherin

    TextStream object and overflow errors

    Yes, that's it. j was DIM'ed as an Integer and j was getting up to 35,000 and was overflowing. Changed to a Long and it's okay now. Thanks very much.
  4. petherin

    TextStream object and overflow errors

    I am using the FileSystemObject's TextStream object to create and write a file. First I create the FileSystemObject and then check that some folders exist, creating them if not. Set fso = CreateObject("Scripting.FileSystemObject") If fso.FolderExists(App.Path & "\DATA") = False Then...
  5. petherin

    VB causing memory error when a Crystal Report opened

    I have a VB program which uses Crystal Reports 8.5 ActiveX Designer Design and Runtime Library (craxddrt.dll). I want to open a report using the CRAXDDRT.Application object, but a Windows system error is occurring when the OpenReport method of the CRAXDDRT.Application object is used. First, a...
  6. petherin

    CRAXDDRT.Application.OpenReport causing system error from VB

    I have a VB program which uses Crystal Reports 8.5 ActiveX Designer Design and Runtime Library (craxddrt.dll). I want to open a report using the CRAXDDRT.Application object, but a Windows system error is occurring when the OpenReport method of the CRAXDDRT.Application object is used. First, a...
  7. petherin

    Removing sections from strings in rows returned

    These procedures work fine, but what if the string contains a < or a > that isn't an HTML tag. If you had string such as: <HTML><HEAD><TITLE>This is the title</TITLE><BODY>The number 5 is < the number 6.</BODY></HEAD></HTML> Then the text you would get would be truncated like this: This is...
  8. petherin

    Distinguishing user and programmatic events

    Is there a way of distinguishing between when a user clicks on a control, and a Click (or other events like Change or whatever) that are generated when some code is executed that fires the event (such as when you change the ListIndex of a combo box and its Click event is automatically fired)? I...
  9. petherin

    Unique IDs for VB controls

    Craig Yes, I finally opted for the simpler method of just using the control itself rather than a pointer to it. Should've thought of that earlier really. Dah well.
  10. petherin

    Unique IDs for VB controls

    Where can I find info on the ObjPtr thing mentioned, I couldn't find it in MSDN?
  11. petherin

    Unique IDs for VB controls

    Yes, what I was after is something like this: The user clicks a control (any control, on any form in the project). Attached to the the code for each control would be something like: Private Sub Command1_Click() isClickCorrect (UniqueIDForControl) End Sub Then isClickCorrect would be along...
  12. petherin

    Unique IDs for VB controls

    Within a VB project, does each control (i.e. every control on every form in a project) have a unique ID, other than its full name (e.g. frmMain.cboAddressLine1 or whatever)? Something like a number that can be read so you can tell which control was clicked on from a single procedure? I don't...
  13. petherin

    Windows NT 4.0 Workstation SP6a French edition terminates VB program

    Quite a specific problem, this. I have a VB program that simulates a piece of software. The user has to perform tasks in a certain way to learn how to use the simulated software. Each control has a unique ID number. When clicked, the ID is passed to a procedure to see if the user clicked on the...

Part and Inventory Search

Back
Top