Search results for query: *

No. Should I? Randy [afro]

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]

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"...

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

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

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

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

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

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

Gotcha! Thanks for the reply. Randy [afro]

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

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]

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]

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

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]

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

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

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

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

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)...