Re: Help with code to run query and test a field in the record

From: tina (nospam_at_address.com)
Date: 04/30/04 

Date: Fri, 30 Apr 2004 02:20:44 GMT

hi Van.
Kate did post the SQL, in a separate thread 3:59 pm this date, subject line:
I'm struggling with my limited knowledge of code.
i posted an answer, but maybe you'll come up with something better on
looking at it?
tina :)

"Van T. Dinh" <VanThien.Dinh@discussions.microsoft.com> wrote in message
news:%23aqTudlLEHA.1264@TK2MSFTNGP12.phx.gbl...
> 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]
> >
>
>

Relevant Pages

  • Re: Help with code to run query and test a field in the record
    ... Kate did post the SQL, in a separate thread 3:59 pm this date, subject line: ... I'm struggling with my limited knowledge of code. ... >> Dim rs As DAO.Recordset ...
    (microsoft.public.access.formscoding)
  • Re: Help with code to run query and test a field in the record
    ... Kate did post the SQL, in a separate thread 3:59 pm this date, subject line: ... I'm struggling with my limited knowledge of code. ... >> Dim rs As DAO.Recordset ...
    (microsoft.public.access.gettingstarted)
  • Re: Which identity?
    ... > Some postings I read suggested using MAXto retrieve the inserted record ... > each of these 3 SQL features? ... Another way to do it if using the .AddNew method on a Jet based ADO ... Dim rsTest As ADODB.Recordset ...
    (microsoft.public.access.queries)
  • Re: display data to user question
    ... I created a project that has an embedded SQl table with the scenario you ... Dim cn As New SqlConnection("Data ... Protected Sub Page_Load(ByVal sender As Object, ...
    (microsoft.public.dotnet.framework.aspnet)
  • Re: display data to user question
    ... I created a project that has an embedded SQl table with the scenario you ... Dim cn As New SqlConnection("Data ... Protected Sub Page_Load(ByVal sender As Object, ...
    (microsoft.public.dotnet.framework.aspnet)