Archives

Changing the Ship To Address and Ship Dates via VBA.

Over the years, one of the issues I’ve repeatedly encountered is the wasted time in changing Ship To Addresses and Ship Dates for multiple line item orders. My last employer made a product commonly sold with new building construction projects. Therefore, they often did not have a Ship To Address because the building […]

Choosing a Made2Manage Consultant

The Bobs – Office Space

As I mentioned in my first post I’ve been working as a Made2Manage Administrator for more than 10 years. However, even if you’ve been one of my regular readers, you may not be aware that I’ve also been an independent consultant for the last several years as […]

Answers are Easy, the Questions are Hard.

In the past year I’ve been doing a lot of T-SQL (Transact-SQL) programming. My current employer has required a great deal of it, and I have searched out several people and places on the internet to gain this knowledge.

However, as I’ve progressed on this journey I’ve noticed a curious thing. The […]

Please Santa, Can I Have an Error Log in a SQL Table for Christmas.

A Christmas Story

At the time of this writing, the M2M error log is still being kept in a text file, not surprisingly called error.log. I understand that this is probably the most expedient way for M2M to capture it. I suspect it’s a lot easier code-wise to simply append […]

Having “Fun” With Job Order Numbers

I recently received a call from a company that had “run out” of internal job order numbers.

As an error message, this one is fairly descriptive. However, 9 times out 10 the person who receives it won’t have permissions to modify the numbering system anyway. Some research on M2MExpert […]

SQL DBA Quiz – I’ll Play Your Game, You Rogue.

Today I was tagged by SQL Ninja Brent Ozar after he was tagged by Chris Shaw for this brief SQL DBA Quiz. His quiz requests that I name two mistakes I’ve made in my career. As someone who celebrates his mistakes, of course I will have to oblige. The title of my post, is […]

Some are born geeks, some achieve geekiness, and some have geekiness thrust upon them….

I like to think of myself as an alpha geek. Geekiness is something to be respected, enjoyed, and promoted. Let me share some of my “geek cred” with you.

For example I….

Learned BASIC on a Radio Shack TRS80 Model 3 and I still have 5.25″ floppies which contain my early programming efforts.
Have […]

Dark Helmet’s Approach to Project Management.

Spaceballs, the classic film co-written, directed by, and starring Mel Brooks, is one of my favorite of all time. It has a star-studded cast, makes fun of a film genre that is near and dear to my heart, and has so many memorable moments and soundbites. Anyway, I watched it again the […]

Resorting M2M List Boxes

Recently I came across the following problem: A company I assist had over 100 different shipping options in Made2Manage. You might question why a company would have that many shipping options, but when you consider there are many different options for a single carrier, they add up. For example here are a […]

Code is never finished, only abandoned.

I enjoy reading a little bit right before bed, and I’m a big fan of Uncle John’s Bathroom Readers. Where else can you read short articles about Star Wars trivia, how the invention of currency came about, and the famous hoaxes of the last century all in one sitting?

Anyway, I found […]