Recent content by andrewboast

  1. A

    SQL Syntax Date format English v American

    Thanks jdraw, cannot believe I have not come across this issue before. The link cleared the issue for me.
  2. A

    SQL Syntax Date format English v American

    I am trying to query a set of records on a date field via code using memory variables as below: dtFrom = Format(dtFrom, "dd/mm/yy") dtTo = Format(dtTo , "dd/mm/yy") ' I have also tried using CDate in both cases the set of records return a selection that is equivalent to the dates being...
  3. A

    Parameter qry Error (3061) Parametr is TextBox on a form

    One other thing I forgot to mention, if I have the form open and then manually run the query it works?
  4. A

    Parameter qry Error (3061) Parametr is TextBox on a form

    Hi JHB It is run from code using Set rstProd = dbOUT.OpenRecordset("qry_Offers_Out_Products") Regards Andrew
  5. A

    Parameter qry Error (3061) Parametr is TextBox on a form

    Hi Just wondered if anyone could shed some light on the issue I am having. I have a saved parameter query that will not run when I point the parameter to a TextBox on a form. The error is 3061 "Too few parameters. Expected 1." It is a number, if I enter the number directly in the sql then...
See more
Top Bottom