emailing a report of a single record

  • Thread starter Thread starter Toph
  • Start date Start date
T

Toph

I am new to all this, but I am trying to email a report
of a single record. After interviewing a student I record
details of the interview and foolowup in an Access (2000)
database. I now want to be able to email a report of the
record to their homeroom teacher.

So far I have found out how to modify the sample
Northwind database (included with Access) so that it
prints a report of a single record. I got the directions
off the web at:

http://support.microsoft.com/default.aspx?scid=KB;EN-
US;q209560

The problem is that I do not know how to use this to
modify my own database so that it will do the same. When
I try it (with the few changes that seem necessary), I
get a Data Mismatch Error.

Can anyone give me some direction on this?

Thanks in advance.

ps. Sorry for posting to two lists, but I am now not able
to read the General list to see if there was a response.
 
There are a number of ways to do this depending on how
fancy you want to get. I will make some assumptions here.
You are viewing the record on a form. Create your report
off a query with the criteria for your Record ID coming
from the form.
ex
Forms![formname]![record ID]

Create a macro and use the sendobject command referencing
that report.
Add a button to the form running that macro

Jim
 
Back
Top