Results 1 to 2 of 2
  1. #1
    Star Lounger
    Join Date
    Feb 2001
    Location
    South Carolina, USA
    Posts
    66
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Set Command (Access SR2)

    I am creating a recordset using the set command below in an ON format in a report:

    Set rst = mydb.OpenRecordset("combined gen med by Dept")

    In the Combined gen med by dept query, I have a parameter requesting the date. I only want to extract certain information. I am prompt and I enter in the date and then I get an error message stating too few parameters.

    Any suggestions???

    Thanks,
    Deborah

  2. #2
    Silver Lounger
    Join Date
    Jan 2001
    Location
    Indianapolis, Indiana, USA
    Posts
    1,862
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Set Command (Access SR2)

    Here's my <img src=/S/2cents.gif border=0 alt=2cents width=15 height=15>...
    A few of suggestions for you to try:
    1) You may want to use a query name without spaces. It simplifies things greatly!
    2) Although it's an optional argument, I would include the TYPE argument of the OpenRecordset method (i.e. dbOpenSnapshot or dbOpenDynaset).
    3) If those don't work, try posting the SQL of your query here. Maybe someone will be able to spot the problem from that.

    HTH <img src=/S/thumbup.gif border=0 alt=thumbup width=15 height=15>

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •