Back to Back Issues Page |
![]() |
Microsoft Access Tips, Issue #002 (2011) July 11, 2011 |
WelcomeHello everyone, 2nd edition for 2011. Ok a bit behind my monthly promised schedule. For new members, I sent my last edition out in May, so not too bad, just lost June somewhere. Does anyone know where it went to? It is winter here in Australia and where I am it is cold and wet (for us anyway). Went up to the ski slopes last weekend. I did not ski; as last time I did (2 years ago) I dislocated my elbow, so not that keen to repeat that experience. I went up to keep my daughter company who is a keen skier. We camped out, but had access to a hiking hut which had an open fire. We have all the right equipment so were quite warm and confortable. It was great to get back to the basics for a few days. Ok onto where I am up to with my site, etc.
VBA Lesson Price ReductionLast newsletter, I reduced my VBA lessons. I reduced my 56 VBA (xp) lessons from $47 to less than $8.00, you could even choose just the first 10 lessons for $1.99.So How did my testing and measuring go. Obviously I want to make some money from my website, but I am also keen to make the information affordable to the majority of people. I had to sell at least 6 times more at the reduced price to be where I was at prior to the price reduction. Well I did achieve this. :0) It could be because there was a time limit on it, i.e. purchase by the end of June. So my next step is, is to keep the reduced price but with no time limit on it. We will see how this goes. Will let you know next month.
Click here to order your VBA lessons
Microsoft Access Tips1. Exporting data from Access to WordQuestion I'd like to know how to send data rows from MS Access to Word programmatically.
Answer
You can do this in at least two ways - bookmarks or tables. I will go with the table option for this tip.
2. Compacting and repairing your data baseWe have had one advanced tip, now for a basic tip.As we change things in a database, especially doing design changes, the size of your database can grow very large. Therefore it is important to 'Compact and Repair' your database as you build it. Do this routinely. How often is up to you, but probably a good idea to get into the habit of doing it when you have finished with the database for the day, or if you are having a break. To 'Compact and Repair' the database:
On the toolbar choose Tools > Database Utilities > Compact and Repair Microsoft Access 2007 - 2010 Click on the 'Ball' in the upper left hand corner > Manage > Compact and Repair.
That is it for this month. Catch up with you all in August.
|
Back to Back Issues Page |