Multi-value field (MVF) Faked Form.

[arnelgp]

simple demo to save in Normal table the values
selected in Multi-value list.

Related threads:

Sorry folks, Access World will not accept my posts

So for the sake of helping @DakotaRidge, I created a prototype app that uses a multiselect list box for storing employee certifications in an MVF. ***I tried attaching the accdb to this post, and it attached, or didn't, I dunno. Guess I need 100 posts to do that?*** Can someone show...

www.access-programmers.co.uk

MVF Discussion and Uses (If you plan to Use Them)

Whilst of course I wouldn't recommend it, there is no reason why you can't use URLs as MVF selections: Colin, are the URLs still hotlinks in your example? Just having multiple attributes is not enough. When I viewed them in my form, they were text strings. The URLs were concatenated to the...

www.access-programmers.co.uk

 

[arnelgp]

added another table tblNationalities and junction table tblCountryNationals for more test.
also adjusted the code to prevent the "mvf" form from getting off the bottom of Access screen.
added extra "multi-value combobox" to the three forms.
combobox nationals' records will be saved to tblCountryNationals junction.

 

[arnelgp]

minor change, adding background color to the form and changing the font
of the listbox (on frmMVF) same as the font on the combobox.

still working on the pop-up placement (the pop up should not go beyond the bottom of the screen).

 

[RonPaii]

I was stepping though your code. In clsControlLayout you are setting PixelsNamPaneHeight in the section commented for getting the tab stripe height. The set it again with out referencing the 1st value in the section for navigation pane. Is this an error or am I missing something?

 

[arnelgp]

try to analyze the code.
the first PixelsNavPaneHeight is the height of the "Tab" of the form (tabbed form).
then on the last it add it to get the "real" navigation pane height.

i cannot find the original code from the author since he already retires from msAccess.