Back to Back Issues Page
Microsoft Access Tips, Issue #003 (August 2011)
August 27, 2011


Hello everyone,

3rd edition for 2011. Just scraped in for August.

Spring has arrived, blue skies and sunny days mostly. Still a bit cool, but the days are beautiful. Went to Queenstown (NZ) with my 24 year old son and 2 of his mates. They snowboarded and partied, I worked on my very first iPhone app.....which I am still working on and probably will be for some time. A whole new program to learn, Objective C.

Ok onto where I am up to with my site, etc.

VBA Lesson Price Reduction

Earlier this year I reduced my VBA lessons. I reduced my 56 VBA (xp) lessons from $47 to less than $8.00, you can even choose just the first 10 lessons for $1.99.

My testing and measuring is still holding up, (i.e. X 6 more people are buying the lessons, than at the higher price) so I will keep the price at the reduced level. If you are interested in learning VBA then...

Click here to order your VBA lessons

I am still updating my VBA lessons to Microsoft Access 2007/2010.

I had forgotten what good value the lessons are. It is taking me ages to update them all to 2007 - 2010, as some of the lessons are in excess of 40 pages long and there are 56 of them, so even if I can manage one a day (which I am not), it will still take me almost 2 months to update them. Not that I am grizzling, I am enjoying reviewing them, it is just taking me a lot longer than I anticipated. Once I have done the first 6, I will make them available, with a scheduled release of the other 50. Will let you know when I have completed this.

I am still also updateing my website to a new layout, so it is a bit all over the place at the moment, my apologies for that. It will only improve, so please bear with me.

Microsoft Access Tips

1. Adding a text box to a tab page

QUESTION: How do I place a label (and textbox, etc.) inside a page (or subform?) of a MS Access 2000 form? When I click on each tab, the label shows up on each tab so far.

ANSWER: This is a common problem that a lot of users of Microsoft Access have.

It is usually not a problem when adding a new text box, as the correct area is usually automatically selected. This problem generally occurs when you have already add the text box to your form, and you decide you then want to move it onto a tabbed page. You cannot just drag, it as it remains on the main form. You have to copy it (and delete) it from the main form and added it to the tab page by correctly selecting the tab page.

This can be a bit tricky, but if you click on the tab name, you will notice:

- the black squares (dots) surrounding the tab, will move to the inside to the tab page (2000 – 2003)

- the tab page will have a yellow rectangle within it (2007-2010)

These are the correct positions. If the tab is not selected, correctly or if you place your textbox outside these guides, then Microsoft Access, just adds the text box the main form, thus you can see the text box on each of the tabs.

2. Correct page footer placement (2007)

Question: Why would the page footer show after the last detail line, instead of at the bottom of the page where it belongs?

When I download templates, I opened a pre-made report and sure enough there is the page footer sitting up in the middle page instead of down at the bottom!!


The reason for this is that Microsoft Access has added other page views (layout view and report view), both do not display the report correctly as it will be printed. To show the report in the correct layout, ensure that ‘Print Preview’ is chosen. This will give the correct layout for printing. With the footer in the correct position.

3. Date criteria in a query


I have been trying and trying to run a query with an expression in Microsoft Access that allows me to show and only show inspection dates that are beyond 1 year old. I was successful in showing the expiration dates of all inspections. But now I want to limit it to show only the ones that are past due, 1 year from the date of inspections.


Try the following:

In the criteria row of the query add the following

<= Date() - 365

Date() is the syntax Microsoft Access uses for today’s date. The above criteria will only display the inspection dates that are greater than 365 days old.

That is it for this month, I will be back with some more tips in Sepember.


Back to Back Issues Page