Results 1 to 8 of 8
  1. #1
    3 Star Lounger
    Join Date
    Jan 2001
    Location
    New England (Connecticut)
    Posts
    200
    Thanks
    1
    Thanked 0 Times in 0 Posts

    tab control (2003 Office)

    Hi all,
    curious here, I am getting an error message stating that access can't assign a value when i exicute the following code:

    Forms![Pricing]![TAR_Rate_Name] = Forms![Pricing]![Rate_Name]

    Both are text boxes and both reside on a tab control. Access sees the value in"

    Forms![Pricing]![Rate_Name]

    but when it tries to write that value in:

    Forms![Pricing]![TAR_Rate_Name]

    it says cannot assign a value. Both controls are formated exactly the same. Is there anything special about tab controls that would cause this?
    Kevin

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: tab control (2003 Office)

    I don't think this has anything to do with tab controls.

    a) Where do you run this code? In the module belonging to Pricing or elsewhere?
    [img]/forums/images/smilies/cool.gif[/img] Is Pricing a normal form, or is it a subform on another form?
    c) Is Pricing open when you run this code?

  3. #3
    3 Star Lounger
    Join Date
    Jan 2001
    Location
    New England (Connecticut)
    Posts
    200
    Thanks
    1
    Thanked 0 Times in 0 Posts

    Re: tab control (2003 Office)

    Thanks Hans,

    The code is run in the on open event of the Pricing Form. The Pricing form is a main form and the tab control resides on it. There are other subforms on the tab control but the controls in question are not part of them. All of the controls in question are visible, enabled and not locked. Hope that helps.
    Kevin

  4. #4
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: tab control (2003 Office)

    Try putting the code in the On Load event of the form instead of in the On Open event. On Open occurs before the records have been loaded.

    And since the code runs in the module belonging to the form itself, you can use

    Me![TAR_Rate_Name] = Me![Rate_Name]

    In the form module, Me refers to the form itself.

  5. #5
    3 Star Lounger
    Join Date
    Jan 2001
    Location
    New England (Connecticut)
    Posts
    200
    Thanks
    1
    Thanked 0 Times in 0 Posts

    Re: tab control (2003 Office)

    thanks Hans, I will give it a try.
    Kevin

  6. #6
    3 Star Lounger
    Join Date
    Jan 2001
    Location
    New England (Connecticut)
    Posts
    200
    Thanks
    1
    Thanked 0 Times in 0 Posts

    Re: tab control (2003 Office)

    Edited by HansV to replace 3.9 MB bitmap file in zip file with 12 KB .png file containing the relevant part of the image. Saves disk space and superfluous clicks.

    Hans,
    Thank You for your help. I have made great progress since yesterday. This tabbed form seems to flow better than the old method (never really got into that) but I am curious as why the tab names sometimes go blank or turn white when I tab through the control. Have you seen this before? see attched screen shot.
    Attached Images Attached Images
    • File Type: png x.PNG (11.3 KB, 0 views)
    Kevin

  7. #7
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: tab control (2003 Office)

    That looks like a problem with your video card. Some things to try:

    1) Look for an updated driver for your video card.

    2) Decrease hardware acceleration:
    - Open the Display Properties control panel (either by right-clicking an empty part of the desktop and selecting Properties from the popup menu, or through Start | Control Panel)
    - Activate the Settings tab,
    - Click Advanced.
    - Activate the Troubleshoot tab.
    - Drag the Hardware acceleration slider a notch or two to the left.
    - OK your way out.
    - If that doesn't help, repeat.
    - If it doesn't help at all, you can restore the original setting.

  8. #8
    3 Star Lounger
    Join Date
    Jan 2001
    Location
    New England (Connecticut)
    Posts
    200
    Thanks
    1
    Thanked 0 Times in 0 Posts

    Re: tab control (2003 Office)

    Hans, thanks

    I tried to decrease the hardware acceleration but our working environment here has that part locked out so if I can't get IRM folks to allow access or install updated driver if it exists I will probably live with it. The tab names seem to come back as soon as you roll the cursor over the top.

    Thanks again for the help.
    Kevin

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •