Saturday, March 14, 2009

A listing of MS Access VBA Tutorials

MS Access tutorials 2000, 2002, 2003, 2007

A series of Microsoft Access Database Tutorials and Examples written by myself.
  • This Post inclludes free VBA Examples
  • MS Access Autonumber Field with VBA Creates an Autonumber field using
    , Changes a current fields name, Adds a regular Text Field all
    in VBA on an Existing Table "Not Enough Space on Temporary Disk" error work
    around Makes use of a MS Access Form and Module
  • MS Access VBA Update Field Using VBA to Update a Field,
    VBA Code to Update an existing field
  • MS Access VBA Create Field Using VBA to create a new Field
    with several data types available
  • MS Access VBA Change Field Data Type Using VBA to Change a Fields Data
    , VBA Code that changes a Fields data Type using ALTER Table
    ALTER Column
  • MS Access VBA Check if Table Exists VBA Check if Table Exists,
    VBA Code to Check for a table
  • MS Access VBA Check if Field Exists VBA Check if Field Exists,
    VBA Code to Check for a Field in a Table
  • MS Access VBA Delete Query Using VBA Delete Query, VBA
    Code to Delete existing records given Criteria
  • MS Access VBA Get All Fields Using VBA to Get All Fields,
    VBA Code that Returns all Fields Within a Table
  • MS Access VBA Rename Field Using VBA to Rename a Field,
    VBA Code to rename existing fields
  • Tuesday, February 3, 2009

    MS Access Tutorials

    MS Access Basic Table

    Basic MS Access Table Design: Index, Primary Key, Autonumber

    MS Access Query Builder
    Basic Select Query using an All Fields Wild card

    MS Access Query Builder 2
    Select Query using specific criteria

    MS Access Query Builder 3
    Select Query using specific criteria with WildCards

    MS Access Delete Query Tutorial
    A basic delete query using criteria

    MS Access Append Query Tutorial
    A basic Append Query

    MS Access Insert Into or Make Table Query Tutorial
    Create a new table using the MS Access Query Builder

    MS Access Autonumber Field with VBA
    Creates an Autonumber field, Changes a current fields name, Adds a regular Text Field all in VBA on an Existing Table

    "Not Enough Space on Temporary Disk" error work around

    Sunday, August 10, 2008

    STOP the IE7 Get it now Offer Page

    In ten years Microsoft’s Internet Explorer (IE) web browser market share has dropped from 92% to 82%. (CNET)

    Could it be from tactics like the following?

    A few unlucky souls who did not upgrade from IE6 to IE7 are plagued with an IE7 “Get it now” Home page or browser Hijack. While this in no way impacts IE’s ability to navigate the web I feel it necessary to point out this underhanded attempt at forcing the move IE7.

    There may be a very good reason to move however the choice in tactics is a major annoyance. Then they require you to validate your version of windows to get it IE7 which is a further annoyance.

    An Alternative is Firefox you could wash your hands of IE forever.
    Provided you do not WANT to get it now then the following will STOP the IE7 Get it now Offer.

    The fix:
    This should stop the offer alone however there are a few other tweaks to try if it does not.

    A registry tweak, use at your own risk. In windows you can use Regedit by clicking Start, Run and then type regedit.

    [HKEY_CURRENT_USER\Software\Microsoft \Internet Explorer\Main]
    "First Home Page"=""
    "" would be the homepage URL you wish to use.
    Use the above at your own risk; I am not responsible if you screw up your registry. I can say though that this worked for a computer I had to Stop the IE7 Get it Now Offer on.

    Note: This will override setting the homepage from IE. It would appear that if you wish to change your homepage then you will need to re-edit the above registry setting.
    Of course your homepage if pressed again will follow the IE setting for your home page. The registry tweak is for when you first open IE.

    The other tweaks:

    In IE goto Tools/Internet Options/Advanced/
    Uncheck “Automatically check for Internet Explorer Updates”
    Click Apply and then OK

    At Select CUSTOM and scan
    Uncheck IE7
    Then Hide it.

    Of course one could simply Install IE7 however that would be like Giving in to the “Man”…


    Add to Technorati Favorites

    Saturday, August 9, 2008

    Reasons to use an Address Validation Service

    There are three major reasons to use a third party to validate your Addresses.

    Cost: Address Validation service software costs a couple thousand dollars. The vendors charge a huge fee for something that does not see a lot of usage.

    Maintenance: The software must be updated regularly to maintain its accuracy. Addresses change all the time and new zip codes get included ect...

    Time: Maintenance takes time and time is additional cost.

    Companies that provide this service keep their software up to date thus letting their customers worry about other business related things. Their fees are a heck of a lot less than the software vendors.

    It only makes sense to out-source this issue when mailings are done only a few times a year. For example you could spend in excess of $3000 for a piece of software with re-occurring fees to keep it updated. If you outsource the Address Validation Service you not only pay a smaller fee, you pay only when you need it done. You need not spend time on it nor have some one trained to do it.

    Eraserve AP - Data Services


    Add to Technorati Favorites

    Address Validation

    In today’s world with hundreds of millions of consumers and businesses it is a good idea financially to periodically have your lists run through an Address Validation service; If for no other reason than to adhere to USPS standards.
    Over $600 billion is reportedly wasted (by The Data Warehousing Institute) on postage, printing and employee wages from bad addresses. The US post office reports 33% of all addresses contain errors. Address errors are caused by a multitude of reasons like Divorce, Marriage, Restructuring, Mergers and user error.

    Over time your data’s integrity is lost. What Address Validation will do is increase deliverability with Delivery Point Validation (a part of the Coding Accuracy Support System or CASS process) by tagging good records and allowing the remaining records to be culled from the data into a separate file. Data does not have to be lost. In this way non deliverables can be kept separate from the good data and money can be saved on mailing campaigns. Money will be saved by eliminating wasted materials, postage, and wages . CASS processed addresses (USPS® Form 3553) could also qualify for postal discounts. This could save up to 45% of the mailing cost in some cases.

    In a nutshell you will spend money for this service and then save even more money during the mailing campaign. It is wise to ensure mailing companies, if used, will give discounts for pre CASS Certified Addresses. Some mail companies do not give credit and take the lower costs as part of their profit.

    Submit this Form to find out


    Add to Technorati Favorites

    The Costs of bad data

    Bad data in today’s world is prolific. List companies around the world collect data on individuals, companies and institutions on a regular basis. Not all the data remains static. This data is dynamic in nature. People move, names change and companies relocate for multiple reasons. By its very nature, Data involving addresses is volatile.

    Billions of dollars is wasted yearly on this bad data. This figure represents wages from the worker stuffing the envelope to the postage and costs creating the material. For example considering time to design, publish and mail costs could be well over $5 per unit. Say you mail 5000 pieces for a total cost of $25,000. Let’s say 3-5% does not get delivered because of the bad data. That is a cool $1250 on mailings that was a complete waste.

    Much of your data is old when coming straight from the list company. When was the last time it was validated? It is doubtful that these companies have recently validated your data prior to shipping it. Even if they did a lot of movement happens in a 3 month time frame and could easily make 3-5% of your data invalid and undeliverable. Out of 5000 records it is not unheard of for 150 to 250 of these to be bad records.

    If your mailings are undeliverable not only do you lose the money spent to send these mailings you lose possible re-occurring income from conversions. Would it not be wise then to validate your data with an Address Validation Service?

    Submit this Form to find out


    Add to Technorati Favorites

    Tuesday, July 8, 2008

    The Data

    Email Lists, Marketing by Email.
    MS Access Query design.
    Deduping, remove duplicate records.
    Merge/Purge , Combining of lists and then deduping.
    Upper, Lower and Proper case, make your choice!
    Key Codes, Assign your own codes.
    Odd character removal, whatever it is, it does not have to be there!
    Record removal, whatever number you want gone. Using whatever identifier you wish.
    Data normalization and formatting, make that 1234567890 look like 123-456-7890 throughout your data.
    Multiple Data Types, Excel, Access, dBase, CSV ect...
    Hundreds of thousands of records, No problem!
    Business to Business Mailing Lists, Consumer Mailing Lists, Telemarketing Lists and Database
    genderizing, give your list of names a Mr or Ms Prefix.
    Directories in PDF Format
    Address Validation service, validates and appends your address with Zip+4. Includes CASS and DPV. CASS reports available on request.