Search results

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...

Hello, I have a form with quite a few controls. I may want to hide these controls based on the security level of the user. Rather than set the visible property of each control to False, I would like to cover the controls with a rectangle or some graphic so the controls won't be seen. Is this...

The suggestion by MickJav solves the problem. If I select the record and press delete the record is deleted. Thanks to everyone for their suggestions.

Hello, I am trying to make some changes to a form in an Access database application designed by someone else. I am also learning Access as I go along. The form I want to change has a subform that shows contacts for a company. The subform is populated by a query. I've noticed that I can edit...

Hello, I am trying to help a small company that is using an .mdb database in Access 2007. Their previous programmer left little documentation, unfortunately. The problem occurs when they call some routines that are intended to create a PDF file from an Access report. The routines were...

Hello, I am using Access 2007. I used VBA to print out all the properties for a form. I saw a number of formatting properties that were not listed on the Property Sheet, and I don't know how I could change them other than through VBA code. Here are the form properties that are not shown on...