Monthly Archives: February 2014

Are You Going to Access Day?

If you have been reading this blog, or if you are a talented up and coming developer who wants to attend a workshop with some of the Access geniuses of today, then you may be interested by an event called … Continue reading

Posted in Announcements/News | Leave a comment

Importing an Excel Spreadsheet Into Access

Often times, it is far easier to input raw data into a spreadsheet.  Because of the table like format, copying and pasting can be done quickly and efficiently.  Add to that the ability to copy formulas down thousands of rows … Continue reading

Posted in Uncategorized | Leave a comment

Did You Know? Using Access as a CMS

Content management systems (CMS) are getting a lot of hype these days.  While there are still many websites being created in the traditional sense, utilizing HTML for static pages, more and more websites are utilizing dynamic content driven by a … Continue reading

Posted in Did you know | Leave a comment

Do You Need SQL Server?

In a previous post, I spoke of splitting your database into a front end and a backend.  In that example, I used the idea of separating one Access database into two Access databases, however that is not the only option … Continue reading

Posted in SQL Server Information | Leave a comment

Valentines Day Code

In honor of Valentines Day, here is how a guy would calculate how much to spend on Valentine’s Day Function fncHowMuchMoneyToSpendOnDate(iYearsTogether As Integer, ynMarried As Boolean, ynTryingToImpressHer As Boolean) As Variant Dim curMoneyForFlowers As Currency Dim curMoneyForChocolates As Currency Dim … Continue reading

Posted in Uncategorized | Leave a comment

Did you know? Mail Merge in Word

Mail merges in Microsoft Word are an old tool that a majority of business men and women have used in the past.  If you are sending out letters to your customers, clients, partners, suppliers, or just about anyone else, a … Continue reading

Posted in Did you know | Leave a comment

Support Ending for Office 2003

On April 8th, just over 2 months from now, Microsoft will officially stop providing support for both Windows XP and Office 2003.  What does that mean for you and your business? According to statcounter.com, as of today, 17.78% of people … Continue reading

Posted in Announcements/News | Leave a comment

Splitting a Database to Improve Efficiency

Standard Microsoft Access database interfaces are originally designed to be all encompassing within one file.  This file holds all the tables (data), queries, forms, reports, modules and macros.  This model works very well for small databases that are only going … Continue reading

Posted in Uncategorized | Leave a comment