Follow Us

Recursive Functions and Microsoft Minesweeper

Recursive Functions

There are quite a few tutorials on the web about recursive functions - I've even posted one myself - that use the old standby Factorial of 5 explanation. It's a great example and illustrates the concept very well.

OK, fine, so we can use recursive functions to do factorials, but there are calculators and pre-written functions that handle that, so why do I need to understand recursion?

Minesweeper opening grid

Opening game


Minesweeper after clicking a square

After first move

What might help is another less common real-world example. Let's take a look at Microsoft's® standby game, Minesweeper®. It's a game that most people are at least somewhat familiar with. This quick tutorial will hopefully help you see how recursion works in the code behind this great little game.

Minesweeper starts it's beginner game with a 9x9 grid of squares. When the user clicks on the center square (red "X"), the program must look at all 8 adjacent squares (in yellow) and determine how many mines surround that square. It happens that no matter where you click first, the eight surrounding squares will not contain mines. It's just the way the game is programmed. Live with it. However, many of those squares may have one or more mines surrounding them. Now we begin to get recursive...

Here's how it works:

The eight squares surrounding the red "X" each have squares surrounding them. Each one of them must be examined in turn to see how many mines surround them. In the case of our example, the square directly below the red "X" had zero mines surrounding it. Now the program must check each of the squares surrounding that square.

So... first we must have a function that checks surrounding squares for mines. It could happen that one of the squares we're checking needs to have its surrounding squares checked for mines. The same function that checks adjacent squares for mines needs to include a function call to check adjacent squares for mines - it may need to call itself.

The code is a bit more involved than what we can go into in a short blog, but here is a recap of the concept:

If one started on the square with the black dot, coordinates (5,3) in an (x,y) grid, one would need to check square (4,2) to see if it's a bomb. If it isn't, one would need to see how many bombs surround (4,2), so the program would call itself with new coordinates. This time, the program would check (3,1) to see if it's a bomb. If it isn't, the program would need to see how many bombs surround (3,1), so the program would call itself with new coordinates to check (2,1) to see if it's a bomb. If it IS, it would increment the counter in the stack iteration for (3,1) and move to (4,1) to check to see if it's a bomb. Once all the squares surrounding (3,1) have been checked and all the bombs surrounding it accounted for, we can return a value to the stack iteration for (4,2) and move on to (5,2) which is directly above the black dot and start the whole process over again.

Yes, it's more complex than that, really. A lot of head-scratching went into programming MineSweeper, simple game though it is. It still makes for a good example of how Recursive Functions work and what they can be used for besides finding factorials.

College Funding Services

There are shameless plugs and there are valuable tips. This blog constitutes a little of both because although I do stand to profit from the success of the company I am featuring today, I also firmly believe that the services they offer are extremely valuable, especially if you have a child that is preparing to enter the phenomenally expensive world of secondary education.

Are you getting all the college money you are eligible for?

The odds are strongly against it, regardless of how deeply you’ve researched the subject. The fact is, the best ways to get money for college are not broadly publicized. In fact, they are rarely published in any format at all. It’s not that college funding consultants and high school college counselors are not honest, hard-working professionals. Rather, it’s that they are generally under-informed. (There is, of course, a healthy proportion of them that are less than ethical in their practices and offer things that they can deliver, but that are not worth what you pay for them). Many simply do not know how to help you position yourself for the most financial aid possible.

That is the job of Simple Solutions College Funding – http://simplesolutionscollegefunding.com. Wayne Hamrick has been a financial consultant for 35+ years and understands intimately the best ways to get the most bang for your buck. He has partnered with the College Planning Network, a N.A.C.F.A. approved organization with a pristine BBB history of helping parents and students prepare for college, both financially and academically. The synergy of this union is obvious – the wisdom of a seasoned financial planning professional coupled with a network of experienced and knowledgeable college prep experts results in a dynamic relationship that can save you thousands – and more likely tens of thousands – of dollars over the course of your child’s higher education experience.

You can learn more by visiting his website at http://SimpleSolutionsCollegeFunding.com or by calling Wayne directly at 858-753-1902. It will result in a free consultation that could save you a boatload of cash…

External References for MS Access

It is not uncommon for more than one MS Access database to be used in a single workplace. I have several that I use in my own business as an Access and Web developer. When I develop a new database, I hate re-writing or even copying and pasting all the simple functions that I use all the time - functions I have written to make my life easier such as Replicate(), VBIn(), VBBetween() and ErrMsg() that I use in nearly every database I create. It becomes even more irritating to copy and paste the not-so-simple ones that require importing entire modules of code, API declarations, and global variables.

What I have done instead is create a database with all these functions already in it, then make a reference to it using the Tools==>References dialog in the VBA Project window. I just click the Browse… button and navigate to the location where I have my Functions.accdb database and click OK. Done! All my functions are now ready to use in my new database.

A tip for when your database won’t compile is to check those references. Especially when you use Office automation (integration with Word or Outlook), references to functions in those project libraries can be useful, but links can also get confused – especially if you move your application to another computer. Open the dialog and look for any x’s next to your available references. If your application breaks when moving to a different computer, the referenced library may be in a different location. For example, if you moved from a system with a 32-bit Office installation to another with a 64-bit Office installation, the files would not be properly referenced.

CSS3 Introduction

There is always a need for learning new tricks, and with the Internet and the Web, there is never a dirth of new information.  CSS3 has been around awhile, but since not all browsers support the features yet, it has become a hit-and-miss proposition as to whether the new tricks will work.  This makes it supremely difficult for developers whose project managers or clients want the new features, but also demand backwards compatibility. At some point you just want to throw up your hands in frustration and say, "Get a new browser!!!" 

Unfortunately, although CSS3 adds a significant number of new features, it is still under development by the W3C, which means not all browsers support all the features, and some (most notably Microsoft IE6) support none of them.  To get the new CSS3 features in all their glory, you'll need to upgrade your browser to the newest version of whatever browser you're using, and if you're a Microsuck... er, Microsoft fan, you may just have to do without. 

A quick test for Firefox users:  if the following paragraph has a gradient border, your Firefox browser supports CSS3.  If not, you're due for an upgrade!  As of this writing, Chrome, Safari, Opera, and of course Microsuck... er, Microsoft do not support the border-colors (plural) feature.

This box should have a gently fading gray border on updated Mozilla Firefox browsers

Some of the most significant features of CSS3 are as follows:

  • Selectors
  • Box Model
  • Backgrounds and Borders
  • Text Effects
  • 2D/3D Transformations
  • Animations
  • Multiple Column Layout
  • User Interface

To learn more about CSS3 and how to implement it in your web design projects, visit http://www.w3schools.com/css3/css3_intro.asp

For a really interesting treatise on how to use CSS3 in lieu of JQuery for a cool slide-out panel, see this tutorial:

http://www.1stwebdesigner.com/tutorials/slide-out-panel-css3/?goback=%2Egde_1851900_news_145224950

HostGator Web Hosting
RoboForm: Learn more...