tab control (2003 Office)

Topic

New Reply

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?

Reply | Quote

Replies

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?
Is Pricing a normal form, or is it a subform on another form?
c) Is Pricing open when you run this code?

Reply | Quote

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.

Reply | Quote

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.

Reply | Quote

thanks Hans, I will give it a try.

Reply | Quote

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.

Reply | Quote

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.

Reply | Quote

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.

Reply | Quote