createcontrol problem

Helen · Mar 3, 2000

I am trying to create a rectangle 'on the fly' and am using the createcontrol function. However I am getting an error message: 'Run-time error '29054': Microsoft Access can't add, rename, or delete the control(s) you requested.' All the buttons, except the End button is greyed on the dialog box that displays this error. 
 
I hope someone has a solution to this problem 
 
thanks in advance 
Helen Fairweather

famousb · Mar 3, 2000

could you be a little more specific as to what you mean by "creating a rectangle 'on the fly'"? 
maybe give a brief example of what you're looking to do on your form. 
 
thanks. Brian Famous <a href=mailto:bfamous@ncdoi.net>bfamous@ncdoi.net</a> <a href= > </a>

DougP · Mar 3, 2000

What do you want your rectangle to do. 
Maybe instead of "Creating" it. Just "re-size" an "invisible" one and turn it "visible". DougP <a href=mailto: dposton@universal1.com> dposton@universal1.com</a> <a href= > </a>

Helen · Mar 3, 2000

In response to Brian Famous: 
 
I have written a rainfall-runoff simulation model in access and want to design a dynamic interface to show rainfall and runoff as the program steps through each day. Previously i have had lots of problems with using dynamic graphs in Access and thought i would add rectangles and scale them to give an indication of the amount of rainfall and runoff on any particular day. 
 
I have written the following code to add a rectangle to an existing form, which generates the error message outlined in my original post. If I create a new form and use createcontrol in the same way, the code works. But I would prefer to add the rectangles to an existing form. 
 
Sub test_des_mode() 
Dim new_rect As Control 
 
 
DoCmd.OpenForm "runoff", acDesign, "", "", , acNormal 
l_val = 1000 
t_val = 2000 
wd = 1000 
ht = 1000 
 
 
Set new_rect = CreateControl("runoff", acRectangle, , "", "", l_val, t_val, wd, ht) 
 
regards 
 
Helen Fairweather

DougP · Mar 3, 2000

Is'nt odd, Helen that your Last name is Fairwhether and you are dealing with a rainfall project. 
 
Access is telling you that you cannot create a control so Guess what you cannot "Create a control" 
But that does not mean the you cannot end up with the same result. 
I looked up an example in Help and it refers to creating control. but it is being done while creating a new form. 
 
This works: 
Me!Box17.Left = 1000 
Me!Box17.Top = 2000 
Me!Box17.Width = 1000 
Me!Box17.Height = 1000 
 DougP <a href=mailto: dposton@universal1.com> dposton@universal1.com</a> <a href= > </a>

Helen · Mar 3, 2000

Doug, 
 
Any ideas why the createcontrol function will work on a new form, but not an existing one? the code you posted will only work if box17 exists, or am i missing something? 
 
thanks for your help 
 
Helen Fairweather

JimConrad · Mar 3, 2000

I copied the code as written (added an "End Sub&quot

and it works fine in Access '95. 
 
Are you using '97 or 2000? Jim Conrad <a href=mailto:jconrad3@visteon.com>jconrad3@visteon.com</a> <a href= > </a>

Helen · Mar 3, 2000

This is a great forum. 
 
Jim, 
 
I have just discovered that the code will work if i run it from a module, but will not work when associated with a button on the form! I will be able to work around it, but it is very frustrating not knowing why. I am using 2000 
 
thanks everybody for you help 
 
Helen Fairweather

JimConrad · Mar 3, 2000

In Access '95 it works. On "Form1" I placed a button and in the Click event added your code. I open Form1, click the button several times. For each "click" a new box is added to the "runoff" form. 
 
You aren't trying to run the code from WITHIN the "runoff" form, right? Jim Conrad <a href=mailto:jconrad3@visteon.com>jconrad3@visteon.com</a> <a href= > </a>

Helen · Mar 6, 2000

Jim, 
Yes, I was trying to run the code from WITHIN the "runoff" form. I have rectified this and it now works! do you know why it will not work WITHIN the "runoff" form? 
 
Thanks for your help everybody 
 
regards 
 
Helen Fairweather

JimConrad · Mar 6, 2000

You can't use a form in both "design" mode and in "runtime" mode at the same time. 
 
You could open a secord form from the "runoff" form and have it switch "runoff" to design mode, add the new controls, then open "runoff" in NORMAL mode. Jim Conrad <a href=mailto:jconrad3@visteon.com>jconrad3@visteon.com</a> <a href= > </a>

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!

createcontrol problem

Helen

Programmer

famousb

Programmer

DougP

MIS

Helen

Programmer

DougP

MIS

Helen

Programmer

JimConrad

Programmer

Helen

Programmer

JimConrad

Programmer

Helen

Programmer

JimConrad

Programmer

Similar threads

Part and Inventory Search

Sponsor