Search results

No. A standard multiselect listbox (simple or extended) has been available since at least A2000. It does not depend on MVFs. It allows multiple selections on a form but does not have checkboxes. However, you can also choose a listbox control when creating an MVF field. That also allows multiple...

I disagree. Nowhere in this thread has he agreed to split his database. We had the same interminable discussions with his proposals database. It never got implemented and indeed never went to production. I very much doubt this will be any different. This database will likely remain for his...

Multiselect listboxes are an excellent Access feature which have nothing to do with MVFs @arnelgp's unusual approach to storing MVFs in a standard normalised table is actually far more complex than a standard MVF. It requires an additional table for storing data plus a hidden attached table for...

I would normally only show one field if I was going to use a multiselect combo box. Nevertheless, the option is there to have multiple fields even though it would be confusing for many users. However, your comments about using the wizard to create an MVF field structure based on a lookup table...

Been there. Done that! Deja vu! He won’t split.

REMINDER Access Europe User Group meeting is tomorrow (WED 6 Aug) at 18:00 UK time

That’s what I thought 😏 Mind you Maria’s description may be hard to follow for anyone who hasn’t already seen Graph API in action

Not that I’m aware of but it’s not something that I’ve tried doing.

Why? The misleadingly named Graph API has nothing to do with charting. The AL session is about emailing from Access but using that API instead of Outlook

AFAIAA, the ChartSeriesCollection only applies to Modern Charts in A365 and your screenshots indicate a classic chart is being used With modern charts, I can use code such as this: 'set chart appearance With Me.Chart0.ChartSeriesCollection .Item(I).GridlinesType =...

Although I totally agree with how confusing it can be, I don't completely agree with your comments above. If you are using the wizard with a lookup table such as tblColors where ColorID is the PK field, the next screen allows you to choose the field(s). In this case, I'll select both Next I'm...

Although I like the idea of using ConcatRelated to store the data in a normalized table, I think it is much easier to understand what is going on and indeed work with a 'standard' MVF structure The attached demo uses the same country & colors tables but the FlagColors is a standard MVF field...

Thank you. That’s very helpful. I’m not at my computer at the moment but on a first read that all makes sense to me. Have you had time to think about querying the countries and flag colours?

I agree that table tblDummyMVF has an MVF table structure and which is used in the generated form frmMVF I'll need to study the code more carefully to understand how exactly it works Question: How could you use this to query filtering for countries with a certain combination of flag colours...

@DakotaRidge Just to be clear, @arnelgp is NOT using a standard MVF structure in his example database @arnelgp That is indeed an interesting way of faking an MVF and it appears to work perfectly using the ConcatRelated function As you are probably aware, it does still depend on a deep hidden...

See my article for how to fix this: https://isladogs.co.uk/nav-bar-height/

It is precisely because Access doesn't centre forms vertically that I have code to do so more accurately. Some of it is mine but I also have code by other developers. See my article: https://www.isladogs.co.uk/centre-form-on-screen/index.html Which works best? It depends!

Agreed. It doesn't matter whether you use a value list or a lookup table for your MVF field. The displayed value(s) will just be strings and not active. To have URLs that are active, these need to be individual records in a standard text box

I haven't watched Richard's video but that point isn't correct If AutoCenter is set to Yes then a) a standard form is centred horizontally in the database window b) a popup form is centred horizontally on the monitor BUT c) for both types of form the form is placed with the top about 1/3 of...

Whilst of course I wouldn't recommend it, there is no reason why you can't use URLs as MVF selections: