[Last Call] Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 391
  • Last Modified:

Variable Length SubForm

Is there a way to have a variable length subform append its records in multiple columns, rather than just vertically?
0
mcarollo1
Asked:
mcarollo1
  • 5
  • 5
1 Solution
 
hotbudareCommented:
No, as far as I know, you can't.
There might be a workaround if the maximum number of records is known. Let us know if that's the case.
0
 
mcarollo1Author Commented:
The maximum number of records can be assumed.  ex. I know there will never be more than 12.
0
 
nico5038Commented:
This can be "tricked" in various ways. One would be to create twelve subforms and make them visible when there is data. Another way could be adding columns in a datasheet subform.
I'm just curious why you want to go horizontally iso "unlimited" vertically....

Nic;o)
0
Microsoft Certification Exam 74-409

VeeamĀ® is happy to provide the Microsoft community with a study guide prepared by MVP and MCT, Orin Thomas. This guide will take you through each of the exam objectives, helping you to prepare for and pass the examination.

 
mcarollo1Author Commented:
can you expand on the 12 subforms idea?
0
 
nico5038Commented:
For this easiest will be to have a sequence number (1-12) in the data. This will enable you to do a link between an unbound field per subform (filled with 1-12) on the main form and the datafield of the subform to have the data automatically in the correct subform.
If wanted you could make the empty subform(s) invisible, however that will take extra VBA coding.

Need more info ?

Nic;o)
0
 
mcarollo1Author Commented:
How is that done?
0
 
nico5038Commented:
Can you drop the (compacted and zipped) .mdb in my nico5038 mailbox "at" yahoo.com.
The I'll make a sample.

Nic;o)
0
 
mcarollo1Author Commented:
OK, I'm sending an example to your yahoo address
0
 
nico5038Commented:
Check your mail.

For making columns I added a MOD to "split" the subform's records into two columns, enabling an "Unlimited" number of rows.

Nic;o)
0
 
mcarollo1Author Commented:
Very creative.  Thanks for your help!
0
 
nico5038Commented:
You're welcome, success with the application !

Nic;o)
0

Featured Post

Free Tool: Subnet Calculator

The subnet calculator helps you design networks by taking an IP address and network mask and returning information such as network, broadcast address, and host range.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

  • 5
  • 5
Tackle projects and never again get stuck behind a technical roadblock.
Join Now