Search results

The only way you can have that many forms is that most of these forms are all doing the same thing. Maybe a different sort order, or filter, or visible controls etc. That is why I can rebuild this application with 20 different forms and modify them at runtime. If OP says they are not are all...

Already provided you the demo along with a video presentation on how to do this. https://www.access-programmers.co.uk/forums/threads/form-design-to-allow-multiple-selections-add-your-ideas.334421/ There is a listbox, textbox, and combobox control designed for MVF. The checkboxes appear in the...

The part you do not get is that I guarantee I could take your database and keep all the current functionality and provide way more capability and do it with probably 20 forms, 20 tables, and 10 reports. Just a tad easier to maintain.

Obviously you can do that. That is what people have been doing for years. But that does not give the feel of the MVF combo. The idea was to give you some of the function of an MVF control. Expandable working on the combobox down arrow, checkboxes, ability to close the list. In my case in...

Why not expand on the idea I did. It does all that. Shows the concatenated values, relatively easy to reuse and reconfigure, stores the data in a standard table. No hidden things. Just needs some work to position where you want it so it is sized and appears below the combo. With some more...

Or if you want to trap the event in the class then trap it in the class. You show withevents, but you do not trap the event in the class. You would add it like this in your class. Private Sub mObjTxtBox_MouseUp(Button As Integer, Shift As Integer, X As Single, Y As Single) End Sub I hate to...

There is no benefit in splitting the database. If the tables are changing all the time, what would you gain? How will that simplify anything?

But unless there is more to it, there is no need for the class. Why not this on the form load event. dim ctrl as access.control for each ctrl in me.controls if ctr.tag "HRC" then ctrl.onMouseUp = "=handleRightClickOnBillAndPageF()" end if next ctrl

Also this is wrong Private WithEvents mObjTxtBox As TextBox Private mColCtrlsRc As collection Private Sub Class_Initialize() Set mColCtrlsRc = New collection End Sub Public Sub fInit(lCtrl As Control) Set mObjTxtBox = lCtrl mObjTxtBox.OnMouseUp = "=handleRightClickOnBillAndPageF()"...

Double check that you do not have a mouse up event in the form itself. In the mouse up event check that you do not have [Event Procedure] or " = someFunction()" When I look at your code I can almost guarantee that is the issue =handleRightClickOnBillAndPageF() You ran the code and it hung...

Yes in your world you could never get any benefit of splitting the db so you are correct there is no need to do so. In everyone else's world they can. In a real db there comes a time were the tables are 98% locked down for changes. You know what data you plan to capture. Now the FE will...

It would be funny if we are all just being trolled. That seems way more likely than this is real.

Wow. That is completely unrelated. The only thing I can guess is you have no idea of what it means to split a database, because whatever you said has no relation to if a database is split or not. @Isaac I said the same thing, but it is truly like driving up to the horrible car accident on the...

@dalski, I think you need to explain the problem and how the problem manifests. We can suggests ways to error check or track it down. I do not think your troubleshooting is focusing on the correct approach. Especially hoping to determine which objects are held in memory. For example when you...

Are you suggesting that you named a collection "A" and added objects to it. Then you changed the name to "B". You think there are phantom objects floating around in "A". That is not a thing. Does not work that way. My only guess is what you think is going on is not what is really happening...

Maybe I am missing something in the explanation but it does not seem to hard. 1. Search for Collection and find all of the collections you declare. write them down if you have to 2. Now search each one for the add method. If you have a collection "someCollection" search for "somecollection.add"...

@DakotaRidge, I think you have a misconception of the complexity of doing this. This is truly a very, very simple thing to do. Once explained how to do it, it should not require you more than 60 seconds of work. Now what you may want to incorporate is some relinking functionality. There is...

Could you simply do a "find" in vba searching for "collection" i.e. dim Something as Collection You will then find all the collections you declared in code.

You are probably going to have to provide more info. I cannot follow what you are asking. Maybe an example would help. Not sure if this is what you are asking but I will take a guess. When I build a custom collection class to hold instances I usually put a property in there called ToString. I...

@isladogs IMO, I think your example is more an exception vice the norm. The wizard only allows you to choose which field to bind if you display more than 1 field in the pulldown, but does not if you show only 1 column. So i am going to guess that the vast majority of the time the user does not...