MajP's latest activity
-
MajP replied to the thread Solved Error 6 Overflow.Stop wasting your time and simply get rid of all API calls. It is highly unlikely that you need them to do anything. They are likely... -
MajP replied to the thread Sorry folks, Access World will not accept my posts.The following code clears all fields in all tables in the datbase that are identified as sensitive in the description field. If the...
-
MajP replied to the thread Sorry folks, Access World will not accept my posts.If I was going to do it for something this big, I would use the description field and mark all fields Now I would loop all tables...
-
-
MajP replied to the thread Sorry folks, Access World will not accept my posts.Unfortunately this takes some understanding of code. But you can get all the benefits of a MVF control and still normalize the data...
-
MajP replied to the thread Sorry folks, Access World will not accept my posts.I am with @DakotaRidge because the above is completely misleading. You cannot simply replace an MVF with a combo. You cannot replace a...
-
MajP replied to the thread Sorry folks, Access World will not accept my posts.I think there are two big differences where MVFs are fine and where you most likely will get into problems down stream. I call it a...
-
MajP replied to the thread Solved Error 6 Overflow.This is a good point and you inherited this you may want to do it different. Somewhere in your code at the top of a module you have a...
-
MajP replied to the thread Solved Error 6 Overflow.That means we need to see the rename code..
-
MajP replied to the thread Solved Error 6 Overflow.In addition to what has bee said, if I was trying to debug, my first step would be to add a debug.print to see if this loop is running...
-
MajP replied to the thread Solved Error 6 Overflow.Does this code break at a certain place? Personally, I would rewrite a lot of this thing. I would never be opening forms and reports in...
-
MajP replied to the thread Solved Error 6 Overflow.If you use the code tags it is easier to read for everyone. I did some indenting Public Function CreatePDF(Optional strCalling As...
-
MajP replied to the thread Clear out data.@isladogs has a good explanation https://isladogs.co.uk/multivalued-fields/index.html Also this demo shows a lot of functions that can...
-
-
MajP replied to the thread Clear out data.Although lots of people avoid mvf for many reasons, the hidden table is properly normalized. It is either a junction table contraining...
-
MajP replied to the thread Clear out data.Ahh, yes. The Rube Goldberg school of design. Always more fun. Why do simple when you can be complicated.
-
-
MajP replied to the thread Solved Option Explicit?.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...
