Recent content by cblaine99

Yes. It looks very good. Thank you.

Thank you.

t looked at the properties for the subform and the only two events shown are "On Enter" and "On Exit". I don't see "On Click".

I could not get that event to fire. Not sure why. I'll play around with it. Thanks.

Thank you. Excellent advice.

Thanks for the advice about keeping the button enabled.

I am helping a friend with his Access 2007 database. I have some basic competency with Access 2007 but am having a problem with a form. This form contains a subform which has data that came from a query. I have attached an image showing the form. I would like to do two things: - Allow user...

Thank you! I will be trying this later today. It sounds like a great solution. I assume the two new controls will be on a line right below the regular line. Is that correct? Thanks again.

My question concerns reports in Access 2007. "rptInvoice" prints an invoice and multiple line items. If a line item is for $1,000 or more, I want to print another line immediately below it which shows a credit of $50. If the line item is for less than $1,000 this additional line should not...

I apologize. You provided the information I needed. Thank you.

Perfect solution. Thank you.

Yes I did. And your approach is the one I would recommend to others. But I am simply playing in a sandbox, seeing what works and what doesn't; seeking alternative ways of accomplishing things; hacking you might say. I am not searching for an optimal soln. Thx.

Hi, Sorry for the delay in replying. Thanks for sending the sample code. It works fine. I noticed that the controls named Field1, etc. are textboxes. I was curious to see if the rectangle would also cover a command button. So I replaced Field1 with a command button. Then I ran it and...

I am experimenting and trying to find out how to cover controls so they aren't seen. It doesn't have to be a rectangle. It could be something else - an image. So far the only solution I have found is to cover the controls with a very large command button. The button has the same color as the...

The visible property of the rectangle is true, and the fill color is gray. But when I go to Form View the rectangle still appears behind the other controls. Using the Tag property is a thought. But I am simply experimenting and wanted to see if the controls could be covered up (as opposed to...