So, Have played with the dual sub-form option and gotten something that will kinda work for me at the moment. Still not happy that it requires a user action to list the Hives for a given Apiary but Access has limitations, and I get that.
I think at some point I will start playing with some of the more advanced queries to try and populate an interim table and while concatating (sp) the Hive details so they can be injected into a single text box beside the Apiary details. Have never worked with those types of queries so will take some research on my part.
Please have a look at the attached updated file, I think it should be close to what you want. I had to use Courier New for the new textbox, you can use any other non-proportional font (https://en.wikipedia.org/wiki/List_o...aced_typefaces).
So, Have played with the dual sub-form option and gotten something that will kinda work for me at the moment. Still not happy that it requires a user action to list the Hives for a given Apiary but Access has limitations, and I get that.
I think at some point I will start playing with some of the more advanced queries to try and populate an interim table and while concatating (sp) the Hive details so they can be injected into a single text box beside the Apiary details. Have never worked with those types of queries so will take some research on my part.
Thanks for all the input
Considering this thread closed.
You would probably need to use a spreadsheet layout, like you did at the start of all these threads.
Just repeating information time and time again.
Have you thought about just using Excel. That would give you what you want?
Please have a look at the attached updated file, I think it should be close to what you want. I had to use Courier New for the new textbox, you can use any other non-proportional font (https://en.wikipedia.org/wiki/List_o...aced_typefaces).
Cheers,
Interesting. Will review and play with this to see if I can incorporate this approach.
You would probably need to use a spreadsheet layout, like you did at the start of all these threads.
Just repeating information time and time again.
Have you thought about just using Excel. That would give you what you want?
I actually started with Excel but as soon as you start populating the spreadsheet with a bunch of check boxes, it starts dragging real quick. Wanting to make it as easy as possible for the user (mainly me) to just click and select as many options as possible.
Yes, I'm probably trying to make it fancier than it needs to be but, always been that way for me.
I'm not sure if what you're after is having a list of Hives next to each Apiary in your continuous form. If so, you might want to consider reports and, most importantly, reports inside reports for a built-in nested list with arguably more control than a textbox or listbox. In the end, if this sort of layout is what you're after, there may be some visual and functional limitations, but it does the job of presenting the lists as you want them.
Are there other approaches? Yes, forms can also be embedded if you put them in another section, as has been said. Lastly, the web browser control could also take care of all these views with a ton of control, but it's harder to setup because it requires VBA, HTML and CSS know hows, it's very doable, though.
Please click on the ⭐ below if this post helped you.
I'm not sure if what you're after is having a list of Hives next to each Apiary in your continuous form. If so, you might want to consider reports and, most importantly, reports inside reports for a built-in nested list with arguably more control than a textbox or listbox. In the end, if this sort of layout is what you're after, there may be some visual and functional limitations, but it does the job of presenting the lists as you want them.
Are there other approaches? Yes, forms can also be embedded if you put them in another section, as has been said. Lastly, the web browser control could also take care of all these views with a ton of control, but it's harder to setup because it requires VBA, HTML and CSS know hows, it's very doable, though.
This looks very close to what I have been looking for. Will certainly open it and have a look. Fighting another problem presently but I will post a response once I get into this option you have provided.
Windows 7 32bit 
Access 2007
Reply With Quote
Originally Posted by ScubaBart
