Recent content by rgates

Thank you very much. I created a select query and made that the source of my form. It works every time now. I appreciate the help very much. I am greatful that you took the time to answer my little inquiry. I learned much more than you know. R. Gates

I'll see if I can figure out how to do that. That's what you get for teaching yourself! Thank you.

I'll try to be more precise I have a form (FormA) that is used to enter data in a table (table1). I wrote two make-table queries (query x and query y) that divide that data and places it in two other tables. (table2 and table3) I created a form (FormB) that just reads and displays the data...

Please help. I am not new to Access, but I haven't done much with some parts of it. I have a table and ran a query on that table. I have a form that displays data from the query. How can I make the query run when the form is opened so the data is current. Data entry happens at the table...

Thank you, thank you, thank you! Finally! I used the IIf function, but I put it in the Control Source of a text box. = IIf([Units of Service 2 September] =0, " ", [Units of Service 2 September]) One problem I was having was that you had true and false switched, so I got the opposite of what I...

I keep getting an error Private Sub Report_Open(Cancel As Integer) Me.[Units of Service 2 September].Visible = IIf(Me.[Units of Service 2 September] = "0", False, True) End Sub I get a compile error - method or data member not found and it highlights .Visible =

I did search to find the answer to this question, but each question was slightly different from mine. I want to hide a text box in a report if the value is 0. I don't know enough code to know what mistakes I am making. I tried this : Me.[MyTextBox].Visible=Not IsNull.true Please don't laugh...

Thank you so much. Your suggestions were right on target! I appreciate the help.

It is an easy solution. Create and save a new macro whose action is MsgBox. Then go to the Properties of the command button and enter your macro at OnClick. There will already be a Save Record macro there, but you can have more than one on the same action.

I have tried to display a message asking if you are sure you want to change data when you enter a field that already contains data. This is via a combo box. Even when the entry is new, the message comes up. I have tried using OnDirty, OnChange, and AfterUpdate, but I always get the message on...