A Microsoft Office (Excel, Word) forum. OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » OfficeFrustration forum » Microsoft Access » Using Forms
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Max. # of Controls on Form



 
 
Thread Tools Display Modes
  #1  
Old June 16th, 2004, 02:07 AM
BGates
external usenet poster
 
Posts: n/a
Default Max. # of Controls on Form

Have a form with three subforms, over 100 controls in all.
Under certain conditions, some of the controls
on one of the subforms should not be enabled.
The code works, setting the controls.enabled = false up to
the last five (of 30) controls. Error message is
"Database can't find the field 'txtCompleteDate' referred
to in your expression", even though I can see the control
on the subform.
Does Access just run out of steam and can't manage the
refresh of all those controls?

  #2  
Old June 16th, 2004, 03:12 AM
StCyrM
external usenet poster
 
Posts: n/a
Default Max. # of Controls on Form

Hi

I would start with a Repair / Compact of the database.

Number of controls and sections you can add over the lifetime of the form or
report is 754

Maurice




Have a form with three subforms, over 100 controls in all.
Under certain conditions, some of the controls
on one of the subforms should not be enabled.
The code works, setting the controls.enabled = false up to
the last five (of 30) controls. Error message is
"Database can't find the field 'txtCompleteDate' referred
to in your expression", even though I can see the control
on the subform.
Does Access just run out of steam and can't manage the
refresh of all those controls?









  #3  
Old June 16th, 2004, 04:25 AM
Wayne Morgan
external usenet poster
 
Posts: n/a
Default Max. # of Controls on Form

Possibly there is something corrupt in the form, at 100 you are well within
the allowable number. Also, assuming it works for forms as it does for
reports (I've hit the limit in reports), using a subform only counts as one
control on the form holding the subform.

Check for typos in the name of the control or the name used in the code.
Also, make sure the control and the field it is bound to don't have the same
name. If the field is FieldName then change the textbox to txtFieldName and
use the name of the control in the code.

Since you appear to mention that this works for some of your controlls, I
assume you have the syntax correct to refer to controls on a subform from a
main form, but just in case:

Me.ctlNameOfSubformControl.Form!ctlNameOfControl

The ctlNameOfSubformControl is the name of a control on the main form that
holds the subform, not the name of the subform. To see this name, open the
main form in design mode, open the Properties sheet, and click on the
subform ONE time. The Properties sheet should show the name of the subform
control. If you click more than once, you'll be in the subform and the
Properties sheet will show the name of the subform, not the control holding
it.

--
Wayne Morgan
MS Access MVP


"BGates" wrote in message
...
Have a form with three subforms, over 100 controls in all.
Under certain conditions, some of the controls
on one of the subforms should not be enabled.
The code works, setting the controls.enabled = false up to
the last five (of 30) controls. Error message is
"Database can't find the field 'txtCompleteDate' referred
to in your expression", even though I can see the control
on the subform.
Does Access just run out of steam and can't manage the
refresh of all those controls?



 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 07:50 AM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.