Re: Help with code to run query and test a field in the record
From: Van T. Dinh (VanThien.Dinh_at_discussions.microsoft.com)
Date: 04/30/04
- Next message: gene: "Re: Help!! Problem with query"
- Previous message: Duane Hookom: "Re: Help!! Problem with query"
- In reply to: Kate: "Help with code to run query and test a field in the record"
- Next in thread: tina: "Re: Help with code to run query and test a field in the record"
- Reply: tina: "Re: Help with code to run query and test a field in the record"
- Messages sorted by: [ date ] [ thread ]
Date: Fri, 30 Apr 2004 12:07:02 +1000
Post the SQL String of your QueryAv.
Do you use Parameters in this Query?
If you do, you need to resolve the Parameters before passing to JET for
processing.
--
HTH
Van T. Dinh
MVP (Access)
"Kate" <anonymous@discussions.microsoft.com> wrote in message
news:61d301c42e37$2268f7c0$a401280a@phx.gbl...
> Tried the following and get the message too few parameters
> expected 3. The following statement gets highlighted:
>
> Set rs = db.OpenRecordset("QueryAv")
>
> Any idea? Thanks
>
>
> Dim db As DAO.Database
> Dim rs As DAO.Recordset
>
> Set db = CurrentDb()
> Set rs = db.OpenRecordset("QueryAv")
>
> If rs![Booking ID] = 1 Then
> DoCmd.OpenForm "SINGLE BOOKING DETAIL"
> End If
>
> rs.Close : Set rs = Nothing
> Set db = Nothing
>
>
> >MVP [MS Access]
>
- Next message: gene: "Re: Help!! Problem with query"
- Previous message: Duane Hookom: "Re: Help!! Problem with query"
- In reply to: Kate: "Help with code to run query and test a field in the record"
- Next in thread: tina: "Re: Help with code to run query and test a field in the record"
- Reply: tina: "Re: Help with code to run query and test a field in the record"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
|
