User Profile

Collapse

Profile Sidebar

Collapse
fnemo
fnemo
Last Activity: Mar 20 '12, 10:14 AM
Joined: Oct 20 '11
Location:
  •  
  • Time
  • Show
  • Source
Clear All
new posts
  • fnemo
    started a topic How to insert an attachment into a table through form in ms access 2007
    in Access

    How to insert an attachment into a table through form in ms access 2007

    hi all,
    I would like to insert an attachment object into a table using a form. I have created a table with a field type attachment. But when i am inserting data into table , error is coming.
    The error is:
    Runtime error: -2147217887
    Cannot perform this operation.

    Code:
    Private Sub cmd_add_save_Click()

Dim cmd As ADODB.Command, rs As ADODB.Recordset
Set cmd = New ADODB.Command
    ...
    See more | Go to post
    • fnemo
      replied to Error '-2146500594': Method 'Item' of object 'Forms' failed in MS Access 2007
      in Access
      The error is on the above line:
      Code:
      For Each ctl In Forms("display_result").Controls
      At this line the program searches for a specific textbox into which value is copied from the table. My guess is there is a problem with timing of commands. So i used the Doevents object but error is not resolved.
      The sequence of events which take place in the form:
      1. Create textboxes dynamically.
      ...
      See more | Go to post

        Leave a comment:

      • fnemo
        started a topic Error '-2146500594': Method 'Item' of object 'Forms' failed in MS Access 2007
        in Access

        Error '-2146500594': Method 'Item' of object 'Forms' failed in MS Access 2007

        I'm getting the error - Method 'Item' of object 'Forms' failed . Earlier this error was not occuring.

        In the below code, first textboxes are created dynamically in the form "display_result ". Design view of form is closed. Then same form is opened in normal view.

        Form is loaded. In the form load, values are passed into textboxes from global variables.Then values are passed into dynamically created textboxes...
        See more | Go to post
        • fnemo
          replied to How to insert values into a textbox in MS Access 2007
          in Access
          Thanks for the reply.
          See more | Go to post

            Leave a comment:

          • fnemo
            replied to How to insert values into a textbox in MS Access 2007
            in Access
            The below program is my code. i have indicated where problem is arising.
            Code:
            Private Sub cmd_ok_Click()

Dim intNumOfRecords As Integer
    Dim i As Integer
    Dim x As String
    
    Dim ctltext As Control
    Dim intDataX As Integer
    Dim intDataY As Integer
    
    Dim intDataHeight As Integer
    Dim intDataWidth As Integer
    Dim intDataTop As
            ...
            See more | Go to post

              Leave a comment:

            • fnemo
              started a topic How to insert values into a textbox in MS Access 2007
              in Access

              How to insert values into a textbox in MS Access 2007

              I have a problem while inserting values into textboxes. The textboxes are created dynamically. Now i would like to insert data into these textboxes and display in the form.

              In the code txtday& i & k is the dynamically created textbox. I am able to create textbox. But not able to insert data into it. The above statement is working fine.
              Code:
              Forms!result!txtday.Value = days


              But i am getting...
              See more | Go to post
              No activity results to display
              Show More
              Working...