Re: Too few parameters expected 3

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

From: PC Datasheet (spam_at_nospam.spam)
Date: 05/07/04 

Date: Fri, 07 May 2004 23:18:00 GMT

QueryAv has three fields with criteria. 

--
                                         PC Datasheet
Your Resource For Help With Access, Excel And Word Applications
                              resource@pcdatasheet.com
                                 www.pcdatasheet.com
<anonymous@discussions.microsoft.com> wrote in message
news:a14601c43483$f7412ba0$a501280a@phx.gbl...
> I get the above message when running the following code.
> What is the problem?
>
>  Dim MyDb As Database, MySet As Recordset
>  Set MyDb = CurrentDb
>  Set MySet = MyDb.OpenRecordset("QueryAv")
>  MySet.Edit
>  MySet![Booking ID] = lngNext
>  MySet.Update
>  MySet.Close
>  Set MySet = Nothing
>
> Thanks in advance.

Relevant Pages

  • Re: Too few parameters expected 3
    ... Your Resource For Help With Access, Excel And Word Applications ... > Dim MyDb As Database, ... > Set MySet = MyDb.OpenRecordset ...
    (microsoft.public.access.queries)
  • Re: Reducing the List items on a combo
    ... Dim Mydb As Database ... Dim MySet As Recordset ... Set MySet = Mydb.OpenRecordset ... Do Until!MaterialID = CLng ...
    (comp.databases.ms-access)
  • Too few parameters expected 3
    ... Dim MyDb As Database, MySet As Recordset ... Set MyDb = CurrentDb ... Set MySet = MyDb.OpenRecordset ...
    (microsoft.public.access.gettingstarted)
  • Too few parameters expected 3
    ... Dim MyDb As Database, MySet As Recordset ... Set MyDb = CurrentDb ... Set MySet = MyDb.OpenRecordset ...
    (microsoft.public.access.queries)