MajP's latest activity
-
MajP replied to the thread subforms and forms.If I provided assistance, I do not remember. However you can simplify the function a little. Public Function getParentForm(callingCtl... -
MajP replied to the thread Solved Unkown Cls/Collection Holding An Event.The before and after the collection is irrelevant. The inside and outside the loop is. Think of decorating Christmas Cookies, where you...
-
MajP replied to the thread Clear out data.Oh I see. You simply need one of the many available applications with the following 1. low code, no code application 2. supports...
-
MajP replied to the thread Solved Unkown Cls/Collection Holding An Event.I see it now Private Sub Form_Load() Dim ctrl As Control Set mColRcControls = New Collection For Each ctrl In...
-
MajP replied to the thread Solved Unkown Cls/Collection Holding An Event.First look that looks correct. I will test in mine to see if I am not seeing something.
-
MajP replied to the thread Clear out data.I am not sure if normalization is really the problem as much as consolidation if that is a term. For example you commonly see people...
-
MajP replied to the thread Clear out data.You kind of missed the point. The relationship diagram is invaluable if you use it to enforce referential integrity. It has very...
-
MajP replied to the thread Solved How to quickly duplicate Tables & associated subforms within a main form.OMG! There is no teaching anybody anything. There is nothing for the user to do. You just set the rowsource of your different lists...
-
MajP replied to the thread Clear out data.FYI, you do not have a relationship diagram, you have an image of default query joins. There is no referential integrity enforced on...
-
-
MajP replied to the thread Solved How to quickly duplicate Tables & associated subforms within a main form.Access has this cool thing called queries. You should give them a try. "Select * from tblSymptoms where condition = 'diabetes'"...
-
MajP replied to the thread Clear out data.If the references tables are not editable and you manage what goes in the lists, then the reference tables could stay in the front end...
-
MajP replied to the thread Clear out data.You can send email, snail mail, or use another file sharing app if you like.
-
MajP replied to the thread Clear out data.Not everyone needs a split db, but your specific scenario warrants it (almost. If the tables were settled). 1. You absolutely need to...
-
MajP replied to the thread Solved How to quickly duplicate Tables & associated subforms within a main form.Then it is perfect to move them all into a single lookup table. Way easier to manager.
-
MajP replied to the thread Clear out data.In the mean time you can simply delete out all the data and send me the empty db. I can at least see the forms and proposed tables...
