Recent content by Falcone203

  1. F

    Multiple WHERE clauses in docmd.openform

    Dim st1 As Integer Dim st2 As Integer If (IsNull(Me![Sub Item])) = False Then st1 = Me![Sub ID] st2 = Me![IID] If (IsNull([st1])) Then 'Do Nothing Else DoCmd.OpenForm "43 FIRE DEPT subform2", acNormal, , "[43 fire dept].id = " & st1 & "And [tblfae].FAIDFK = " & st2 End If End If
  2. F

    How to Print a Blank Form

    FFAN is an auto number, 168 is a blank record. Private Sub cmdPrtApplication_Click() Dim FF As Integer MsgBox Nz(Forms!frmffaddinfo!FFAN, "168") FF = Nz(Forms!frmffaddinfo!FFAN, 168) DoCmd.OpenReport "rptNMPKG", acViewPreview, , "[FFAN]=" & FF ' or have it go to a new record with an "IF"...
  3. F

    creating database

    How did you do with your DB?
  4. F

    So I created a database

    Where did I lose you, sorry
  5. F

    So I created a database

    I incorporated both, multivalue and subtable. when you select "Edit" and choose a run, you can select or deselect "mutual aid", "apparatus" and "responders". then the related table is also update.
  6. F

    So I created a database

    If you create the "user folder", the program should still connect to google sheets and load current input of runs. It is still live.
  7. F

    So I created a database

    I will apply these changes and suggestion to a duplicated do and see how it runs. First I need some down time from my paying job. Curious, are my newly loaded runs in sheets showing up?
  8. F

    So I created a database

    So starting here, I would create a "subreport"?
  9. F

    So I created a database

    Seems the school of hard knocks wins. This is saying I will have training records to no firefighter?
  10. F

    So I created a database

    Yes, I believe I have done that in one of my roster reports. It show available unit numbers that can be assigned to new personnel. This is a subreport So you could do the same with responders in a "clean report" as I am calling it
  11. F

    So I created a database

    rptRuns and frmsRuns rptRuns, which is the same as frmRuns for editing, frmruns I use to add/remove mutual aid, apparatus and/or responders
  12. F

    So I created a database

    Well, in my mess of messes, I believe I am doing both. MVF and " individual child records in the child table of a parent/child, one-to-many relationship"
  13. F

    So I created a database

    The data comes from google forms
Top Bottom