how to create checkboxes on form-load?? (VERY URGENT)

• Dec 12, 2000

• Thread starter
• #2

frag

Programmer

Dec 7, 2000

321

GB

uuuups...

there is something i forgot:

i am using VBA for Access 97

 

Upvote 0 Downvote

• Dec 20, 2000

• #3

Durkin

Programmer

Nov 6, 2000

304

GB

The reason you're getting that message is because the CreateControl function can only add controls to a form that is in design view. It's really meant for creating your own wizards and things like that. Possibly what you could do is open the form intially in design view, add your controls and then open it normally. Try something along the lines of:

Code:

Public Sub MakeCtls()

    DoCmd.OpenForm "form1", acDesign, , , , acHidden
    CreateControl "form1", acTextBox, acDetail, , 15, 15, 15, 1500, 500
    DoCmd.OpenForm "form1"
    
End Sub

Durkin
alandurkin@bigpond.com

 

Upvote 0 Downvote

• Dec 20, 2000

• Thread starter
• #4

frag

Programmer

Dec 7, 2000

321

GB

Hi Durkin!

Thanx for your reply.
I have checked out your piece of code... but this doesn't work either.

Run-time error '2174':
You can't switch to a diffrent view at this time.
Code was executing when you tried to switch views.
If you are debugging code, you must end the debugging operation before switching views.

I will just set my checkboxes to invisble and set them to visible at runtime when i need them. Ugly, but it works.

Thanx!

frag patrick.metz@epost.de

 

Upvote 0 Downvote

• Jan 8, 2001

• #5

scking

Programmer

Jan 8, 2001

1,263

US

I'm unsure why you would need to create a control when the form opens. Maybe the following would satisfy your requirement: creating the controls normally and setting their visible properties to false. Then, when the form opens you set the visible property to true on whatever control you would need. Another possibility would be to manage properties of a single control during the open event. Hope one of these would help.

 

Upvote 0 Downvote

• Jan 9, 2001

• Thread starter
• #6

frag

Programmer

Dec 7, 2000

321

GB

Hi scking!

Thanx for your reply.

1. visible/invisible
--------------------
I already mentioned this in my last replay!


2. Why I need to create controls on formload
-------------------------------------------
I get data from a database table. According to this data
I have to set controls to visible/unvisible. Thought it
would be nicer to have a dynamic form with dynamic
controls (for saving place on the desktop).

But anyway... forget it. The app is finish and rolled out.

cya

frag patrick.metz@epost.de

 

Upvote 0 Downvote