David Stein

Subscribe

New Year’s Resolutions

Calvin and Hobbes

As this is primarily a professional blog, I will not blather on about resolutions to eat less and exercise more in the new year, though I certainly intend to do those things.

This article is about the professional resolutions for improvement that I intend to make in the new year [...]

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 [...]

Accessing the M2M Database Using VBA.

A couple of weeks ago, someone sent me some VBA code which was giving them fits. I often receive requests like this and am glad to help when I can. I came across this bit of code:

Private Function fConn() As ADODB.Connection
Dim oCn As New ADODB.Connection
Dim sCnStr As String
sCnStr =”uid=sa;pwd=HisPassword;” [...]

Merry Christmas Everyone

I just wanted to take a moment to wish you folks a Merry Christmas and thank you for reading my ramblings.

As an adult I have to buy my own presents, so this year I bought a few things that interested me.

I bought a couple of these:

Star [...]

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 [...]

Data Utilities – Convenience or Crutch?

Recently I’ve been assisting a company with discrepancies in inventory master and inventory on hand tables. One problem is negative quantities in their inspection which can’t be removed, and they also have problems with inconsistencies in their on hand quantities of various parts.

So, a user brings the Material Availability (RPMAVL) and the [...]

M2M Releases Version 5.6 SP3…. umm..6 weeks ago.

Let me preface this by saying that very few M2M Admins are more active than myself. I am on M2M Expert nearly every day. I found out that SP3 was released through the Los Angeles Area Made2Manage User Group on Google Groups.

Am I the only one who didn’t know SP3 was released? [...]

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 [...]

It's Beginning to Look a lot Like Christmas

I’ve always loved Christmas Lights, but some people go overboard.

M2M can’t be decorated like that, but you can add a touch of holiday spirit. Follow the directions below and you can have your active cell indicator switch daily from green to red, the colors of Christmas.

Page 1 of 212