Results 1 to 3 of 3
  1. #1
    Join Date
    Dec 2011

    Unanswered: Generating custom email forms for missing data

    I have a rather complex idea (I think) that I am working on and am looking for some input to help get started.

    I would like to create the following scenario

    I would like to run a query based on some limiting criteria such as who entered the data, the date entered, and status. This I can manage.

    Then I want to identify each record with missing data. The missing data is not uniform. One record may be missing variable 1,2, and 3 while another record may be missing variable 2 and 4.

    Next, for each record I want to generate an email and send it to the person who entered the data. However, I only want to send one record in an email and only include the empty fields. This would reoccur for each record with a missing field to generate a single email for each record with missing data while not sending an email for any complete records.

    My goal is to have simplified process for other users to focus on updating missing data. I would appreciate any suggestions regarding setting this up, better ideas, etc.


  2. #2
    Join Date
    May 2005
    Nevada, USA
    Provided Answers: 6
    Shouldn't be too difficult. Basically in VBA code you'd open a recordset on the query and loop through the records. For each record build a string containing the missing fields in your desired format. Depending on your setup, that might be accomplished with a loop or simply testing each field in turn. Once your string is built, you'd include it in your email. You'd either exclude complete records in the query itself, or not send an email if no fields were missing.

  3. #3
    Join Date
    Apr 2011
    And once that's done, revisit your database design to force use to fill in mandatory fields.

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts