Archives

Who's Using the Production Calendar?

M2M Calendar

I’ve eluded to a super secret (if I told you, I’d have to kill you) project that I’ve been working on a few times recently. This poll is a part of it. I’d really like to know how many of you folks are using the M2M Production Calendar (CALNDR) to track workdays, weekdays, […]

Updating a SQL Table From Another Table (Fixing Your Salesperson Admin Mistake)

The Problem

Yesterday I demonstrated how to use T-sql to update the Customer Table (SLCDPM) to avoid hours of manual labor. I mentioned that you should always make a backup of the table before running an update statement in case you’ve made an error.

One of my readers, Kim, astutely asked me how to use […]

Using T-SQL to Automatically Update M2M Tables

One of the primary values a good DBA brings a company is in automating tedious, time-consuming tasks. In my last article, I discussed the problems when adding a sales person to M2M. M2M’s standard procedure is to create a new sales person and manually re-assign every customer (over 700 of them) to the new sales […]

Salesperson Administration Problems

Recently we had a salesperson leave our company and they were subequently replaced. I was asked to add the new salesperson and to transfer all of the outgoing person’s accounts to the new guy.

So, I fired up the Salesperson (SLPN) screen and added the new salesperson. This was an internal promotion so I used the […]

What's in a Name?

In the past two weeks, I’ve had two separate people ask me the same question. They want to know how to decrypt the Utuser.dbf file so they can retrieve their user list from M2M.

While I won’t show you how to break M2M encryption, I will give you two simple ways to get your user […]

Always Make a Backup When Performing FastForms Customizations

As I’ve mentioned previously, I’ve been using FastForms for years and I have one basic rule that I never, ever break. I never make changes in FastForms with users in the system. M2M says you are safe to do so, but painful experience has shown me that this is unwise.

The problem is that the […]

Disaster Recovery Options for Small/Medium Sized Businesses

This is the second of a series of articles, regarding disaster recovery for the small/medium sized businesses which are the typical customers of Made2Manage. All of these articles will be at a high level with links to more in depth articles where you can read about all the gory details.

What are we trying to […]

Honey, I Shrunk my Project File

I’ve mentioned in the past how difficult M2M’s flavor of VBA is to use. One problem that I haven’t touched on is the problem of VBA file corruption.

M2M VBA File Corruption? What exactly are you talking about?

When I talk about the VBA file, I am referring to the M2VEvents.prj file. This is the […]

More Data Corruption Problems with M2M. Orphan Quote Records

Brief Summary – M2M orphans records in the Quote Master and Quote Items tables when the quotes are in the Cancelled status.

As I mentioned last week, I came across a problem with orphaned records in my addressing tables. Rather than address my orphaned record problems piecemeal, I decided to create a script to check […]

Another Visual Basic (VBA) Rant

Recently I got a call from another M2M Consultant who was attempting to install M2M on Windows 7. He simply could not get VBA to work. I asked him to run through the steps and I found his problem right away. He had made a mistake early in the process; I have made similar mistakes […]

Page 2 of 1612345...10...Last »