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.

How about Access VBA Programming For Dummies?

This comes up every few months, but I'm asking again. What recommendations do folks have for webhosting/domain name registration? Keep in mind that a good portion of my work is done on Macs so the hosting needs to play nice with OS X and Mac based web development tools like iWeb.

On (I think it was) Evil Jimi's recommendation, last year I switched over to Host Affection. I have the "Executive Plan". $30/year, but GREAT service. They always answer my tech questions fast and well. I've rarely had any downtime, and when I have, it's been up again minutes later without any prompting from me. They're owned by Steadfast Networks who seem to be quite reliable.

I can't speak to their support of Mac development tools, but you could certainly ask them and see what they tell you.

I've been super-pleased with Dreamhost.