Recent content by vangx222

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