Welcome

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

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

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)

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!!

Answer:

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.

Answer:

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.