User Profile

Collapse

Profile Sidebar

Collapse
Gazerdood
Gazerdood
Last Activity: Apr 29 '10, 10:17 PM
Joined: Apr 14 '10
Location:
  •  
  • Time
  • Show
  • Source
Clear All
new posts
  • Gazerdood
    replied to Object variable or With block variable not set
    in Visual Basic
    How do I do that?
    See more | Go to post

      Leave a comment:

    • Gazerdood
      started a topic Object variable or With block variable not set
      in Visual Basic

      Object variable or With block variable not set

      Hi when I click the command button to run this piece of code:

      Code:
      Private Sub recoverpass_cmd_Click()
Dim c As String
Dim b As String
Dim foundflag  As Integer
Adodc2.Recordset.MoveFirst
Do
b = Adodc2.Recordset.Fields!Username
c = Adodc2.Recordset.Fields!Security
      Error in line 5: 'Adodc2.Records et.MoveFirst2'

      Run-time error '91':
      Object variable or With      ...
      See more | Go to post
      • Gazerdood
        replied to Opening MS Word document from a database in VB6
        in Visual Basic
        I still cannot get an understanding i'm afraid so what I have done is include a screenshot of my form and a screenshot of my access table.

        I would like to know how to link it to the access table so the code you provided can work? (I have to use an access table)

        Thanks!...
        See more | Go to post

          Leave a comment:

        • Gazerdood
          replied to Opening MS Word document from a database in VB6
          in Visual Basic
          Hi Pat thanks for the reply thats fantastic. I am still rather baffled though so I hope you can answer my questions.

          What I have done: Created table with the defined fields, added the text box, command button and list box to the form with the appropriate names and dropped the code on that form.

          1. Okay I have created a table in Access with the fields you said but I dont see how in the code that this is linked to from vb?...
          See more | Go to post

            Leave a comment:

          • Gazerdood
            replied to Opening MS Word document from a database in VB6
            in Visual Basic
            Hello, thanks for the reply.

            Yes that is what I am wanting my fields will be something like 'file name', 'type' and 'path' maybe unless you can determine anything better.

            Heres what I want to be able to do:

            1. Search query in textbox on VB6 form and click search button.
            2. This will search in the 'type' field of the table.
            3. Display the found files in a datagrid or whatever other object...
            See more | Go to post

              Leave a comment:

            • Gazerdood
              started a topic Opening MS Word document from a database in VB6
              in Visual Basic

              Opening MS Word document from a database in VB6

              I want to have an access database table which links to various MS Word documents.

              These will be displayed in a VB6 form via an Adodc.

              I want to be able search the database within the VB form and then click on the one I want to open the document.

              Is this possible and if so what coding is required and where?
              See more | Go to post
              No activity results to display
              Show More
              Working...