Access MVP (2010-2015)

oOo.oOo.oOo.oOo.oOo.oOo

Compile on Demand check or uncheck?

Recently, while trying to Debug some code a colleague of mine suggested I leave Compile on Demand1 unchecked. Since in all my years of developing I have always left it checked, I asked why and here’s what he said got…

Many years ago, Michael Kaplan mentioned that this setting was known to cause problems, […]

 1,475 total views

Adding *continued…* to a Multicolumn Report…

After seeing a post in a Forum asking about how to add the word *continued…* to a Multicolumn Report I thought it would be fun to create a sample database showing off the feature, to download click here (Access 2007 or above needed and an unzipping program. Images are not included!). And, of course, like […]

 1,363 total views

Combo Box to Find Records…

You want your Users to be able to look up and/or add new activities for existing Companies but they may not know or remember the Company Name but they do remember the person they speak to on a daily basis. Well, you don’t want to add a separate Combo Box for Company Name, First Name, […]

 855 total views

Navigate a Continuous Form like Excel…

Continuous forms allow you to display data resembling an Excel spreadsheet. However, you can’t navigate a Continuous form like you do an Excel spreadsheet (much to your Users dismay), well, that is, not until now…

In your modUtilities copy/paste the below (If you don’t have a modUtilities create one. It’s a place to keep all […]

 2,670 total views

Saving changes is not permitted (SQL Server tables)…

You upsize your tables up to the SQL Server but you used some BIT fields and/or you want to make some other table changes. So, you navigate to the first table and uncheck the *Allow Nulls* for your BIT field and make your other adjustments and you go to Save. Instead of the table saving […]

 793 total views