Search results

  1. S

    Using a form to select data from a query using SQL

    ok i entered the code you posted, changing the details where applicable. i get the following error: syntax error (missing operator) in query expression tblDetails.Run Date='13' AND tblDetails.Database Name='SP341' AND tblDetails.Release='3.4.2' any ideas?
  2. S

    Using a form to select data from a query using SQL

    ok i think im just being completely stupid now. how do i need to change my strSQL to make it work in a query in SQL view? cheers again
  3. S

    Using a form to select data from a query using SQL

    thanks colby, i no longer get the mismatch error, i just put some numbers in instead of the date and it seems to work. thanks again My main problem now is the fact that it errors when it reaches a certain line in teh code: qdf.SQL = strSQL The error i get is: compile error method or data...
  4. S

    Using a form to select data from a query using SQL

    Ahh, i can see where youre coming from here, however in design view the the run date is actually a text field. The default value is merely set to =date() Would this cause a problem? cheers for your input
  5. S

    Using a form to select data from a query using SQL

    I am trying to use a form to select certain criteria and amend a query depending on those selections. The form is shown when my access database first starts up and i have 3 criteria: Date Database Release These are then used to query a table and amend the query appropriately. Using various...
View older results
Back
Top Bottom