Access Equivalent to Excel

[NigelShaw]

Hi,

in Excel, i can dynamically add option controls to a frame on a form using the Control.Add method. Is there an Access Equivalent? I can only find Count & Item as Control. items.

It might have something to do with design view i guess. vv frustating


Cheers


Nigel

 

[boblarson]

No, you can't do it that way. You would need to open the form in design view (you can do that hidden) and then add controls and then save the form but you would not be able to do this if you ended up needing to convert the file to an ACCDE/MDE file as you can't create objects on the fly in those.

 

[Galaxiom]

The Access alternative is to have the controls already on the form but Not Visible until required.

 

[Pat Hartman]

Access is not Excel. Take off your Excel hat and start thinking relational thoughts. In a realtional database we don't add columns(controls), we add rows. What are you trying to do that requires adding controls to a form on the fly?

 

[NigelShaw]

Hi Pat

I rarely where my excel hat these days and always think Access. What I'm actually doing is creating a visual font dialog with option buttons and each option button label holds the style of the font so it can be visually seen.

Can do this at load time in Excel on a form and Not in Access. I know why I can't in Access and Bob confirmed that.

For now, I have settled for a listbox showing the fonts and a label showing the style when it is selected. Not as elegant but it works!

Access is great in so many ways yet, lacks some of the most simple things like, tracking the mouse as it moves over a listbox. Something even html does so easily :-S

Cheers



Sent from my OMNIA7 using Board Express

 

[Galaxiom]

Access is great in so many ways yet, lacks some of the most simple things like, tracking the mouse as it moves over a listbox.

Access has the OnMouseMove Event.

BTW Even though controls can be added at runtime in the full version of Access it would not be a good idea.

Access can only support 700 or so controls in the life of a form. After that you have to export the objects to a new database before you can add any more.