Search results

@isladogs has a good explanation https://isladogs.co.uk/multivalued-fields/index.html Also this demo shows a lot of functions that can be used on a MVF. This demo uses three MVF to query three MVFs. At the top you can use the MVFs for Region, Work Category, and Work Type. This will filter...

Although lots of people avoid mvf for many reasons, the hidden table is properly normalized. It is either a junction table contraining the foreign key to the main table and a foreign key to a lookup table. Or it is a child table with the FK to the main table and the values.

Ahh, yes. The Rube Goldberg school of design. Always more fun. Why do simple when you can be complicated.

I think MS truly believes they are doing you a favor and making life easy. Goes along with allowing you to put spaces and characters in field names, every template using macros instead of vba, default properties and methods, and things like MVF. All things to make your life simpler in the short...

Something sounds very concerning. Unless you are building a commercial grade ERP I highly doubt this database is properly normalized with 450 tables. Correct me if I am wrong, but I really doubt it. Not trying to insult anyone here, but you are asking a somewhat trivial question but at the...

@June7 Your test is correct, but that is not what the OP is doing. As you said if you enter a time component only with no integer portion then when you click in the text box it will only show the time. However, for some Unexplained reason the OP is entering a date (integer) portion with an...

No, the reason that code was commented out was this is a copy from the cited risk database. So the code would have to be written for this DB, but the idea would be similar. However, the demo I did is to show a concept of locating things on an image and saving those locations. As demoed it does...

This question makes no sense. No only is it possible, but requires no code. Every form in a subform is an instance of that forms class. So of course you can have as many form instances as you want. So if you add four subform controls and they all have the same source object, it creates four...

See if this is of interest. You can look at that video on risks to see possible features you can add. I had multiple ways to filter the list. I did not add the filters, but I have a listbox on the left where you could turn on and off the display of different states. I set this up where you pick...

No this is very basic. It is only to show that you can give a sense of animation even though there is really no animation. There are 48 hidden lines The table has the x,y position of each capital You pass a hidden line to the function and what cities to connect. Each city is in the table and...

To see some animation in access, here are some Heuristic solutions to the Traveling Salesman problem. You can watch the solutions unfold. 1. Add all the capitals to your selected cities in yellow 2. These are improving algorithms so you can start with Closest neighbor, then 2 opt Swap, then 3...

In my method this would take about 5 minutes. Just drag the label into position and it will save it to the correct location to the table. Now you just read the table to move to that state. Once you drag them once you know the label position for each state. For the checkboxes I would just put...

I have all the code to do this. If you send me a map you want to use. I can code all the labels faster then I can explain the code. It would generate the 50 labels. You then drag them one time into position and they would be saved dynamically. If you want to see a demo of this. To see a demo...

Store the X and Y position in a table. I will post an example allows drag and drop of the lables.

However, that test is for a local table. I cannot test SQL backend to see if it works differently. But what is confusing is how MS describes a filter "Since the view you get after you apply a filter contains only records with the values that you selected, the rest of the data remains hidden...

Maybe I am missing something, but this seems like a very simple test. 1. Open a continuous form to a single filtered record 2. While the form is open go into the table and modify, delete, or add some records 3. remove the filter All changes show, so would it not have to re-pull the data?

Do an aggregate query (group by employee and shiftdate) maybe add where count > 1. Then if there is any record in this query for an employee and shift date you can do conditional formatting. Then I would build a function Public FunctionHasDupe(empID as long, ShiftDate as date) as boolean...

Here is a pretty functional Wardrobe Builder. Allows you to pull from the parts list and make any wardrobe composed of those parts. Basically I just added a couple of details to the generic Assemblies Sub Assembiles (Bill of Materials DB) 1. Create a Wardrobe by hitting the Create New BOM...

You are begging for problems with name schema like that. Never put spaces in a name, but for sure never put a space in a name with something like "And " or "Or" DD_or_RTGS_NO is fine. Readable. SELECT [master data].[dd or receipt no], [master data].[material supply date]...

I do not. Everything is a component and goes into a single self referencing table. If that component is an assembly then it has related children. But I never build a separate table for components. You can but it only complicates the data structure.