Report for missing entries

  • Thread starter Continental Translations
  • Start date
C

Continental Translations

Is there anyway I can create a report which outlines entries which are
missing information. For example, I have a form called 'Contacts' and i'd
like a report to be created, with the persons name and surname and email
address (taken from the contacts form) and then it outlines which fields
have no information in for that specific person.

Does that make sense?

Also, if you have an email address in a Contact Form, is there anyway you
can pop a little box next to it saying 'send an email' and when you click on
the box, MS Outlook opens ready to send an email to that person?
 
S

Steve Schapel

Continental,

You could use Conditional Formatting of the controls on your report, to
change the background colour in the case of Null, but not outline. If
you wanted ouline, you could put a procedure on the On Format event of
the report section, with code something like this...
If IsNull(Me.Surname) Then
Me.Surname.BorderStyle = 1
Else
Me.Surname.BorderStyle = 0
End If

As regards the email, try something like this on the Click event of the
command button
DoCmd.SendObject acSendNoObject, , , Me.EmailAddress, , , , , True
 
Top