The Good Old Days With Multiplan

While rooting through my office supply closet today, I found several boxes of floppy disks. Some were unused, and other had programs or data on them. Do you have a supply of disks too? Ever use them?

None of my current computers even have a floppy drive, so it’s unlikely that I’ll ever use the disks again. But, I hang onto them, just in case a client calls, asking for a copy of work that I did for them in 1992.

Microsoft Multiplan

At the back of a box of program disks, I found this copy of Microsoft Multiplan.

multiplandisk

And if I ever have to reinstall the Multiplan program, the good news is that I have the manual too!

multiplanmanual

Multiplan didn’t have all the features that Excel has, but it’s too bad that they didn’t keep that Bar Graph number format.

multiplannumbers 

__________

Microsoft Arc Touch Mouse

Recently, I received a cool looking gift from Microsoft – a Microsoft Arc Touch Mouse. The mouse lies flat for storage, and you bend it, to snap it into shape, when you want to use it.

mouseflatbent

It has a very small transmitter, that sticks out about 1/2″ when plugged into the computer’s USB port. When you’re not using the transmitter, just put it on the front or back of the mouse, and it magically (or magnetically) sticks there.

Instead of a scroll wheel, there is a slider, and that feature was very easy to use.

Testing the Arc Touch Mouse

The mouse was easy to install and use – I just plugged in the transmitter, and it was ready to go. On my first try, I didn’t bend the mouse far enough (one click, instead of two), so it didn’t work. After checking the Getting Started guide, I gave the mouse another click and it fired up.

The mouse handled well, for the most part, but it was a little sticky when trying to do some fine work. Maybe it gets better when the mouse has been used a little longer, or the operator has more experience.

Back to My Old Mouse

I worked with the Arc Touch mouse for a couple of hours, but couldn’t get used to it, so I’ve put it away for now. It would be better suited to someone with larger hands than mine, I think.

In my hand it felt too wide, and I was always conscious of the edges of the mouse. For now, I’ll stick with my little Logitech M305, which is a better size for me.

image

Have You Tried It?

Have you used the Arc Touch mouse? Did you like it and stick with it?

___________

Hidden Form in Access Closes Unexpectedly

Today I solved a nagging problem with an Access database, so I’ll share the solution here, in case it helps someone else.

In an Access database that I built, there is a Login form, where the users select their name from a drop down list.

accesslogoform03

Then, when they click OK, the Login form is hidden, and a data entry form opens.

accesslogoform01

The Login form stays open in the background, and other forms and queries can hook into the ID for the selected user name.

Hidden Form Closes Automatically

Everything works well, except when I open the data entry form in design view, to make changes. Then, without warning, the Login form closes. The user ID isn’t available to any of the other forms, and I have to go back to the Login, and select a name again.

This is more of an annoyance than a serious problem, but I wanted to figure out why it was happening.

I put breakpoints all through the code, and stepped through, to find out when the Login form closed. Was there something in the code that was making it shut down?  Nothing turned up in the code, so I was left scratching my head.

The SubForm Did It

Finally, it dawned on me that the Login form and the Data Entry form both used the same subform – it holds the logo, at the top left.

accesslogoform04 

The Logo subform saves space in the database, because the image is only in there once. It also makes it easy to make global changes, if the logo or heading text changes.

When I opened the data entry form in Design View, the Logo subform was also in Design View.

accesslogoform02

The hidden Login form closed because it couldn’t show the Logo in form view, while the Logo was in Design View on another form.

Fixing the Problem

To solve the problem, I created a copy of the Logo form, and named it Logo2. On the Login Form, I changed the subform to Logo2. Now, there is no conflict when I open the Data Entry form in Design View, so the hidden Login form stays open.

Maybe this will help you, if you have Access forms that mysteriously close, without being told to.

__________

Spider Charts in the Wild

This week, Tushar Mehta posted about his Custom Radar Chart add-in on the Daily Dose of Excel blog. These are also known as Spider charts, and I’ve never created one, except as a demo in an Excel class, when someone asked about them. It probably looked like the one shown below, or the Excel 97 version of that.

radarchart02

Radar charts can be tough to interpret, and Excel chart expert, Jon Peltier, suggests several alternative chart types that you can use, instead of a radar chart.

Despite the controversy, I was surprise to find this radar chart / spider chart while wandering the streets today. It might not be an effective way to present data, but it does make a nice roof!

IMG_0729

____________

Problems With Blog Comment Spam

Help! Would you please try to add a comment here, and let me know if you have any problems?

[Update] Thanks for the help — things seem to be working better now.

Flooded With Comment Spam

Over on the Contextures Blog, I’ve been flooded with spam comments. The Akismet plugin catches some of the comments, and puts them into the Spam list. However, there is still a long list of comments in the Moderation queue every day.

Most of those Moderation comments are spam, but I don’t want to accidentally delete any of the valid comments. I appreciate it when someone takes the time to add a comment, and don’t want to lose those.

I accidentally deleted one of Dick Kusleika’s comments yesterday, because something in his comment was on the “banned words” list. No, not his name – I had blocked “SEO” because of all the spam on that topic, and Dick’s blog is dailydoseofexcel.com.  Oops!

So, it takes a while to check through them, approving the real comments, and trashing the rest (carefully!)

Growmap Anti Spam Plugin

Today I installed the Growmap Anti Spam Plugin, which might prevent some of those fake comments from being posted.

It adds a check box below the comment form, and the comment is not accepted unless you check that box. That sounds easy enough, but sometimes things don’t work exactly as expected.

If you add a comment here, and have any problems, please let me know. ddalgleish AT contextures.com

Thanks!

______

Girls in Technology

Last week, on a very snowy day, my sister, Nancy Nelson, drove to a nearby town, to do a presentation at an Electronics Day for grade 8 girls. One of the tech teachers at the school is trying to get young people interested in engineering and technology.

Nancy is an electrical engineer, and a professor at Conestoga College in Cambridge. Her program, that she talks about in the video, is “Integrated Telecommunication and Computer Technologies”.

The event was shown on the 6 o’clock news in London, and you can see Nancy in the video below. She starts talking around the 1:00 minute mark in the video.

At the end of the video, a couple of the girls are interviewed, and one seems interested in a technology career. The other girl has something more traditional in mind. I wonder if the split was really 50-50, or if the reporter looked for two girls with opposite views. Maybe they should all consider working with Excel!

_______

Excel Sized Wine Glass

After a long hard day in Excel, this wine glass might be just about the right size. Did they name it “XL” in honour of our favourite spreadsheet program?

In case you can’t read the box labels, that are behind the glasses, they say, “XL Wine Glass – holds a whole bottle of wine!”

P.S. I wasn’t sure what category to assign to this post, so I picked “Computer tips”. 😉

IMG_0397

_______________

Learn JavaScript Programming in a Year

Sure, you can program in Excel VBA, but what other programming languages do you know? Maybe VBA is enough, but if you’d like to expand a bit, there is a free course in JavaScript programming that I’m trying out.

The course is online and interactive, and they’ll send you an email each week, announcing the new lesson. You don’t have to register on the website, unless you want to track your progress as you go along.

Easy Steps

To get started, I did the mini-course, “Getting Started with Programming”.

So far, I like the lesson setup and interaction. You read a short instruction step, type something in the interactive box, and get immediate feedback. In the screenshot below, I’m in lesson 5 of the total 8 lessons.

I lost track of the time, but best guess is that it took about an hour to go through all the lessons. In the CodeYear course, you’ve got a week before the next lesson arrives, so you could spread it out over a few days. Maybe those lessons will be tougher than the lessons in this intro course.

codeyear03

You’re Not in Excel VBA Anymore

The course is just starting, but I’ve already learned a few key differences between JavaScript programming and Excel VBA programming.

  1. Variables are case sensitive. In Excel VBA, after you define a variable, you can type it in the code, and the case automatically corrects. I use that as a tool for catching misspellings. In JavaScript, that doesn’t happen.
  2. End with a semi-colon. At the end of each line of JavaScript code, you have to remember to type a semi-colon. Unless, of course, the semi-colon is on the next line, with a curly bracket. This might take me a while to remember!
  3. Arrays are enclosed in square brackets. In Excel, we use curly brackets instead.
  4. Three equal signs for “equal to”. In Excel VBA, it only requires one = to check if one value is equal to another.

This should be interesting! If you sign up too, you can let me know in the comments, and we can compare notes.

______________