Access Visual Basic and Excel VBA Macros - A Comparison of the MS Office Programming Languages

Similarities between Excel VBA and Access VBA

In theory it should be easy to switch from one MS Office VBA programming language to another, since all the underlying principles are the same. It doesn't matter whether you're writing VBA macros within Access, Excel, Outlook, PowerPoint or Word, you're still using:

- objects, collections, methods and properties

Access Visual Basic and Excel VBA Macros - A Comparison of the MS Office Programming Languages

- variables (the DIM statement)

- IF conditions and loops

- message boxes and input boxes

- subroutines and functions

In fact, the only thing which is different is the object and collections defined within the application. So how hard can it be to switch from (say) Excel VBA to Access VBA? The answer, sadly, is... fairly hard. Here's why!

Differences between Excel Visual Basic and Access Visual Basic

The main differences between the two programming languages are that Access supports two macro languages, doesn't support recording, has two different ways to create Visual Basic macros, hides a lot of its functionality in the DoCmd object and has two separate object models. If that didn't make much sense, worry not - the rest of this article will explain each of these points in turn.

Access has Two Macro Languages

This is a red herring. Microsoft Access has two separate languages for writing macros: one called macros, the other called either modules or Visual Basic. If you have any knowledge of VBA, you should ignore the first; it is provided for people who have no programming experience, and doesn't support proper looping, error-handling and many other structures. So although the Access database window contains a MACROS tab, you should ignore this completely!

Access doesn't Support Recording

Want to know how to colour a cell red with pink spots in Excel? If you can't guess the macro command (unlikely), you can just record a macro and have a look at the resulting code. This is a vital aide-memoire even when you're a VBA guru.

Access, on the other hand, doesn't support recording - not even in the latest version at the time of writing, Access 2010. This is, to say the least, a shame (interestingly, while Word supports VBA recording, PowerPoint doesn't any more: Microsoft removed the facility from version 2007 onwards). This means that you're often forced to resort to Google, Microsoft help or phoning a friend to find out how to do something in Access VBA.

Two Different Ways to Write Macros in Access

Want to create a VBA macro in Access? To do this, you need to go to the VBA code editor. Strangely, you can do this in two different ways: either press ALT + F11 as normal, or click on the Modules tab in the database window and choose to create a new module. Why are there two different ways to do the same thing? Historical reasons, we think.

Access Uses the DoCmd Object for Many Commands

Access VBA is complicated (or simplified?) by the fact that about half the commands begin with DoCmd. For example:

DoCmd.OpenForm - to open a form

DoCmd.Maximize - to maximise a window

Features like this make Excel a far more logical programming language than Access.

Access has Two Separate Object Models

Excel is pretty self-contained (although if you're creating your own dialog boxes, you'll be using a separate applications called Microsoft Forms). Access, however, splits into two almost equal parts:

- tables and queries are part of the Access database engine

- forms, reports, macros and modules are part of the Microsoft Access application

Although you'll probably only hit this complication when you get into advanced programming in Access, it's another Access feature to muddy the VBA water.

In summary, then, we'd say that Excel macros are far more straightforward than Access ones. Added to this is the fact that it's much quicker to learn Excel than it is to learn Access, and you get two unequal learning curves!

Access Visual Basic and Excel VBA Macros - A Comparison of the MS Office Programming Languages
Check For The New Release in Health, Fitness & Dieting Category of Books NOW!
Check What Are The Top Cooking Books in Last 90 Days Best Cheap Deal!
Check For Cookbooks Best Sellers 2012 Discount OFFER!
Check for Top 100 Most Popular Books People Are Buying Daily Price Update!
Check For 100 New Release & BestSeller Books For Your Collection

Andy Brown is a trainer and developer for Wise Owl Training, a company providing Microsoft computer training in the UK.

For Wise Owl courses specific to Excel Visual Basic, go to http://www.wiseowl.co.uk/excel/courses/vba.htm; for courses specific to Access Visual Basic, go to http://www.wiseowl.co.uk/ms-access/training/visual-basic.htm.

mobile phone watches Buy Best Workcentre 013R00662 Buy Best Quoizel Ok8604Ho Oakland 7 1 2 Buy Best Diamond And 18K White Gold Chandelier

How to Adjust Small Block Chevy Lifters

I got thinking and it came to me, I had never done an article on how to adjust small block Chevy lifters, so this article is going to make up for my transgressions of the past, I think people need to know this information if they have small block, or for that matter a big block Chevy.

I've written on almost every subject related to the restoration of a car, but never this subject, so please forgive me, and allow me to show you what I know on this subject, there is nothing illusive about adjusting the lifters on a small block Chevy engine, or for the matter a big bock either.

First of all if your installing a new camshaft, you should absolutely follow the recommendations of the camshaft manufacture, this article is based off of standard adjustment values and the camshaft that you are installing may be different.

How to Adjust Small Block Chevy Lifters

Things will change a bit depending on the type of camshaft that you have in your engine, you need to know a few things, first of all is the camshaft a solid, or hydraulic lifter version, solid lifters cams are also called flat tappet cams.

One good simple way to tell is to grab one of the push rods and push it down, if you can make the push rod move down, you have a hydraulic cam, a solid lifter cam you can't push the lifter down at all, once you have determined what lifters you have you can begin the adjusting process.

Of course this is all assuming that you have removed the valve covers, on a small block Chevy this is done by loosening the two bolts on the top of the valve cover, and the two bolts on the bottom, unless the valve covers are the new style with four bolts in the centre, then you need to remove them.

Tools You Need:
A 5/8 socket Ratchet Feeler gauges

You'll need the tools in the list above to adjust your lifters, the first thing you'll need to do is, if your adjusting hydraulic lifters you'll need to get the feeler gauge and unfold the one that says .030 on it, this is what you'll be setting the lifters to, if the cam is solid lifter get out the .026 gauge.

What your doing here is setting that back lash of your lifters to .030 if you have a hydraulic cam, or to .026 if you have a solid lifter cam, for this article we'll say that you have a hydraulic because they are the most common cams sold for street use.

So now that the valve covers are off of the car, you'll need to turn the crank of the engine until the two front valves on the right hand side are fully closed, and you must be absolutely sure that they are before you can begin to adjust them, or the entire job will be done wrong, this is very important.

They call this top dead centre, it's when the number one piston is at the top of it's stroke, and the timing line on your balancer is at the zero mark, this is the point where you can begin to adjust the lifters on the engine, I like to start out with number one just so I can keep track of where I'm at.

Now that you have number one at top dead center, you can begin to do the adjustment of the lifters, with the valves fully closed you need to take the feeler gauge and put it between the rocker arm and the valve stem, once you have put there it should feel a little stiff when you pull the feeler gauge out of from between the rocker arm and the valve stem, if should not slide easily, but should be a bit hard to pull on.

If it's not you need to loosen up the nut on top of the rocker arm with the 5/8 socket, and put the feeler gauge in between the valve stem and the rocker arm, and tighten it until it's seem a little stiff when you pull it out from between the valve stem and the rocker arm.

When your done adjusting the first two valves, you'd just move to the next two back and repeat the last two steps, you'd just repeat these steps until you have gone through all the valves on the engine, and wa-la your valves are now set perfectly.

How to Adjust Small Block Chevy Lifters
Check For The New Release in Health, Fitness & Dieting Category of Books NOW!
Check What Are The Top Cooking Books in Last 90 Days Best Cheap Deal!
Check For Cookbooks Best Sellers 2012 Discount OFFER!
Check for Top 100 Most Popular Books People Are Buying Daily Price Update!
Check For 100 New Release & BestSeller Books For Your Collection

I've been in the automotive business for about 20 or 25 years, I have worked in all facets of the industry, from parts to restoration, all different makes and models, I just want to keep people interested in the old cars because it's where my heart is.

http://autorevival.com

watch cell phone Buy New Deutsch Dt 323 Pc Kit For Best Price Slate Border Clock With Temperature And Buy New 3 Month Meals Ready To Eat

Starter Clicks But Engine Does Not Turn Over - Tech in Trunk?

If the car's starter clicks and the engine does not turn over, this could be caused by several things. The most common cause of clicking when the car is being started is a low battery. Most people would assume that the starter is bad if it only clicks, but low-voltage can cause the starter to make this sound.

The battery is the heart of the starting and electrical system. If the battery has been drained or has a weak cell, this can cause the starter to only click. Many times the battery could just been drained due to a door left slightly open, making the dome light stay on. Other times a vanity light or a phone charger could be left on. During my time as a master auto technician, I've had a trustworthy co-worker close me up in the trunk so I could make sure the trunk light went off when the trunk was closed!

In order to test the battery it must have a good charge. If the battery is not charged completely the tester will indicate that it needs to be charged before testing can proceed. The first step when checking the starter and electrical system is to make sure the battery is in good condition. Most parts stores will check batteries for free. Once it's determined the battery is good the rest of the system can then be checked. Loose or corroded connections can also cause a clicking and for the car not to start.

Starter Clicks But Engine Does Not Turn Over - Tech in Trunk?

Starter

The starter solenoid on many Ford vehicle's is on the inner fender well, on most other vehicles the starter solenoid will be mounted on the starter. The clicking that is heard many times is the solenoid. But low-voltage either from a drained battery, bad battery or poor connections can cause this. Most of the time if the vehicle can be jump-started the starter is okay. This would also indicate that the connections to the starter are good.

Alternator

Once the vehicle is running the alternator output can be checked. If the alternator is not charging the battery, it will be drained during the process of starting the car and driving. When the alternator is checked, the voltage and amperage output can be measured. Also the diode pattern will be checked to make sure the alternator won't drain the battery when the engine is turned off. In the past do-it-yourselfers could disconnect the battery while the vehicle is running to check the alternator, if the car kept running the alternator was good. Doing this on computerized vehicles can be harmful. If the battery is disconnected while a computerized vehicle is running the alternator output can increase sharply allowing excess voltage to spike the computer.

Battery

When purchasing a replacement battery the cold cranking amps required for the vehicle should be checked. It's best to purchase a battery with more cold cranking amps than the minimum required. Also when purchasing a battery you should consider if you want maintenance free or not. If the battery is hard to access or has a cover then a maintenance free battery is preferred. For instance on some Chrysler Sebrings and Chevrolet Corvettes the battery is located behind an inner fender and on a Chevrolet SSR. the battery is located underneath the bed where the spare tire would normally go. If installing the battery yourself be sure to notice which side is positive and negative in case you were sold the incorrect battery.

Terminals

The terminals should be free of corrosion and should tighten up well. Sometimes especially on import vehicles the battery terminals will be very thin and can have hairline cracks causing a poor connection. Avoid forcing the battery terminals on by tapping them. The battery casing can be damaged causing a leak, if the battery acid seeps out it can cause fast corrosion. If the battery terminal bolts will not tighten, then replacing the terminals is recommended. When the connections are tight you should not be able to twist them by hand.

Starter Clicks But Engine Does Not Turn Over - Tech in Trunk?
Check For The New Release in Health, Fitness & Dieting Category of Books NOW!
Check What Are The Top Cooking Books in Last 90 Days Best Cheap Deal!
Check For Cookbooks Best Sellers 2012 Discount OFFER!
Check for Top 100 Most Popular Books People Are Buying Daily Price Update!
Check For 100 New Release & BestSeller Books For Your Collection

Learn how to jump start a car properly using a booster jump box.

mobile phone watches Stuhrling Original Alpine Skeleton Cheap Buy Holyland 1 25 Ct Round Diamond Solitaire

Where to Find the Free Online Auto Repair Manual You Need?

If you need an online auto repair manual that can help you precisely fix your problem, the internet has an incredible amount of car care information. What you won't find however, is a Chiltons or a Haynes auto repair manual, because they're copyrighted material. You don't need them anyway, because there are a lot of good car repair web sites with individual pages or articles that can solve your specific problem.

In fact, you'll find articles on all kinds of car fix and vehicle maintenance topics, such as

auto body repairs automatic transmission replacement bleeding brakes car audio systems fix changing oil finding the causes for a bearing failure how to install a replacement ignition system how to upgrade an exhaust system troubleshooting car stalling troubleshooting car starting problems

Where to Find the Free Online Auto Repair Manual You Need?

and much more.

Here is a good place to search for vehicle fix manuals: Go to the search site at 10w40.com and type in the problem you want to solve - and the likelihood of finding the instructions you need is high. On this website you can also post your problem on an advice and discussion board, and get your problem solved almost instantly by an expert in this repair field or by an ordinary person who has experienced your problem and solved it already or might know where to go to get the answer you need. And it doesn't cost you a cent.

There are many other good websites where you can get an online auto repair manual that will fit your needs. Go to Google.com and type in [the problem you want an answer to]+repair manuals, and you should find lots of valuable vehicle repair resources that might solve your problem.

Where to Find the Free Online Auto Repair Manual You Need?
Check For The New Release in Health, Fitness & Dieting Category of Books NOW!
Check What Are The Top Cooking Books in Last 90 Days Best Cheap Deal!
Check For Cookbooks Best Sellers 2012 Discount OFFER!
Check for Top 100 Most Popular Books People Are Buying Daily Price Update!
Check For 100 New Release & BestSeller Books For Your Collection

Terje Brooks Ellingsen is a writer and internet publisher. Terje gives advice and helps people with automotive issues like finding free manuals for car repair as well as find cheap cars.

watch mobile phone Best Price Slate Border Clock With Temperature And

The Importance of Ethics and Social Responsibility in Today's Businesses
Starting a Social Networking Website From Scratch
How to Make Easy Money - $5000 Dollars a Day
What Is a Podcast and How Does It Work?
Chopper Kits - Build Your Own Dream Chopper
Have You Got Issues With the PS3 Red Flashing Light? Fix This Problem Today
Knowledge Mapping
Where To Download Free Sony Psp Games
How to Get Rid of Trojan Virus - 5 Easy Steps to Get Rid of Trojan Horse Virus
Windows 7 Slow - How to Speed Up Windows 7 Quickly and Easily
Social Networking The Pros and Cons of Social Networks
How To Put Music On Iphone
Restore Data From Damaged Hard Drive - A Quick Way to Recover Files From Crashed Hard Drive
How to Start an Online Clothing Store in 12 Steps
How To Make An Email Address
Podcasting - The New Age Digital Broadcasting
Purchase Cheap Alpinestars Durban Gore Tex Waterpr
Satellite Internet and Online Gaming: Does It Work?
How To Make Pizza - A Step By Step Guide To Show You How To Make Pizza
How Can I Watch Free Movies TV Shows Online on My PC - The Big Scam

The Different Types of Programming Languages - Learn the Basics

The progression of computer programming languages was made possible by the programmer's search for efficient translation of human language into something that can be read and understood by computers. The languages generated, called machine code, have high levels of abstraction, which hide the computer hardware and make use of representations that are more convenient to programmers.

As programs evolve and become more sophisticated, programmers found out that certain types of computer languages are easier to support. As expected in a dynamic discipline, there is no standard for categorizing the languages used in programming. There are, in fact, dozens of categories. One of the most basic ways to categorize the languages is through a programming paradigm, which gives the programmer's view of code execution. Among the languages classifications according to programming paradigm are:

o Object-Oriented Programming Languages
Known as the newest and most powerful paradigms, object-oriented programming requires the designer to specify the data structures as well as the types of operations to be applied on those data structures. The pairing of data, and the operations that can be done on it is called an object. A program made using this language is therefore made up of a set of cooperating objects instead of an instructions list.

The Different Types of Programming Languages - Learn the Basics

The most famous object-oriented programming these days are C#, C , Visual Basic, Java, and Python.

o Structured Programming Languages

An exceptional type of procedural programming, structured programming provides programmers with additional tools to handle the problems created by larger programs. When using this language, programmers are required to cut program structure into small pieces of code that can easily be understood. Instead of using global variables, it employs variables that are local to every subroutine. Among the popular features of structured programming is that it doesn't accept GOTO statement which is usually associated with the top-down approach. Such approach starts with an opening overview of the system with minimal details about the various parts. To add these details, design iterations are then included to complete the design.

Commonly used structured languages include C, Pascal, and ADA.

o Procedural Programming Languages

Procedural Programming involves a list of operations the program needs to complete to be able to attain the preferred state. It is a simple programming paradigm where every program comes with a starting phase, a list of tasks and operations, and an ending stage. Also called imperative programming, this approach comes with small sections of code that perform certain functions. These sections are made up of procedures, subroutines, or methods. A procedure is made up of a list of computations that should be done. Procedural programming lets a part of the code to be used again without the need to make several copies. It achieves this by dividing programmatic tasks into small sections. Because of this, programmers are also capable of maintaining and understanding program structure.

Among the known procedural languages are BASIC and FORTRAN.

These are the different types of computer programming languages that you can consider when planning to make a computer program. Procedural programming splits the program's source code into smaller fragments. Structured languages require more constraints in the flow and organization of programs. And object-oriented programs arrange codes and data structures into objects.

The Different Types of Programming Languages - Learn the Basics
Check For The New Release in Health, Fitness & Dieting Category of Books NOW!
Check What Are The Top Cooking Books in Last 90 Days Best Cheap Deal!
Check For Cookbooks Best Sellers 2012 Discount OFFER!
Check for Top 100 Most Popular Books People Are Buying Daily Price Update!
Check For 100 New Release & BestSeller Books For Your Collection

To learn more about computer programming, including how you can get started creating your own programs in the next few minutes, Check Out, http://beginnerscomputerprogramming.com

watch cell phone Buy Best Diamond And 18K White Gold Chandelier Buy Best Workcentre 013R00662

Rough Openings For Doors

One of the most important parts of framing walls is getting
the rough openings right. Items that determine what the
height of One of the most important parts of framing walls is getting
the rough openings right. Items that determine what the
height of your opening will be are floor finishes and the
use of underlayment. Door widths will stay constant with the
size of a standard door.

In new construction most doors are hung after the floors are
installed. This allows flooring contractors (tile, hardwood,
vinyl, laminate) to lay their flooring products without
making tricky cuts around door jambs. It also makes for a
neat and clean door installation. Exceptions to this are
carpeted floors. Doors are hung before the carpeting is
laid. When doors are hung in carpeted areas, its a good idea
to shim them up 1/2", putting a shim under each jamb leg.
This eliminates the need to cut the doors down after the
carpet is installed.

For a 6' 8" high door (80 inches) I like to frame my rough
opening height at 82 3/4". This allows room for all the
situations mentioned above. If your header material is a
double 2x12, holding it to the top plate will give you that
height.

Rough Openings For Doors

Rough openings for door widths are pretty much standard. The
rough opening width is 2 inches wider than the door itself.
this allows room for the door jambs which are usually 3/4"
thick. This gives you approximately 1/2" of play and shim
room when installing a prehung door. For a 36" door (3' 0")
the rough opening width would be 38". Here are the most
common door sizes and their rough openings.

Door Size Rough Opening Size

2' 0" x 6'8" -26" x 82 3/4"

2' 2" x 6'8" -28" x 82 3/4"

2' 4" x 6'8" -30" x 82 3/4"

2' 6" x 6'8" -32" x 82 3/4"

2' 8" x 6'8" -34" x 82 3/4"

2' 10"x 6'8" -36" x 82 3/4"

3' 0" x 6'8" -38" x 82 3/4"

To figure the rough opening for double doors or french
doors, take the door size times 2 and add 2". The most
common sizes for exterior doors are the 2'8" and the 3'0"
doors. The 2'8" is usually used for the back door and the
access door from the garage. That size door for exterior use
is being used less these days because of the size of
appliances and furniture. Exterior doors with sidelights and
sliding patio doors rough openings vary from manufacturer to
manufacturer. These should be verified and gotten from the
supplier.

Getting the rough openings right the first time keeps the
sawzall in its carrying case and having to change the
opening after the walls are drywalled and painted.

Mike Merisko (c) 2006

http://www.sawkerfs.com

Rough Openings For Doors
Check For The New Release in Health, Fitness & Dieting Category of Books NOW!
Check What Are The Top Cooking Books in Last 90 Days Best Cheap Deal!
Check For Cookbooks Best Sellers 2012 Discount OFFER!
Check for Top 100 Most Popular Books People Are Buying Daily Price Update!
Check For 100 New Release & BestSeller Books For Your Collection

Mike Merisko has been a carpenter for 26 years. Most of those years were spent in the homebuilding and remodeling industries. He was also in business as a carpentry and general contractor. While that is his forte, he also has experience in bridge building, commercial construction, and exhibit building which is how he earns his living these days. You can browse through articles by him and others at his website http://www.sawkerfs.com or visit his blog at http://www.sawkerfs.blogspot.com

mobile phone watches Buy Cheap Denso 950 0152 Fuel Pump For