Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Rhinorhino on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. vangx222

    Enabling controls based on two other controls

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

    Enabling controls based on two other controls

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

    Enabling controls based on two other controls

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

    Enabling controls based on two other controls

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

    Enabling controls based on two other controls

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

    Enabling controls based on two other controls

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

    Enabling controls based on two other controls

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

    combo box based on another combo box problem

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

    Switchboard

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

    undo auto maximize

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

    How to require a password before deleting db

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

    How to require a password before deleting db

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

    How do I UN-highlight a field upon entering

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

    How to disable text field controls in subform

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

    How to customize a pop-up

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

    How to disable text field controls in subform

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

    How to close access on click

    YEUP! Works AWESOME! Thank you Crowley16
  18. vangx222

    How to close access on click

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

    Hide Combo Box in Continuous form

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

    Required field

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

Part and Inventory Search

Back
Top