Using variables in SQL statements can be tricky, but they can give you the flexibility needed to reuse a single SQL statement to query different data. In Visual Basic for Applications (VBA) you can build SQL statements that can contain string criteria. To use a string variable in a SQL string statement you must use the (") as the string delimiter and apply single quotation marks (’) around the variable....

The Vivitar 2800 Auto Thyristor flash is a manual flash that was designed to be used with 35mm film cameras. The Vivitar 2800 fires at one intensity and you adjust the your cameras aperture to select the proper exposure. (Modern flashes communicate with the cameras they are attached to and use the camera’s metering system to adjust their power output. ) The flash uses four “AA” batteries and has input jack for a sync cord, allowing the camera to be used remotely....

Microsoft Access 2007 is a simple, yet powerful, database application that you can use to keep up with your business or personal data. Use it to maintain a database for customer service, business and personal contacts, inventories, home DVD collections and bank reconciliations. A bank reconciliation database is easy to create; you only need a couple of tables, one form and a report for viewing your table items. After you create the database, you can use it to balance your bank accounts month after month....

Microsoft Publisher is a program included in the Microsoft Office productivity suite. It is a type of desktop publishing program that helps you create documents including basic text documents, fliers, newsletters and even websites. There are exactly two different things you can do with PDF files in Publisher–you can open them, and you can save Publisher projects that you’ve been working on into the PDF file format. Writer Bio

Apple first introduced internal webcams to their line of iMacs in 2005. The internal camera, dubbed “iSight” by Apple, records both still photographs and video from a small lens hidden at the top of the computer’s display. A small microphone picks up audio for video recording and chats. Apple designed the webcam to be user-friendly and as such it requires no configuration or extra software. The camera turns on automatically when you open a camera-enabled application and turns off again when you close the application....

The Apple iPhone is a smartphone that was introduced in 2007. Among its features, the iPhone allows you to easily set custom ringtones. In addition to being able to pick and choose ringtones, you also can create your own ringtones using iTunes and your computer. Once you have created the ringtone, you can sync it to your iPhone and begin using it for whatever callers you specify. Writer Bio

Turn Bluetooth On Return to the Windows Start screen on your Gateway laptop, press Ctrl-C to open the Charms menu and then click the Settings icon. Click PC Settings, choose PC & Devices and then select Bluetooth to open the laptop’s Bluetooth settings panel. Click the Bluetooth switch to toggle it to the On position in order to activate Bluetooth functionality. Pair a Bluetooth Device After you’ve activated Bluetooth on your Gateway laptop, you’r ready to pair the computer with other Bluetooth-capable devices....

Google continually drives innovation in web searching by offering updated products. Google Earth is an example of this ongoing effort. Housing an array of different accessories, this virtual mapping system continually conquers new frontiers by method of additional search options. As an added bonus, the basic version is free. In 2009, with the inception of Google Earth version 5.0, a host of fresh capabilities were rolled out. Ocean view was one of these options, and among the most captivating....

You can connect your Google Voice account to Gmail, enabling you to make phone calls through your Google Voice number using a headset connected to your computer. Once Google Voice is connected to the Google Chat service built into Gmail, all calls made from the Gmail interface using a headset will be made using your Google Voice number. Configuration takes only a few moments because Gmail automatically recognizes USB and analog headsets....

Maxtor is a hard drive company owned by Seagate and offers storage solutions for both consumers and professionals. They are known for supplying portable hard drives at different gigabyte sizes such as 60GB, 120GB and 500GB. Maxtor hard drives support a USB 2.0 connection and allow you transfer files at blazing speeds of up to 7200RPM. Maxtor hard drives are large enough for saving large files such as videos and can be small enough to move around with....

Automatic Driver Use Plug the printer power cord into a nearby outlet and then plug the USB cable into an open USB port on your running computer system. Wait a few minutes for Windows to recognize the new USB printer. The new device wizard should install the necessary native Windows printer drivers for use with your system. Click the Windows Start button on the taskbar and then select “Devices and Printers” from the menu....

When your regular answering machine no longer functions, your computer can take over the job of answering incoming calls and taking messages. Computers can act as automatic receptionists, and software such as EZvoice phone answering software can be a useful, more affordable alternative to purchasing a new or used answering machine. Tips Warnings Writer Bio

The Internet is a vast public electronic network of information. Many commercial, academic and government websites provide access to information, services, products, laws and advice. No system of checks and balances are available to assure users of the accuracy of information found on the Internet. Millions of people contribute to information on the Internet, which is constantly changing, added to and deleted. Use the credibility, accuracy, reasonableness and support (CARS) method of verification when relying on information found on the Internet....

Web browsers store information about a user’s web-browsing activity, and mobile phones have access to viewing and monitoring web activity. However, users seeking to view cell-phone web activity must have a registered online account with a service provider and a mobile web browser with a “History” feature. Viewing web activity can help a user monitor the amount of data used, preventing any additional charges from a service provider.

DirecTV subscribers have the option of changing a program’s original language to another language like German, but only if that particular program has language options. Unfortunately there are only a few channels and programs that allow for language changing. Another way to get access to DirecTV programming in German is by downloading a special satellite TV program utility that accesses many different satellite channels from different countries, including Germany. The software accesses DirecTV programming throughout the world and allows you to view foreign language channels (unavailable on the U....

A new car stereo breathes new life into the driving experience, supplying more power and features than the stock unit you’re replacing. Wiring the antenna and other leads in the new radio’s harness is more straightforward than it may initially appear. Aided by color-coded aftermarket wire harness adapters, connecting the new stereo to the existing vehicle is done without hacking up wires. Writer Bio

The Mail app on your iPhone doesn’t automatically update your Gmail password after you change it on the Gmail website. Your password can be changed on your iPhone using the “Mail, Contacts, Calendars” section within the Settings app. Changing your password periodically helps protect the security of your account. Writer Bio

You will likely be unaware of your Mac’s virtual memory (VM) until you find that its performance has slowed to a crawl. This is a temporary memory reserve, from which a Mac’s Random Access Memory (RAM) borrows to perform operations. RAM is fast physical memory. VM is much slower swappable memory, located on a disk drive. When needed, a Mac will dynamically allocate additional virtual memory, and you can do little to tune VM allocation....

The Targus 32 in 1 Memory Card Reader is a USB based, external memory card reader. SD, CF, Memory Stick and MMC are just a few of the support memory formats. The Targus 32 in 1 Memory Card Reader is a portable device that is compatible with any computer that has USB inputs. Using your computer’s file management system (Windows Explorer), you can easily transfer files to and from cards placed inside the memory card reader....

Writer Bio