Search results for query: *

ZOR, I tried what you suggested and it still didn't work for me. For anyone else with the same question as mine, I FOUND A SOLUTION with the help of someone else! Yahooo! =) for future reference, If anything is entered into A or B then C & D is visible Private Sub ControlA_Change() If...

oops I meant to say enable and disable... not visible. =) Thank you so much for your help. AGAIN, it works perfectly fine when I enter a value into controlA but does not work the way I want it to when you enter a value into controlB. The problem with controlB is that when I enter a value...

It looks like it's " " but it's really "" Well the code that jrbarnett offered didn't work. So you're saying, put If Me.controlA.Value = "" Or Me.controlB.Value = "" Then Me.controlC.Enabled = False Me.controlD.Enabled = False Else Me.controlC.Enabled = True...

It looks like it's " " but it's really "" Well the code that jrbarnett offered didn't work. So you're saying, put If Me.controlA.Value = "" Or Me.controlB.Value = "" Then Me.controlC.Enabled = False Me.controlD.Enabled = False Else Me.controlC.Enabled = True...

Ok, here's what I tried.. Private Sub controlA_Change() If Me.controlA.Value = "" Or Me.controlB.Value = "" Then Me.controlC.Enabled = False Me.controlD.Enabled = False Else Me.controlC.Enabled = True Me.controlD.Enabled = True End If End Sub on the On Change event of only...

and this would go in the On Change event of controlA? or controlB? or it doens't matter?

Hi. I hope this is an easy one, I just can't figure out how to do it. I have four controls that are used for entering text. TWO of the controls [controlA and controlB] are kept visible and TWO of the others are not. What I want to happen is when I type in data for EITHER controlA OR controlB...

Hi. I received my example of how to create a combo box based upon another combo boxed from here: "[URL unfurl="true"]http://office.microsoft.com/en-us/access/HA011730581033.aspx"] My problem is the criteria part. I put this [Forms]![Diagnosis]![cboDiagnosis] in the criteria section like the...

Have you tried going under Tools in Access, Database Utilities, then Switchboard Manager?

In Access, is there anyway to Auto maximize one form, but not any others that you open? For example, I put the auto maximize code, DoCmd.Maximize, in the Open Event of my form [mainfrm]. On this form, I also have command buttons that on click will open up other forms (they're NOT subforms). The...

Thank you for the reply. How would I do this?

Hi. I have my database is a share drive. I know no one would just go and delete it, but just to be on the safe side, is there a way I can have a password required before you can delete the database? Thank you in advance.

Hi. I have a form with tabs that also contain subforms within them. When I click through each tab, ONE field in the subform is highlighted with the cursor in that field. This gets really annoying when I just want to VIEW the data switching from tab to tab and not enter in data. Is there anyway...

PHV, I looked at the information on that link and it didn't help me much. Someone also suggested this link, http://www.mvps.org/access/forms/frm0031.htm and I'ved tried these syntax as wells and it's not successful either. It works if I'm in the SUB form and want to disable a field in the...

Hi. I have a form that has a date field and some other data entry fields. I have all the OTHER fields disabled and have ONLY the date field enabled. Once you enter data into the date field then automatically all the other fields become Enabled. I want to create a popup message that appears if...

Hi. I have a main form and a sub form. In my mainfrm I have a text field that is REQUIRED before I can enter any data into the subfrm. Can anyone help me with this code and how I would relate the two? I know how to do it when all the controls (text fields) are on the same form, but when it's a...

YEUP! Works AWESOME! Thank you Crowley16

Hi. I used the switchboard to create a control to close my database, however, it ONLY closes my database and leaves the blank Access screen behind. My question is, is there a way to close everything on click? If yes, can you tell me how (what codes) and where I'd place it? Would it be in the On...

If a value in my combo1 has a subcatergory then combo2 will automatically appear with a list of values that relates to the value in combo1 taht I chosed. Once I select the value for combo2 and then choose a new value for combo1 for the next record, combo 2 disappears in the previous record. When...

Is there anyway to make a field on a form required BEFORE any data can be entered into the other fields? I've been having a pop-up message as a reminder, but that gets really annoying because it pops up EVERYTIME I open the form. Ex. I have a database based on Patients, Patient Visit Date, and...