Search results

I created the below linked thread for people to discuss how MVF fields work and if you plan to use them what you need to know. https://www.access-programmers.co.uk/forums/threads/mvf-technical-discussion-and-uses-if-you-plan-to-use-them.334422/ It was meant to be narrowly focused on that topic...

Saving a Related Key or the Actual Value in MVF. My previous discussion on using a look up table was not complete. This obfuscation is one of the things that drives people absolutly crazy about MVFs 1. From a lookup table you will save either the PK of the lookup as the value in the hidden...

You can fake a multiselect combobox. Post in thread 'Form Design to Allow Multiple Selections (Add your Ideas)' https://www.access-programmers.co.uk/forums/threads/form-design-to-allow-multiple-selections-add-your-ideas.334421/post-1970121

Not exactly. The query has a function that returns the full path. Only the name of the file is saved in the table. The function concats the current image folder path and the file name. If a file does not exist it chooses the default image. However when the path calculated then you kind bind to...

The URL in the displayed MVF would be concatenated strings not URLs. Remember as shown that field is really holding foreign keys not the value you see shown. To get to the URLs you would have to link to the lookup table.

Getting a Recordset of the List of Values In thread 2 and 3 I showed you can simply join the table containing an MVF to the lookup table and do pretty much anything you can do with a regular child / Junction table. You can then use that query to get a list of the values in an MVF field...

Folks, the purpose of the thread as stated was to provide some technical understanding of how MVFs work and if you do choose to use them what can you technically do with them. If you can contribute understanding such as @isladogs please contribute. Please limit the discussion to explaining how...

I am not even sure what you are looking at because that demo is a mess. I forgot to provide the folder of demo images Here is how I would do it. 1. Inside the folder where you keep the db add a child folder for cover art called CoverArt 2. Put images in there and add two images one Image to...

As previously posted, this example uses the same technique of using a "holding table" for the MVFs. https://www.access-programmers.co.uk/forums/threads/mvf-discussion-and-uses-if-you-plan-to-use-them.334422/ Using this same concept of a "holding table" for the MVF you could use this to write to...

Just that it is a lot of information and the reader may have overlooked it, and it may be the most important area to understand. Because your value list and lookup example both return integers, I thought it might be easier to follow if the display is text. They may have missed that the "value"...

Referential Integrity of MVF To demonstrate that the MVF table enforces referential integrity on the hidden table. Try to delete a selection from your lookup table Since I have Metal Studs as a selection (child record in hidden table) in my Company table I cannot delete it from the lookup...

Like I said. Doing one specific thing, hard wired is easy. @isladogs code is far more complex supporting monitors with various resolutions, resizing forms, different types of forms.

When you are debugging it is often helpful to "turn off" the error handling. So in front of lines like On Error GoTo ErrorHandler put a single quote before. Often called "commenting it out". ' On Error GoTo ErrorHandler:<br> Now it will break on that error in the correct location (maybe...

I was referring to the checklist examples and the mvf filter. Look, writing code hard wired to do one thing one time is easy. Making generic code that is easily reused is hard. Your suggestion would require the user to hardwire the positions every time they position a control which would be a...

OK I guess, but those are demoing two very different concepts. Pretty much apples and oranges.

A More Complex Query of MVF with Linked Lookup Table To demonstrate that you can do more with the data in the lookup table. Here is a more complex query that uses the other fields in the lookup. Once you join the MVF to the lookup you can query like any other standard junction table design...

Querying an MVF with Linked Lookup Table. Probably the most important conversation in Colin's link is how you query the MVF when working with a lookup table. He provides an example, but it might be lost. In my posted example above there is a lookup table for WorkType. I added an extra field...

Those are used to accurately position a pop up. @isladogs probably has the most comprehensive discussion on this topic https://www.access-programmers.co.uk/forums/threads/getting-pop-up-form-to-center-on-monitor.328128/post-1906874 Not sure what that means because there is no such thing as a...

@BlueSpruce and @DakotaRidge , I created this thread for all things related to using MVFs and how they work. https://www.access-programmers.co.uk/forums/threads/mvf-discussion-and-uses-if-you-plan-to-use-them.334422/ People can provide examples like doing recordset manipulation and query...

Since there is a lot of discussion now on MVF, I created this thread to provide discussion on understanding how they work, what you can do with them, and how to use them. There is plenty of discussion of the cons of MVF and what you cannot do with them, so no need to rehash that here. However...