Replies

Thanks John…back to the drawing board

Hi John,

Thanks for the assist. I am still getting the same error message with the SetFocus fix as well. I have included a screenshot of the error message I am getting.28347-2108-Access-Error

Thank you so much for your help Andrew, you saved me many hours of aggravation & frustration.

Thank you Hans, as always your help is much appreciated!

I am running Office 2007 on Vista and when you press the ALT key you get options to perform other functions (See attached screen shot). I would like my macro to run thes options that are activated by the ALT key.

The Amount criteria should filter any records that do not have a payment at all (there are no matching records in the Payment table for that claim) or if the payment amount is 0.
So to revise my original statement…Amount: Is Not Null or =0

Yes, the client should have 2 different claims that meet each of the criteria sets.

Thank you Hans & John,

I decided to utilize the toggle button option and it is working great. I appreciate your help

Thank you Hans. I will try this out and see how it works.

Your solution worked like a charm. As always your help is invaluable…many thanks

the recordset of my report has multiple tables with the field ClinicReconciled displayed in the header of the unique ID of the clinic.

Since, I open this report from a switchboard how can I update the field’s value. I only want to update the value of ClinicReconciled of the current record.

Thanks for the advice. The model number is MX8710.

When I try to boot from the CD I get the following message:
Setup did not find any hard disk drives installed on your computer.
Make sure any hard drives are powered on and properly connected to your computer, and that any disk related hardware configuration is correct. This may involve running a manufacturer supplied diagnostic or setup program. Setup cannot continue. To quit Setup, press F3.

Thanks you Jeremy…you have saved me many hours of keystrokes!!!