Recordset & Bound Object Frame 
Author Message
 Recordset & Bound Object Frame

Dear All,

I've got a form containing a "bound object frame", which is used in
order to select an attachment (Word, Excel file, ...).

My problem resides in the fact I don't succeed in storing the content
of this "bound object frame" in the database.  I need to do it via
source code.
My table definition is the following:

table: tbl_contentFields:
            ...
          c_object  Ole Object

The following piece of code returns the following error:
"Multiple-step OLE DB operation generated errors. Check each OLE DB
status value, if available. No work was done."
Error : -2147217887

Here is my source code:

            strSQL = "SELECT * from tbl_content WHERE " & _
                     " w_id = " & txtWich.Value & _
                     " AND h_version = " & txtVersion.Value

            On Error Resume Next
            Err = 0

            rstContent.Open strSQL, CurrentProject.Connection,
adOpenKeyset, adLockPessimistic
            If (Err <> 0) Then
                MsgBox Error$ & "(" & Format(Err) & ")"
                GoTo lbl_leaveprocedure
            End If

            If (Not rstContent.EOF()) Then
                rstContent!c_freetext = txtFreeText.Value
                rstContent!c_title = txtTitle.Value
                rstContent!c_object = oleObject                      
                    <========

                rstContent.Update
            End If

            If (Err <> 0) Then
                MsgBox "Update failure2"
            End If

            rstContent.Close

Could someone help me ?  I need to deliver the application in the next
couple of days ?

By advance, many thanks

Didier Boelens,



Tue, 14 Sep 2004 06:36:41 GMT  
 
 [ 1 post ] 

 Relevant Pages 

1. Bound Object Frame Trouble

2. Clear Bound Object Frame

3. Muti-page Word Doc in Bound Object Frame

4. Set Bound Object Frame Control Source with Function?

5. Problem with Bound OLE Object Frame

6. Controlling a digital camera from a bound object frame

7. Object Bound Frame

8. Using the MS-Access Bound Object Frame Control

9. Ms access Bound Object Frame

10. Passing variables to an ADO Command or RecordSet Object in another frame

11. Combo box bound to ADO recordset object?

12. Combo box bound to ADO Recordset object?

 

 
Powered by phpBB® Forum Software