[Webinar] Streamline your web hosting managementRegister Today

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 393
  • 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
Never miss a deadline with monday.com

The revolutionary project management tool is here!   Plan visually with a single glance and make sure your projects get done.

 
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

Learn to develop an Android App

Want to increase your earning potential in 2018? Pad your resume with app building experience. Learn how with this hands-on course.

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