Yes, thank you.

Gar, I found a couple of things that might be useful:

FrontPage solution: [link]
A "software tool": [link]

Flea, insent.

Thanks Tommy. I have been in meetings all day but that sounds like it will work, and I will ask you about printing a report tied to those results as soon as I see if I can do this!

Thanks again- I did get that to work, rather nicely.

No thoughts on the jerky video issue?

I'm further mystified that youtube works a treat...but not the episode viewers. Plus, I can't seem to get quicktime to 'stick'. I load it, but after a few uses, especially if I accidently click on something hd...the system tells me the app is not installed.

This is all a memory thing, isn't it. After I upgraded not more than a few months ago! Blergh.

I have another Access question.

Is there any way to print each page of a report to a separate .pdf with the student's last name and the name of the report as the title. I email each student their account statement in pdf. The way I am doing it is to print it as one big pdf, splitting the .pdf into separate files, and then renaming the files so they correspond with the student's name. This is OK with one or two students, but I got a little behind, and I am billing 31 right now.

You can print the individual pages of the report to pdf by entering the page number to be printed in the print dialogue. You could probably set up a macro that would do that for you automatically.

Another way would be to force the query that the report is based on to only print the student's report that you want by including a statement like "[Enter the student number]" as a criteria for the applicable field. When you open the report, it'll ask you that question and give you an entry box to input the student number. Then it will present only that student's report, which you can pdf.

The easiest way would be to do it with VB code. Easiest to run, that is (it could be run with just one click). But it would just be a few lines of VB code, which I could post for you.

eta: Otherwise, DX's ideas are good.

Do you restrict the report to certain student numbers, and if so, how?

THanks DX and tommy.

To answer your questions, I restrict the report to a certain date (the date I deposit their money). So once I week I post the payments and run all the reciepts for payments posted on that day. Today it was 31 of them.

In the query, in the deposit date field, there is an "Enter Deposit Date " criteria. I can also print individual reciepts if needed with a copy of the same query with the "Enter Student ID" restriction, but the way my job works, I am only "allowed" to run credit cards once a week, and I don't like to give a reciept until I have an approval code, so I tend to have large batches of reciepts to pdf all at once. Also, once a month I need to run a statement for everyone, and have them in individual pdf's (hopefully with their name in the title, because I then have to attach them to emails) and match them up correctly. I am sure, actually that there is probably a way to code it so that it also sends the email, but I am pretty sure that is above my head.

Also-- how would one go about learning Visual Basic, because I am pretty sure this would be a lot easer if I know even the simplest piece of it.