Archive for the ‘Uncategorized’ Category

New Article: Data Analysis with Microsoft Access

Thursday, September 2nd, 2010

 

Most of the articles I’ve written on Microsoft Access have been about designing database applications that are meant for regular use.  One of the strengths of Access, however, is its ability to import and link to data from different sources.  Excel does this too but with Access you can go on to query and report on the data in ways that Excel doesn’t readily provide.  This can come in handy as part of an application but it’s also useful for quick analysis of new information.  I found a new example of this the other day when I was looking over the website statistics for Drewslair.com …

Read more in -  “Crunching the Data:  Data Analysis with Microsoft Access

Looking for Beta Testers

Monday, July 5th, 2010

My latest project on Drewslair.com is JobSearch 2010, a program designed to help job seekers organize their searches and more effectively follow-up on opportunities. The program will enable users to gather information on job opportunities, companies, contacts and job search activities in one database where the information can be easily referenced and reported on. The program will feature user-friendly data entry as well as flexible search capabilities and reporting for individual leads and the search as a whole.

With this in mind, I am looking for beta testers who would be interested in evaluating the program both in terms of operation and usability. The ideal testers will fall into one or both of these groups:

  • Job seekers who are fielding multiple leads from different sources, preferably leads requiring multiple activities such as the sending of resumes, follow-up contacts and one or more interviews
  • Usability experts or people with software quality assurance experience

I’m not offering any compensation for testing this application or reporting issues although I do consider it an opportunity for professional networking with people who are willing and able to provide significant input into the design of the program. Once testing is complete and the program is available for download, those who participate in the testing and continue to use the program will receive full and preferential support. As the program is intended for the home user who is looking for work, the finished program will be offerred as a free download.

In order to run and test this program, you must have access to a personal computer on which you are authorized to install software and on which you can perform job search activities. The computer must have the following:

  • 512 MB of RAM
  • 3 GB free hard disk space
  • Windows XP Service Pack 2 or later

If you are interested in participating or would like more information, please contact me at acomeau@drewslair.com.

I can’t believe I forgot that …

Sunday, May 9th, 2010

Reviewing the Programming Microsoft Access series, I suddenly realized I’d written nothing about enumerations.  One of my favorite tools in VB and I completely forgot about it.  Of course, they weren’t even included in Access 97 VBA so I’ll just assume that had something to do with it …

I also found that I’d linked to the wrong demonstration database so I’m glad it occurred to me to run through the series again.  I’ll probably take the time to write up a couple of new chapters while I’m at it.

Sorting it all out …

Wednesday, April 28th, 2010

I wrote awhile back about how I used Outlook to keep track of things I’m working on and store reminders for project ideas that would be great to work on someday.  I’m still getting the hang of it but I’m a little closer.  The Outlook calendar is a great tool.  I hadn’t used it much before and remember a time when I didn’t see  the point because it wasn’t quite as portable as a paper planner.  I can’t seem to keep up a paper planner, though, and I pretty much start and end every day at the computer now so the Outlook calendar is handy for keeping myself on track, even when it comes to something as simple as remembering to do a daily review of where I stand on various projects or leads.

Right now, I have a few projects that I’m jumping between, including paid work and personal projects.  A few weeks ago, I started planning a series of articles on Windows application design before  I got sidetracked preparing for some upcoming work.  This sounds really geeky but I actually enjoyed coming up with a new format for a program specification and writing up the spec for a demonstration program to go with that series. 

Then there’s the time I spend in continuing study of programming subjects and software to keep the skills sharp.  Microsoft Office 2010 is on its way and Visual Studio 2010 was just released.  I’ve barely had the opportunity to work professionally with VS 2008 so I have a professional evaluation copy of that installed on a virtual machine and I’ve  been working through a lot of exercises from my earlier .NET training for comparison’s sake.  I thought about buying it for home use before it went off the market but finally decided the free express edition would be enough for my use as I already own VS 2005.   I might get the 2010 version eventually.  The beta of Office 2010 is installed on that same machine and I spent a little time looking over Access 2010 to see how it compared to the 2007 version.

I have a long list of other projects in the hopper if I ever finish the ones I’m working on now.  It includes notes to check  out development tools like Adobe Air and SharpDevelop or ideas for writing projects.  I’ve compared it before to my Amazon wish list.  It’s the place where I can keep a reference to anything that catches my attention.  In Amazon’s case, it saves me money and bookshelf space.  In the case of my project list, it lets me make a note of things and then move on with what I’m working on without forgetting some good ideas.

Of course, I’ll never get to any of them if I keep talking about it here so … back to work.

Latest developments …

Monday, March 15th, 2010

I took a little break from writing after getting the last batch of articles online and promptly came down with the flu which put me out of action for another few days.  Then I decided to catch up with some ASP.NET study but I’m realizing now that my daily schedule just doesn’t come together unless I’m producing something so I know I need to continue on the Programming Microsoft Access series.  There’s a future series on application design which feels like it would be really fun to do but is kind of scary at the same time.

I’ve also been working on updating my online profile and promoting my professional services, including Microsoft Access application rescue.  Writing articles is nice but it doesn’t come anywhere close to paying the bills at this point.  So if you like what you see here and on the site and you or someone you know needs some programming done, drop me a line and let me see how I can help.

The Value of Choice

Monday, February 22nd, 2010

(A former boss of mine once said that he knew he’d written something good when he could go back and look at it six weeks later and still like it.  There’s some merit and a problem or two there but the idea stuck with me.  I was looking through some of my site archives this week and found the files from a weekly column I tried to start on the site in 2004.  Here’s an abridged version of one from March 2004 that I particularly like.  It’s not perfect but it has a certain spark to it.)

I went to McDonalds for lunch with a couple of co-workers earlier this week.  I suggested they super-size it while they still can after the news report I saw not too long ago that McDonalds is getting rid of their super-size option.  Evidently, the recent bad publicity engineered by the Food Police concerning the effect of fast food on people unwilling to make better nutritional choices has the company a little nervous about its bottom line.  Fortunately, the frivolous lawsuits aimed at fast food last year by people blaming the restaurants for their obesity were thrown out.  Various states are now rushing to pass legislation banning similar suits but bad publicity still costs money and Mickey D’s probably figures that people will be just as willing to buy larger selections separately when deprived of the convenient Feed Bag Value Option.

I didn’t super-size it myself although one of my co-workers did.  I guess I wasn’t feeling overly devout during this visit to the Church of the Golden Arches so I just ordered the large size of the Big Mac meal.  My doctor’s devotions, on the other hand, involve him charging me large amounts of money for a few minutes of lecture time about my weight so I feel obligated to give him something to complain about.  I can’t really explain the economics or logic involved in that transaction but it does result in me being able to eat Big Macs so I just accept it and chow down.  I swear those Big Macs used to be bigger.

I am well aware, as every other person with two brain cells to rub together should be, that McDonalds is an occasional treat rather than a daily solution.  Despite my relatively poor eating habits and the above bit of satire, I cannot tolerate a continuous diet of fast food as some people can.  I am also aware that the nutritional mischief I get into has its eventual consequences.  As a friend of mine once said, very simply; “We make our choices.”  Unlike those who choose the route of litigation and media-sponsored intimidation, I accept responsibility for mine.  If I add a dessert to a meal at my favorite restaurant or lounge on the couch eating Doritos in front of the TV, the choices involved are mine and mine alone.  The server at the restaurant, the store that sold me the Doritos, even the people who advertise the food bear absolutely no responsibility for the actions that I take of my own free will.

Unfortunately, it seems that more and more people in this society are unwilling to accept this responsibility or understand the concepts of free will and choice.  As I indicated in last week’s column, the freedom to make the wrong choices is vital to a person’s actual ability to make the right ones.  This is not as heretical as it may sound.  It simply means that when you act as the law or circumstance compels you to, it is not virtuous or moral beyond the obedience to the law.  When you make the correct choices independent of any law because your conscience and intellect require you to, that is true integrity. 

The mark of an intelligent and moral person is the ability to regulate their own behavior according to their beliefs in the absence of external restrictions.  In a larger sense, the fewer laws that a society passes which require the government to act as a parent, the healthier the society will be as its inhabitants are required to think like mature adults and take responsibility for their own behavior. The inability to grasp this seems to cross political lines as both conservatives and liberals demand that the government rule on their respective issues.  The mentality behind these demands not only limits the opportunity for people to be responsible for themselves but also takes a certain elitist and patronizing view toward the people it claims to protect. 

The lawsuits against the tobacco companies may have at least had some merit, the hypocrisy of a government that had been profiting from tobacco taxes for years notwithstanding.  Tobacco, after all, is an addictive product and there was evidence that the companies had manipulated the levels of nicotine.  Then we had the lawsuits against the gun manufacturers on the basis that they were somehow responsible for the crimes committed with their product.  Is anyone for suing makers of baseball bats?  How about Ginsu??  You can create a lot of mayhem with a knife that can cut through an aluminum can and still slice a tomato. 

I’m just waiting for the first lawsuit against a media company by someone claiming various consequences of emotional distress caused by a perceived bias in that company’s publications.  I suppose we might as well limit free speech while we’re at it.  That freedom of thought business is a dangerous thing.

Almost there …

Friday, February 12th, 2010

I’m managing to get my fingers to keep working despite the latest cold snaps and have finished the first draft of “Programming Microsoft Access”, the series on Visual Basic for Applications that I’ve been working on for the last couple weeks.  Now I’m going through the chapters and revising as needed.  It’s amazing what you find when you step back and look at the material from an editorial standpoint rather than the writer.  So far, I’ve changed some examples, switched around a couple of chapters and found some typos and errors that would not have looked good on the site.  Basically, I’m trying to take my own advice from the chapter on algorithms:

“Throw everything you can at your code and try every way you can imagine to break it.  I know it’s tedious and it looks like it works so why tempt fate, right?  Trust me; finding a bug in your code and fixing it before it goes to the customer can feel a bit like having someone shoot at you and miss but it’s better than what you feel when the customer finds the bug.”

Living in Outlook

Tuesday, February 9th, 2010

In my last post, I included the outline for the series on Access VBA that I’m writing.  Of course, an outline is just that – a rough summary of what the finished project should look like.  It can’t be carved in stone.   

So while I’m working on the chapters for decision loops, I realize that I don’t have anything in the series about using arrays to store information which is probably because I rarely use them myself.  I reviewed a couple of other books to get some ideas about what to include in the series but in the end we do look at things based on our own experience.  That’s one more chapter to add.  I’m getting there.   The hardest thing for me is coming up with the different examples to illustrate some of the ideas. 



Trying to fit my life into Microsoft Outlook ...It’s ironic but after all these years I’m finally understanding the value of keeping To Do lists.  About every other year on average, I buy a yearly planner with the idea of being more organized and within a few weeks it ends up sitting on a shelf somewhere because I just can’t get into the habit of using it.  Meanwhile I’ve had all these ideas for projects I’d like to do that never went anywhere because I got distracted by something else and forgot about them.  Now I have a giant folder in Outlook that’s growing at least one new branch every week with various details of the stuff I’m working on. 

I have one task list called “Archive” which has two subfolders under it; “Completed” and “Project Ideas”.  The Project Ideas list is a bit like my Amazon.com Wish List (BTW, Amazon, thank you so much for that feature.)  It’s all the projects that have sounded interesting over the months and that I’d like to try sometime but haven’t gotten around to yet.  It includes such things as ideas for new site articles, certifications that would be nice to have and software I’d like to evaluate.  Keeping them there keeps them from cluttering my Current Projects list and lets me actually get something done rather than drowning in all the possibilities.  Outlook also lets me prioritize items so that I can know what’s important and what’s just a cool idea. 

Then I have my Project Task List and Project Journal where I keep notes on specific things I need to do and what I’ve done each day respectively.  It’s a new habit but I’m working on keeping it going.  There’s also the Resources section where I keep lists of websites and other items that I can use for different projects. 

Now if I can just move a few more projects over to the Completed list.

A few thoughts at 3 a.m.

Saturday, February 6th, 2010

I’m plowing my way through writing the next chapter of the Microsoft Access for Beginners series and have the insomnia to show for it.  This chapter, an introduction to Visual Basic for Applications, is one I’ve been wanting to do for awhile and should have done a long time ago but always found a way to put off.  Writing chapters on the basics of forms and reports was easy compared to introducing the reader to a programming language with an entirely different environment from Access, an event-driven paradigm, variables, decision loops and all the other fun stuff that does questionable things to a person’s brain over years of exposure.

The other chapters have been rather large for web articles and the subject of this one is so much more complex that I’ve broken it up into sections to avoid sending the readers into shock.  So far, the sections are lining up like this -

  1. Introduction – An explanation of the purpose of VBA and event-driven programming.
  2. Environment – An explanation of the programming environment and its elements.
  3. Procedures – Methods, functions and custom properties.
  4. Variables – Declaring and using variables to hold values for use in the program.
  5. Operators – Symbols used to carry out mathematical, comparison and other operations in VBA.
  6. DoCmd – I felt the DoCmd object which provides a variety of shortcut methods deserved its own section.
  7. Control Statements (multiple sections) – Decision loops and structures including IF…THEN, SELECT CASE and WHILE … LOOP.
  8. Algorithms – Once the syntax is understood, it’s time to learn how to design an actual procedure.  Determining the path for getting the right results.

That’s not the end of it but after the section on algorithms, I’ll put it all together and consider Version 1.0 of the series ready for upload.  Otherwise, it might take another few years.  Future (near future, I promise) sections will include material on:

  • Classes / Object-Oriented Programming
  • Best Practices including commenting and error handling
  • Debugging
  • Getting Help

So, why am I doing this?  All this work for a series of tutorials on a relatively obscure personal website?  There’s probably a touch of OCD involved but it also has to do with the e-mails I’ve been grateful to receive over the years from people who’ve benefited from the series.  I hope I’ve helped save some data along the way.  It also keeps my brain active, my skills sharp, my credentials as a writer somewhat defensible and my resume polished.  In the end, I figure everybody wins …

… or at least nobody gets hurt.

Stay tuned …

PDFCreator

Wednesday, February 3rd, 2010

PDFCreator is an free tool from PDFForge.org for creating PDF files from Windows applications. The installation adds a printer to windows which accepts the output from Word and other programs and outputs PDF files. It has a great autosave feature which will automatically save the files to the folder of your choice with a datestamp filename so you don’t have to name every one if you’re doing a lot of printing.

You can find the program and more details at http://www.pdfforge.org/products/pdfcreator.