Recent content by Pat Hartman

JCL was the nemesis of all new programmers. The COBOL class only covered it at a very high level so we always just copied and changed names. A little background before my most embarrassing moment as a newbee. A Nine track tape included a plastic ring with a small tab on it. They were about...

Good reason to build strings into variables so you can look at what your code has wrought;)

are you sure it is not "#date#" so the # are inside a string rather than delimiting it? Build the string in a variable so you can see what is being passed.

Dates need to be encased in # Me.BloodPressure = DMin("Systolic", "tblPressure", "DateValue(PressureDateTime) = #" & Format(Me.HealthDate, "strcJetDate") & "#")

The left insists on judging people of the past with the mores of today. That is not fair, not that the left has any understanding of the word. The people who sent Columbus to the west to discover the Americas were responsible for the Spanish Inquisition. That was one of the most evil times...

It is confusing to me and I know how this works. Not a good video. Too monotone. Too many filler ums. Too much not relevant information. Five minutes would be better for this topic.

Maybe it's worth a few hundred bucks to hire someone to spend two hours with you to create an outline that you can then flesh out. You seem to be flailing around and getting nowhere as evidenced by the post count. Explaining to professional who is used to making sense out of chaos will help...

Please stop with the random criticisms of everyone with whom you disagree. If you have a specific argument to make, make it. Otherwise, stay out of the conversation. You are really beginning to annoy people.

If you only ever add one row at a time, then sorting after it is added to pop it to the top would be fine. However, this would be very disconcerting if the users typically enter several items at one sitting.

Absolutely terrifying. Canada just had a chance to get out from under the libs but failed to take it so they are continuing on the road to giving up all their freedom.

I haven't worked with one of my queries with the complex selection criteria using Monaco. I'll try to find one of the problem queries to see what happens. But, the QBE would format them so that it was logically easier for the QBE to display the OR's in the way they wanted them graphically, one...

I'm confused. If you are not the primary/only developer, how do you intend to refactor anything without the permission of the primary developer? It is one thing if you have only yourself to worry about and I do understand the issue with continually working with something you don't understand...

Plus using data type as the prefix is very old school and unless you will be religious about changing the variable name should you change the data type - DO NOT USE THIS TECHNIQUE. PERIOD. Documentation that is wrong is far worse than no documentation at all. AND in this context, all the...

Are you questioning anything I said or just making a disparaging comment because I spoke? It's like the old joke -- If a man is alone in the forest and says something, is it stupid? If you have a specific criticism, I'd love to hear it. Otherwise this comment like many of your others is...

And next week, you'll have more. Access has built in tools that will help with some things but not all and once you've split the database into FE and BE, they are not useful at all for this particular task since changing a column name on a table in the BE has no impact on anything in the FE...