I have one field for "cancelled" (Yes/No" and then one field for Payment Owed (which if it is zero, I do not want to sent the email.

I tried changing the query to include a ="no" in the cancelled field and =NOT"0" in the PAYOWED field, , but then I recieved an error saying it was to complicated? Possibly because the VBA is telling it the class ID via the drop down menu?

I don't actually want to change the form- I just want the button that currently says "payment needed email" to only choose the people who actually need to pay?

I am not even 100% sure that this makes sense.

I should know how to do this, but for some reason I can't find the right link - Google is defaulting me to google.co.uk, and I want it set to google.com. Where do I go to tell it I'm in the US even though my IP address isn't?

[huh, it seems to have done it automatically. we'll see if it sticks for tomorrow!]

So you will never need to run the query as you currently do, without the extra criteria? And it looks like it calls two different queries depending on if you select student or class, is that right? We might need to look at the query text, and what you tried to change it to that failed.

Thanks Liese- I am not at work now so I can't get more information on the query, but yes, I will never have to run the thing I currently run. What I basically want is a button that, but clicking it, I will be able to send an email to all the students who are in current classes who have not paid, and haven't cancelled their registration. I was trying to use something that already existed ad just tweak it, but maybe it would be simpler to start from scratch. Ad make a new button with a new query for all the students in this semester who are unpaid and not cancelled.

My other solution was creating both a paid and an unpaid version of each class and move the students once they have paid, thereby being able to send emails to only the unpaid people.

No, I think your original solution should work. It`s just a matter of getting the query semantics down right, probably.

I have two scanners. A Microtek 5900, which is frankly disappointing and really hard to get good contrast with pencil drawings (which is the bulk of my scanning) but it also scans negatives, which is kinda why I bought it--but honestly, not that well either. And an HP Photosmart C6280 multifunction device which is simpler to tweak for pencil scans, but doesn't do film.

I have a buttload of film I want scanned, and I'm likely to intermittently continue to shoot film, including B&W. I also didn't buy the HP looking in particular at scanning capability--I bought it as a networked photo printer. So I don't even know how good it is.

I intend to do a lot of art scanning, primarily pencil, as well as a need to do film. Does anyone have a sense of the market out there? Is the C6280 pretty good for flatbed scanning (although it only does 8.5x11) and maybe I should be looking at a dedicated film scanner? Is there a newer combo scanner I could be looking at? Should I get a better flatbed anyway (I'm not averse to just replacing that and getting a film scanner down the road--I want one, but it's not urgent).

serial:

Okay, the Epson V600 looks perfect.

It is, from the tons of reviews I read on scanners and other high-techish office supplies two weeks ago.

Man, I really should have (had? grammar, you know) saved all these links and information for future use. I'm glad I remember some of it.

Download MacX DVD Ripper Pro for Free Today Only

Speaking of DVD ripping, does anyone know if the site DVD-ripping.biz is legit? I want to convert some Tivo stuff to DVD, and they have a free program.