Search results

  1. N

    Mail Merge to Word

    So i've got some nice buttons that when clicked take the results of qry_certissued and drop them into the appropriate word document, GroupRecord.doc works fine, because it's just a table, and each new row has a <<next record>> at the start so Word knows to take the next record from Access and...
  2. N

    Part of filename from query

    at the moment, the OnClick event procedure for a button is Private Sub btn_certificate_Click() Application.FollowHyperlink "C:\<filepath>\FAWR Certificate.doc" End SubThere are three different certificate files, EA Certificate, FAW Certificate and FAWR Certificate What I would like is for the...
  3. N

    "Or" in criteria field?

    I have a combo box with three options, "EA" "FAW" and "FAWR" If "EA" is selected i want the query to return results where certtype="EA", if "FAW" is selected i want the query to return results where certtype="FAW" if "FAWR" is selected i want the query to return results where certtype="FAW" or...
  4. N

    Nested IIf( with DMax and DateAdd not working correctly

    [SOLVED] Nested IIf( with DMax and DateAdd not working correctly As the control source of txt_expdate I have the following =IIf(([txt_coursedate]>DMax("certexpires","qry_personcert")), DateAdd("m",36,[txt_coursedate]), IIf(([txt_coursedate] Between DMax("certexpires","qry_personcert") And...
Back
Top Bottom