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: Elysium
  • Order by date
  1. Elysium

    DataSet Loop Question

    No. Should I? Randy [afro]
  2. Elysium

    DataSet Loop Question

    dtSource.Rows.Count = 24 CINT(dr("Quantity")) is returning the correct values No other errors are coming back. However, the destination table still is empty. Any other suggestions? Randy [afro]
  3. Elysium

    DataSet Loop Question

    I'm still having trouble with this. Zero rows are being inserted into the table "keyedImportSource". I'll post the code here: Public Function createWorldShipSource() As Boolean Dim oDBO As New clsDB_Operations Dim da As New OleDbDataAdapter("SELECT * FROM keyedImportSource"...
  4. Elysium

    DataSet Loop Question

    Rick, Thanks for the patience. In order to open a datatable, I have to create a dataadapter, correct? Randy [afro]
  5. Elysium

    DataSet Loop Question

    Is there a bulk insert or do I import one row at a time via a loop? Randy [afro]
  6. Elysium

    DataSet Loop Question

    Excellent. Now how do I save the contents of the new table just created to a table in MS Access called "keyedImportSource"? Randy [afro]
  7. Elysium

    DataSet Loop Question

    Rick, Could you explain what's happening in the For Loop? Randy [afro]
  8. Elysium

    DataSet Loop Question

    I'm not sure how to accomplish the following, so any help is much appreciated: I have a table in MS Access that holds information about orders. What I want to do is loop through each record in the orders table, reading the value for the Quantity field. Then I'd like to add the current row of...
  9. Elysium

    SQL Server Express Conversion Problem

    I apologize if this is the wrong forum for my question. In any case, I just downloaded SQL Server 2005 Express and I have an issue with a CSV import. I established a "Linked Server" to a directory where my csv files are. I then issue Insert statements using the csv files in the "from" syntax...
  10. Elysium

    Target Machine Lacks MS Access

    Gotcha! Thanks for the reply. Randy [afro]
  11. Elysium

    Target Machine Lacks MS Access

    The Package Deployment wizard do this for me, right? Randy [afro]
  12. Elysium

    Target Machine Lacks MS Access

    Just a quick question. If I develop an app (VB.Net) that uses an MDB to hold data, does the target machine have to have MS Access installed? Randy [afro]
  13. Elysium

    Exception Handling

    Sheco, There's something missing maybe. I structured my code to match your example, and the error notification stops at the property's Catch statement. It won't flow back into the frmMain. In other words, it's not bubbling back up. Randy [afro]
  14. Elysium

    Exception Handling

    Am I right in using this structure?: ************************* frmMain ************************* Private Function fillDeliveryFields() As Boolean Dim oDBO As New clsDB_Ops With oDBO Debug.Print Err.Number If Err.Number <> 0 Then Err.Raise Err.Number...
  15. Elysium

    Exception Handling

    Thanks, but I'm using VB6. Unless it can use structured exception handling, I'm relegated to unstructured exception handling. All of the examples that I can find on Google are very basic and don't show how to bubble an error up to a form that happened in a class two levels down. Randy [afro]
  16. Elysium

    Exception Handling

    Development Platform: Visual Basic 6 If someone knows of a FAQ that will answer my question, please post it. I didn't find one elaborate enough to do so. Okay, here's what's happening. User types in a PO Number into a field, and on the Lost Focus event, a function in the form attempts to...
  17. Elysium

    Passing variable data to XML

    The task: I want to read in an XML file that contains instructions to format a label. No problem here, but where I'm stuck is making the XML file dynamic. If I have 10 labels to print, each with a different recipient, how do I structure the XML to know that the 'varRecipient' value in my VB...
    • Elysium
    • Thread
    • Replies: 1
    • Forum: XML
  18. Elysium

    Raise Event in Form A, respond in Form B

    I would use "Handles" in VB6? Randy [afro]
  19. Elysium

    Raise Event in Form A, respond in Form B

    Thanks for the insight. I have it working as it should now. Randy [afro]
  20. Elysium

    Raise Event in Form A, respond in Form B

    I have two forms that I need to communicate between. The first form (Form A) will take several entries into a listbox. After each entry into the listbox, I need to raise an event that will tell Form B how many entries have been added currently. Here's what I have so far (it doesn't work)...

Part and Inventory Search

Back
Top