Sales Order (SO) Screen Challenge

Your accounting manager comes to you with a problem. Being the stellar M2M Professional that you are, you immediately don your cape and tights. What? You don’t wear tights? Umm.. me neither… really…

Anyway, she explains to you that the terms, which are dictated by accounting, are being changed by […]

Comments – Another Pet Peeve of Mine

While I fully understand why different programming languages use different syntax, wouldn’t it be nice if they could at least agree on a comment structure?

I can’t tell you how many times I’ve typed something like this into the VBA studio:

— Make sure to declare the recordset

Code Here


Comments here


And of course it fails because […]

I can do Magic

Any sufficiently advanced technology is indistinguishable from magic. – Arthur Clark

One of the factors which draws me to programming, and especially database programming, is that most people cannot understand it. To most people, computers, networks, and the internet etc quite simply work by magic. They know how to turn it on, and […]

Sometimes I Just Shake My Head – Security Problem

At times I have discussed security on this blog and mentioned the challenges of being secure when using M2M. However, this post has nothing to do with Consona.

I read several blogs on a regular basis for programming and SQL information. In fact, I think I’ll list the blogs I recommend in […]

Cycle Counting Revisted

In a previous article, I mentioned the inadequacy of Made2Manage cycle counting in that you cannot track your cycle counts over time and make that data available to your users. Well, true to my word, I have created the following customization so that you can do just that. Now would be a good […]

Using M2M with SQL Server 2008 – Quickie

I just wanted to let everyone know that I’ve been testing Made2Manage version 5.6 for several weeks with SQL Server 2008 without incident. That includes FastForms and VBA as well.

I’m sure M2M will tell you that they don’t support doing so, but it’s working fine for me.

Any of you out […]

You’ve Just Taken Your First Step Into a Larger World

I love learning new things.

I couldn’t help but in a small way feel like Luke Skywalker when he first felt the force. I’ve been trying to get access to a SQL 2008 Server for the longest time, and it’s finally happened. I wrote and published my first SQL […]

Just Shut Up and Reboot Already

Resist the temptation.

I’ve always enjoyed Think Geek and all the nerdy goodness for sale on their site. They have all sorts of t-shirts with Geeky messages.

Over the years, I have been directed several times by Made2Manage Support to do just that, to re-boot my SQL Server for various reasons. […]

Reality Check. Which SQL Server Version are you Using?

I spoke with someone earlier this week who is already using Version 2008 and that started me wondering what versions my readers (both of you lol) are using.

If you’re not using at least 2005, feel free to comment as to why not?

Which SQL Version are […]

MySQL – Yeah, I was wrong.

Years ago, I asked one of M2M’s senior technicians why they didn’t simply use a free database system such as MySQL. The reason being that Microsoft’s SQL licensing fees prohibit many of Made2Manage’s customers from migrating. Therefore I reasoned that if M2M had chosen MySQL instead, then by this time nearly everyone would […]