Search results

See attached mvf search form. Thread 'MVF Technical Discussion and Uses (If you plan to Use Them)' https://www.access-programmers.co.uk/forums/threads/mvf-technical-discussion-and-uses-if-you-plan-to-use-them.334422/ Yes very doable, but other alternatives exist.

Conditional formatting can tend to treat anything like text. And vba will coerce comparisions into text on the right side. That would answer why "44.2" is greater than "230" So I would do the calculation in the query and return true or false in a calculated control. IsGreaterThan230: iif([do...

Not sure what to say. Either look at the demo or look at the very clear summary. One of four uses a subform.

I do not understand that question. On a main form you can have a an multiselect listbox and not in a subform. This demo shows that https://www.access-programmers.co.uk/forums/threads/form-design-to-allow-multiple-selections-add-your-ideas.334421/ Here is a listbox on the mainform showing...

As @Pat Hartman stated they do not want you messing with the table because in order to get the presentation of an MVF the hidden table needs to be very standard. The hidden table has specific field names and datatypes. If you alter this it could easily mess things up. I think they could of mad...

1. The MVF control maps to a normalized table, as I have repeatedly shown. Maybe you mean a visible table or a user defined table. 2. If they did make this "bound multi select listbox " the properties would be so complex that most users would have to use a wizard to figure it out. And even...

If that is what is happening then yes it is a memory leak. But from what I have seen, that is not what is going on in these things that you call memory leaks. More likely you create A and then you create B. Then you destroy A. The fact that B is still hanging around is not a memory leak that...

1. This is kind of Mark's whole point of this and the utility of his code and the reason for not using the OnAction. The on Action is a global call and can only find a public method in a standard module. It would be similar to going to the immediate window and typing that method in. It will...

I did look at this template to see if there was something worth using. https://www.microsoftaccessexpert.com/Microsoft-Access-Veterinarian-Appointment-Tracking-Database.aspx and although it is not super expensive I could build something better than that in 20 minutes. That looked pretty bad, at...

See example Set myBar = CommandBars("Custom") Set myControl = myBar.Controls _ .Add(Type:=msocontrolButton) With myControl .FaceId = 2 .OnAction = "MySub" End With myBar.Visible = True .OnAction = "MySub" not .OnAction = "=MySub()"

The OnAction command should be the name of a function that is public. = "dalskiHandle" not "=Me.dalskiHandle()"

Access is different than other VBA forms. When you open a form that is modal in Access it does not stop code execution in the calling form. The code keeps on running. Other VBA forms and languages modal usually stops code execution from where it was called. So that requery happens as soon as...

FYI. One form demos saving some data to text fields and the seond form is for the attachment fields. Make sure to open the attachment demo.

As for drag and drop, Chatty says it is possible using the attachment control. I did not find that to work. So I extended the code from the linked thread that uses an Active X control (that supports drag and drop). I used a listview, but there are others...

You should be able to simply do that by pulling down the file name. Not sure how you want to have the form look but it shows all file names for every record.

By in the same position does that mean all three forms appear on the main form in their own position or you display one of the three forms in the same (one position). If it is the former do as in post #7. If the Latter it is a matter of making on single subform control and then the buttons...

So maybe I was not clear. Delete the existing ones that you can see in nav pane but not relink utility. Then re-import and you should see in both places..

I guess try and relink them as if they do not exist. Chatty says the same

I am thinking the same thing, that you might have mistakenly imported the tables not linked them.

Probably one of the most important features when debugging code especially if building your own classes is here. Probably most people have break on unhandled errors set. 1. But if you have an error handler and you get the error message you may not know exactly where that code is failing...