User Profile

Collapse

Profile Sidebar

Collapse
cbxsims
cbxsims
Last Activity: Nov 29 '06, 08:31 PM
Joined: Nov 22 '06
Location:
  •  
  • Time
  • Show
  • Source
Clear All
new posts
  • cbxsims
    replied to Access to Micosoft SQL - run time error 91
    in Visual Basic
    It doesn't like this line,

    Set qdf = db.QueryDefs("S tored1")

    I get the errror run time error 91

    Object variable or with block not set


    Thanks for your responses.
    See more | Go to post

      Leave a comment:

    • cbxsims
      started a topic Access to Micosoft SQL - run time error 91
      in Visual Basic

      Access to Micosoft SQL - run time error 91

      Hi,

      I recently upsized my access database to ms-sql backend but some of my vb code is not working anymore. Please help. Here is my code. It was for a simple form with combo box's to run a query.

      Option Compare Database
      Option Explicit

      Private Sub Command5_Click( )
      Dim db As DAO.Database
      Dim qdf As DAO.QueryDef
      Dim strSQL As String
      Set db = CurrentDb
      Set qdf = db.QueryDefs("S tored1")...
      See more | Go to post
      No activity results to display
      Show More
      Working...