Recent content by dr.bob

I am able to open the database just fine. But if the network guy tries to open it on his computer he gets an error. (and the calendar will not show up) The error attached. Thanks, Dr. Bob

I am working on a database to help me compare MPG between using different brands and octane ratings. How do i cause each record to calculate MPG? The database would have to calculate odometer differences from the last odometer reading and divide number of gallons bought.:confused: I hope this...

I have about 15 yes/no check boxes on a form. Is there a way to create another check box that when checked, it will place a check mark in all the other 15 boxes? Thanks in advance, Dr. Bob

Thanks Thanks foro the tip. It worked great. Dr. Bob

In using the Calendar object in a form I am wanting to be able to click on a date in the calendar and have this date be put in a text or date field. Is this possible? Thanks in advance, Dr. Bob

elaborate please Your idea is probably a good one. But I do not have a clue how to perform it. Thanks for your help. dr. Bob

YES/No Box in reports Conditional Formatting is not an option with the YES/NO box in design view (In Reports) .Conditional Formatting is grayed out. Not Selectable. Thanks, dr.Bob

You are right Yes. Sorry for the confusion. They do the check marks in the Form. dr.bob

YES/NO field The field is a YES/NO field. The report comes from my query which is generated from my table. The yes/no fields are set that way in the table. In the report,the user will check the box for Yes and leave it blank if it is NO. Not concerned about the color in the Query, or the form...

Conditional formatting Don't think I have done this in Access. In Excel it is no problem. Bob

Is there a way to make a NO box to be red and a Yes box to have a check mark?(by default it is a check mark) I'm getting this report from a querie and am using a date parameter as well. There are about 14 YES/No fields. Sometime some will be Yes and sometime they will be NO. I need a way to spot...