MajP's latest activity

  • MajP
    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
    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
    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...
    • MVF.png
  • MajP
    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
    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.
    • SN_goldberg_home.jpg
  • MajP
    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...
  • MajP
    MajP reacted to Gasman's post in the thread Clear out data with Like Like.
    @MajP Save your breath. You are just wasting it. It was said time and time again at UA and ignored. :( O/P will have as many forms as...
  • MajP
    MajP reacted to LarryE's post in the thread Clear out data with Like Like.
    I doubt that....LOL.
  • MajP
    MajP reacted to plog's post in the thread Clear out data with Like Like.
    Yeah, when building a house just slop some concrete in a hole, throw in some rebar and build on top of it. In a year or two--after...
  • MajP
    MajP reacted to June7's post in the thread Field to enter ONLY time. with Like Like.
    Did you mean "unexplained"?
  • MajP
    MajP replied to the thread Clear out data.
    Something sounds very concerning. Unless you are building a commercial grade ERP I highly doubt this database is properly normalized...
  • MajP
    MajP replied to the thread Field to enter ONLY time..
    @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...
  • MajP
    MajP replied to the thread Moving objects on form.
    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...
  • MajP
    MajP replied to the thread Instance of form as a sub-form?.
    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...
  • MajP
    MajP replied to the thread Moving objects on form.
    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...
    • Class1.png
    • class2.png
Back
Top Bottom