Search results

  1. capogna1

    Parameter query

    Hi everyone! So my query looks up between dates, I enter "Start date" and "End date" and this works. I would like those 2 dates to come up on my report that look at this query. I might be real simple to do but been trying and can't get it. Thanks in advance!!!
  2. capogna1

    Filter on a form

    HI I created combo boxes on my form to select what I want to filter and I used the following: Sub RequeryForm() Dim strSQL As String strSQL = "" If Len("" & Me!cboTypeOfEncounter) > 0 Then strSQL = "[Type Of Encounter] = '" & Me!cboTypeOfEncounter & "'" End If If Len("" & Me!cboReviewer)...
  3. capogna1

    Clear Fields

    Good morning! I have this code to personalize my error message pertaining duplicate record: Private Sub Form_Error(DataErr As Integer, Response As Integer) Const ERR_DUPLICATE_INDEX_VALUE = 3022 Dim strMsg As String If DataErr = ERR_DUPLICATE_INDEX_VALUE Then strMsg =...
  4. capogna1

    Day count

    Hi everyone! I have a field in a form that calculates Days Old and it's in Control source: =DateDiff("d",[Discharge_Date],Date()) I need an easy way to stop this when the task is completed so it stops counting the days. A completed button or checkbox anything that will work. Thanks in advance...
  5. capogna1

    Count function

    GM EVERYONE I NEED TO COUNT NUMBER OF DATA ENTRIES BY USER, AND BY DATE, ANYONE CAN HELP?
  6. capogna1

    Query

    Hi everyone, I have a field with social security numbers, data was imported so some came in with dashes some without. Tried to change format to the field to get rid of dashes but didn't work. Now when I search by SSN I have to try with dashes and without. How do I tell Access bring be back...
Top Bottom