printing dates from records

  • Thread starter Thread starter Lisa
  • Start date Start date
L

Lisa

I am trying to make an attendance sheet coordinate with my
medi-cal billing. (I'm a speech therapist). I made an
attendence grid in excel from Access mdb. with dates named
across the top, students names on the first column and a
column for indicating if they receive medi-cal or not. I
want to print a page for each student that receives medi-
cal with the dates of attendance for the month. (one
student per page) Can I do it? I've tried everything.

Also, can I use an Access form to print directly into my
speech reports in Word or can I only do it by going
through the mailmerge. Such a silly way to do it...

I'm trying to simplify my life, but it sure isn't
working...HELP!
 
Lisa said:
I am trying to make an attendance sheet coordinate with my
medi-cal billing. (I'm a speech therapist). I made an
attendence grid in excel from Access mdb. with dates named
across the top, students names on the first column and a
column for indicating if they receive medi-cal or not. I
want to print a page for each student that receives medi-
cal with the dates of attendance for the month. (one
student per page) Can I do it? I've tried everything.

Also, can I use an Access form to print directly into my
speech reports in Word or can I only do it by going
through the mailmerge. Such a silly way to do it...

I'm trying to simplify my life, but it sure isn't
working...HELP!
Click to expand...

You can print your reports directly from Access if you like. I would hope
that your attendance table has only 2 columns:

StudentID
TherapyDate

The student's name and insurance information need to be in a Students table.

A MailMerge in Word is useful for printing multiple records at one time,
where you won't be changing anything from a template. If you really need to
print them 1 at a time, making formatting changes in Word for each 1, use
Word Bookmarks and code similar to what I've written for merge letters at:

http://www.datastrat.com/Code/WordMerge.txt
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access downloads:
http://www.datastrat.com
http://www.mvps.org/access
 
Back
Top