Search results

  1. C

    Missing something

    I have this coding for a user form that allows them to select a date range & a status, Open or Closed. This is the coding I have but I think there is something missing. Private Sub OK_Click() ' Declare variables Dim db As DAO.Database Dim qdf As DAO.QueryDef Dim varItem As Variant...
  2. C

    The criteria of the form is not working

    I have this coding. The form the user has let's them select a date range & a status of Open or Closed. I think the codings right but no matter what date or user selects it brings up everything for whichever status was chosen. Once the code is run I look into the query & there is only 1...
  3. C

    Query issue

    Query resets blank after it is run from a form This used to work properly but am now having issues & can't figure out what changed. I have a query that gets generated when a date range is selected & a status is selected. When the report is created it only uses the search criteria of the Status...
  4. C

    Help Syntax Error missing operator in query expression

    Hi, I am getting a syntax error on a form that I am trying to make multi-select work. There is a date rage the user can choose but also if something is open or closed or both. The error is Syntax Error (missing operator) in query expression 'Vendor Hotline Log.Status = "Closed" OR Vendor...
  5. C

    HELP Compile Error Method or Data Member Not found

    Hi, I am having trouble in setting up this form. There is a table that contains all vendor calls we have gotten. On the form for data entry I have a button that when clicked another form appears so that the user can select a date range and can have select one or more selections for the "Status"...
Back
Top Bottom