Search results

  1. N

    Reset the active control value of a subform when switching to another subform

    Access 07 Windows 7 I've trapped the SHIFT+TAB and TAB keystrokes within the keydown event of a subform to behave appropriately (switch back and forth between subform1 and subform2). However, my current problem is this: Subform1 and Subform2 have 3 textbox controls each. If I am on control2...
  2. N

    Using .controlsource to update an unbound textbox's control

    Access 2007 Windows 7 So I'm somewhat back to my original problem I posted about several weeks ago, where I am attempting to set the control source of a text box based on very simple criteria: Is a field from a set of fields in my table null? If yes, set the control source to that field...
  3. N

    General Question: Macros, Or Event Procedure, which is preferred?

    Using Access 2007, Windows 7. Just looking for general advice and opinions on which is a more efficient and preferred method, programmatically, to run commands and execute functions within forms: Macros, or VBA Event Procedures? I am clearly getting into the learning curve that there is far...
  4. N

    Using * variable to change set the property of multiple controls

    Using * wildcard to set enabled property of multiple controls So I'm using the following code to check if a field has data in it, and if it does, it's enabled property is automatically set to False on form load. Private Sub Form_Load() If Form![PID1] = Null Then Form![PID1].Enabled = True...
  5. N

    Update multiple text boxes in a report from a single table field

    I'm very new to access, mostly self taught through modifying templates and getting the results I want through lots of trial and error. I've created an access report to basically mimic a DA Form (Deparment of the Army) that records equipment inspection dates, who did the inspection, and when...
Back
Top Bottom