By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
434,896 Members | 2,002 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 434,896 IT Pros & Developers. It's quick & easy.

Create Subform in VBA

P: n/a
Hi,

How can I dynamicly create a subform in VBA that fit to a temoporary
generated table with various number of fields and field_names.

Finn
Nov 12 '05 #1
Share this Question
Share on Google+
2 Replies


P: n/a
On Sun, 19 Oct 2003 16:18:09 +0200, "Fieje" <fi***@pc.dk> wrote:

In Access controls can only be generated at design time, unlike VB.
The closest you can get is by opening the form in design view:
DoCmd.OpenForm "MyForm", acDesign
and then using CreateControl to create the controls. This will not
work in an MDE application, only in an MDB.

Sometimes an alternative may be to create a bunch of hidden controls
at design time, and show some of them at runtime.

-Tom.
Hi,

How can I dynamicly create a subform in VBA that fit to a temoporary
generated table with various number of fields and field_names.

Finn


Nov 12 '05 #2

P: n/a
What exactly are you trying to do? You can insert subforms easily
into another form by dragging and dropping. You may have to have the
wizard installed for this but it works great. Then you just build
your subform how ever you like. Can even link the data if you need
to.
Dannic
Http://www.orpgs.com

"Fieje" <fi***@pc.dk> wrote in message news:<3f**********************@dread14.news.tele.d k>...
Hi,

How can I dynamicly create a subform in VBA that fit to a temoporary
generated table with various number of fields and field_names.

Finn

Nov 12 '05 #3

This discussion thread is closed

Replies have been disabled for this discussion.