Thursday, April 30, 2015

Access 2007 and VBA Tutorial

 

MS ACCESS 2007: VBA ENVIRONMENT INTRODUCTION

This MSAccess tutorial explains the VBA environment in Access 2007 (with screenshots and step-by-step instructions).

WHAT IS VBA?

This is what the VBA environment looks like in Microsoft Access 2007:
Microsoft Access
VBA standards for Visual Basic for Applications and is the language embedded within your database in Access 2007.
You use VBA whenever you do one of the following:
  1. Create a new function.
  2. Create a new subroutine.
  3. Define a global variable.
  4. Place code behind an event procedure such as the "On Click" event of a command button.
  5. Execute the RunCode action in a macro.
These are just some of the examples of when you might be running VBA code.

MS ACCESS 2007: OPEN VBA ENVIRONMENT

This MSAccess tutorial explains how to open the VBA environment in Access 2007 (with screenshots and step-by-step instructions).

HOW TO OPEN THE VBA ENVIRONMENT

You can access the VBA environment in Access 2007 by opening up the Microsoft Visual Basic window. The quickest way to do this is by pressing Alt+F11 while your Access database file is open.
Microsoft Access
This is an example of what the Microsoft Visual Basic window looks like.

MS ACCESS 2007: PROJECT EXPLORER IN VBA ENVIRONMENT

This MSAccess tutorial explains the Project Explorer within the VBA environment in Access 2007 (with screenshots and step-by-step instructions).

PROJECT EXPLORER

The Microsoft Visual Basic window displays your VBA environment:
Microsoft Access
Next, let's take a few moments to analyze the various sections in the Microsoft Visual Basic window.
Microsoft Access
The Project Explorer can usually be found in the top left portion of the Microsoft Visual Basic window. It is a hierarchical listing of the objects recognized by VBA.
In this example, there is one "Microsoft Access Class Objects" - a form called frmProducts. There is also a Module called Module1.
These are all objects that you've created in your Access database that the VBA environment is aware of. The Project Explorer may not display all of your Access objects.
If the Project Explorer is not visible when you open the Microsoft Visual Basic window, you can make it visible by selecting Project Explorer under the View menu.
Microsoft Access

MS ACCESS 2007: PROPERTIES WINDOW IN VBA ENVIRONMENT

This MSAccess tutorial explains the Properties Window in the VBA environment in Access 2007 (with screenshots and step-by-step instructions).

PROPERTIES WINDOW

The Microsoft Visual Basic window displays your VBA environment:
Microsoft Access
Next, let's analyze the Properties window in the VBA environment.
Microsoft Access
The Properties window is usually found directly below the Project Explorer in Access 2007. It displays the properties for the object currently highlighted in the Project Explorer. In the example above, it is displaying the properties for the module called Module1.
If the Project Explorer is not visible when you open the Microsoft Visual Basic window, you can make it visible by selecting Properties Window under the View menu.
Microsoft Access

MS ACCESS 2007: CODE WINDOW IN VBA ENVIRONMENT

This MSAccess tutorial explains the Code window in the VBA environment in Access 2007 (with screenshots and step-by-step instructions).

CODE WINDOW

The Microsoft Visual Basic window displays your VBA environment:
Microsoft Access
Next, let's analyze the Code window in the VBA environment.
Microsoft Access
The Code window is usually found to the right of the Project Explorer in Access 2007. It displays the VBA code for the object currently highlighted in the Project Explorer. In the example above, it is displaying the VBA code for the module called Module1.
If the Code window is not visible when you open the Microsoft Visual Basic window, you can make it visible by selecting Code under the View menu.
Microsoft Access

MS ACCESS 2007: IMMEDIATE WINDOW IN VBA ENVIRONMENT

This MSAccess tutorial explains the Immediate Window in the VBA environment in Access 2007 (with screenshots and step-by-step instructions).

IMMEDIATE WINDOW

The Microsoft Visual Basic window displays your VBA environment:
Microsoft Access
Next, let's analyze the Immediate window in the VBA environment.
Microsoft Access
In Access 2007, the Immediate window is usually found below the Code window. It is an essential element of the debugger found within the VBA environment. It lets you:
  • Type code and press ENTER to view the results of the code.
  • When in debug mode, it lets you view the value of a variable in its current state. This will be discussed in the tutorial on Debugging VBA Code.
If the Immediate window is not visible when you open the Microsoft Visual Basic window, you can make it visible by selecting Immediate Window under the View menu.
Microsoft Access

MS ACCESS 2007: OBJECTS DISPLAYED IN VBA ENVIRONMENT

This MSAccess tutorial explains what objects are displayed in the VBA environment in Access 2007 (with screenshots and step-by-step instructions).

OBJECTS DISPLAYED IN THE PROJECT EXPLORER

Microsoft Access
The next important aspect to discuss is what objects appear in the Project Explorer.
At first glance, you'd assume that all of the Forms, Reports, and Modules that you create will automatically appear in the Project Explorer. But this is not true. The VBA environment only knows about the objects that you tag as "having a module".
So by default, all Modules will appear in the Project Explorer, but not all Forms and Reports necessarily will.
A Form will only appear in the Project Explorer if the Form's "Has Module" property is set to "Yes".
Microsoft Access
Similarly, a Report will only appear in the Project Explorer if the Report's "Has Module" property is set to "Yes".
Microsoft Access
Now, you're probably asking yourself, "How come some of the forms and reports in my Access database have the "Has Module" property set to "Yes" and others don't?"
Well, anytime that you invoke the Code Builder in a Form/Report, Access automatically sets Form/Report's "Has Module" property to "Yes".
Microsoft Access
Therefore, if you want to reference one of your Forms or Reports in the VBA environment, you may need to manually go to the Form/Report's Properties window and set the "Has Module" property to "Yes".

TUTORIAL SUMMARY

Microsoft Access is a unique tool released by Microsoft that provides both the functionality of a database and the programming capabilities to create end-user screens. Each version of Access can "look and feel" completely different from another.
In this Access 2007 tutorial, we covered the following:
  • What is VBA?
  • How to open the VBA environment
  • Project Explorer
  • Properties Window
  • Code Window
  • Immediate Window
  • Objects displayed in the VBA environment
Each version of Access can "look and feel" completely different from another. As such, we recommend that you try one of our other Access tutorials to become familiar with the Access version that you will be using

Beware: Deceptive Work at Home Opportunities on the Loose

By Holly Reisem Hanna
I was doing some online research, when I saw an ad that said, “I make $486 every day. Work from home and earn $13,745 a month”. Red warning flags immediately went off in my head, as this looked like many of the other deceptive work at home opportunities that have been promoted in the past.
Just like the Easy Google Profits promotion, when I clicked on the ad, I was directed to a site that looked like an online news publication, called the Online Career Journal. The article on the site, stated how Melissa Johnson of Austin, Texas (my hometown) made $8,000 a month just by using a work at home kit that cost less than $50.
Because I’m familiar with this type of deceptive advertising, I immediately went to the bottom of the page where it stated the following:
“As an advertorial, this page receives compensation for clicks on or purchase of products featured on this site. This program is not a job but an educational opportunity that can help individuals learn how to earn money through their entrepreneurial efforts. Anyone who decides to buy any program about making money will not necessarily make money simply by purchasing the program.”
So obviously, this was not true editorial content, but indeed an advertisement for a work at home kit called, Profit Web System.
But, what is Profit Web System?
Angela BussioWhen I clicked on the Profit Web System’s link, it brought me to a landing page with Angela Bussio’s image and name on it. Not being familiar with Angela Bussio, I decided to Google her. From what I could find, she appears to be a speaker, author and life coach, owning the following businesses: Attracting Joy, Design My Destiny, and Real Stress Solutions.
While I didn’t see anything out of the ordinary on her websites, I did find her Facebook Fan Page (Real Stress Solutions) of interest. Numerous individuals had left negative comments about one of her programs, Profit Master’s Academy.
I also performed a Google keyword search on “Angela Bussio + scams” and I got a lot of negative results. You can check out a few of the negative comments listed on the Ripoff Report. I decided to take my research one step further, by contacting Angela via email to see if she endorsed this program, and if she did, what exactly was it?
I never received a response back.
Basically, Profit Web Systems claims that individuals can make money by placing links for companies on various websites. They even claim, that you can make $15 per link placed. So, if you place 10 links an hour, you’ll make $150 an hour. To learn how to place these links, you need to purchase their program which is a hefty $97.
So would I ever recommend this program for individuals who want to work from home?
Absolutely not!
This type of scam has been circulating around since 2009 under various names like Easy Google Profit, Home Cash Kit, and Google Money Master.  In fact it’s become so popular, that Snopes.com wrote a scam alert about it.
So what red warning flags should you watch out for when looking for work at home opportunities?
  • Vague job descriptions
  • Lack of contact information
  • High payouts with little or no work
  • Poor ratings on the Better Business Bureau website
  • Deceptive marketing and advertising practices
  • Boasting fake affiliations and partnerships
  • Negative reviews
  • Too good to be true offers
If you’d like to see what this deceptive work at home opportunity looks like, you can check it out at the links below. I have also seen this type of opportunity being promoted with Kelly Nelson as the subject, and the product being called the Internet Biz Kit.
http://www.careerjournalonline.net/latest/workfromhome/trifu/00aoz3/us3/
http://profitwebsystem.com/pmaangela97/congratulations.aspx
http://profitwebsystem.com/pmaangela97/
Have you fallen prey to a work at home scam?
Looking for legit work at home jobs? Check out FlexJobs where every job is hand-screened and legitimate, guaranteed!
The views and opinions expressed on this article are solely those of the original author. 
Update 03-03-2014 – I received this email from Angela Bussio:
Holly – I saw your article reviewing a product with my name on it and I want you to know that whomever is using my name is committing FRAUD. I am currently in conversations with FBI and Google legal to get many of these listing de-indexed and to stop using MY NAME for Adwords campaigns! Unbelievable! These are fraudulent reports and sites using my name – and it has been difficult if not impossible to track down whomever is doing this – but I think it is important that you are reporting a SCAM that is actually a SCAM!
I did a Promo video for a “friend” a couple of years  ago, in exchange for them offering my newsletter “Real Stress Solutions” ( which is what I reaLLY DO) as a bonus when they signed up. They ended up Branding the product with my picture making it look like it was my product. I have been in legal entanglements with them since and just received  a settlement to start to clean up my reputation – just as they were endicted by the FTC and had all their assets frozen.
Since then – other people have actually branded me on their products with my pictures and even made fake videos of another woman with my name on them! They have all been reported to the FTC and now many of the sites are gone. I would just like your help in getting the word out that these scams are actually scamming ME as well as the consumer.
If you would like to talk to me about this issue, I am happy to have that conversation. These are NOT MY PRODUCTS and you are advocating for people like me that get scammed. I would love to let your audience know what happened to me and how they need to be so careful who they partner up with – even if it is a “friend”. In fact I have even spoken to audiences to warn them about the unintended reputation consequences of bad partnerships.
I have never done anything to hurt anyone – in fact I personally have an “A” rating with the BBB – so this whole situation has been so upsetting to me. I am a therapist that just thought I could help more if I took my products and frame worked my therapies for consumption online. I have NEVER had any product that has anything to do with Home Based Business. I was very naive – now I am cleaning up a big mess.
Please call me if you need any more clarification and I would appreciate you clarifying to your audience the situation if you have the heart to do that. These are the links to my REAL business:
  • http://www.attractingjoyu.com
  • http:www.angelabussio.com
Thanks Holly – this is really important to me that the truth gets out there.
Angela Bussio,
CEO/Founder Attracting Joy University
Editor/Publisher Real Stress Solutions

Franchise

By Holly Reisem Hanna
So you want to have your own business, but you’re not sure where to start. You don’t have a business plan and you’re not sure about the logistics of marketing, sales, human resources, customer service, accounting, legal compliance AND you would like an opportunity with a low risk potential. A franchise may be the perfect work at home business for you!
A franchise is a successfully proven business model that it easily replicated. The nice thing about a franchise is all the hard work has been done for you; you basically pay for the franchise and you’re given a detailed manual and tools on how to replicate the business exactly. Many franchises also have well known established brand names  too, so you spend less money on marketing your business.
We’ve all heard of franchises like Starbucks and McDonalds, but there are also some great franchises out there that will allow you to work from home, like Fit 4 Moms. With over 1,500 different franchise companies in the USA, you are bound you find one that fits your interests and skills.
The downside of owning a franchise is the initial cash requirement is generally a very large amount, and many franchises require you to pay monthly maintenance fees.
So if you are a people person, enjoying following a set system, can easily ask for help, and you generally like to avoid risk, a home-based franchise may be the perfect opportunity for you! See the resources below to get started.

Home-Based Franchise Opportunities

Franchise Resources

Great Home Based Franchise Opportunities
Coming up with great business ideas can sometimes turn people off of starting a home based business, but there are great home based franchise opportunities that are available through established companies to get you started. Franchises are no long just for fast food or gas stations – they have expanded into your home.
The great thing about purchasing a home based franchise is that you are starting off with an already successful company that will provide you with training to make your business more profitable. That training often means that, even if you do not have any prior experience in certain areas, you can learn the business quickly and effectively.
One popular home based franchise is in bookkeeping/accounting. Companies such as PFO Today and Padgett Business Services offer franchises and training opportunities. If you are a certified accountant, there are a number of franchise opportunities open to you.
Another home based franchise opportunity is in computer repair. Geeks on Call and Rescue.com offer franchise opportunities, so if you always tinkering with your own computer or fixing everyone else’s computer, this may be a great opportunity to make money from your hobby.
Are you a Monica – the compulsive cleaner from Friends? If so, then opening a cleaning franchise may be your dream home based franchise opportunity. Actually, many of the home cleaning businesses around are run out of the owner’s home. Check out some of the cleaning companies to see if they are selling franchises.
Just like cleaning companies, carpet cleaning businesses are almost all run as home based franchises. ServiceMaster and Chem Dry are two of the most well known companies in the carpet cleaning industry, and they offer home based franchise opportunities.
Finally, there are home based franchise opportunities out there in the pet business industry that is thriving. Doggie day care, pet-sitting, pet treats/food are all great businesses to do from your home. There are a number of companies offering home based franchise opportunities. Check out Pet Sitters, International, top dog Daycare and even Three Dog Bakery for great opportunities.
Read the rest of the article here: Great Home Based Franchise Opportunities.
Copyright © Charles Fuchs is an established Six Figure Income earner and one of the top online marketer’s. He specializes in helping people start their very own Work at Home and Home Based Business on the internet.

WAH Jobs

By Holly Reisem Hanna
The companies listed below regularly hire individuals for home-based positions – some positions are freelance, some are independent contracting, and others are full-time gigs with full benefits. While all companies are believed to be legit, they have only been soft checked, meaning that I did a quick search to see if there were any negative reviews or ratings. As is always the case, you need to do your due diligence (research the opportunity extensively) prior to enrolling in any business opportunity or applying for any job.
Looking for more legit work at home jobs? Check out FlexJobswhere every job is hand-screened and legitimate, guaranteed!

Appointment Setting:

Intelemark is seeking experienced B2B Appointment Setters, lead generation professionals, and professional B2B communications specialists who are comfortable speaking with C-level decision makers and delivering a value proposition in a most appropriate and professional manner. Requires good computer skills, accurate record keeping, data input, email communication, ability to write at a high level, and managing multiple calendars. You are required to have and maintain your own home office set-up in a quiet, professional environment with dedicated phone line including unlimited long distance, high speed internet, and a relatively new and fast computer as you will be accessing our lead management application in the cloud. Starting pay is $14.00 – $16.50 per hour based on previous, verifiable experience. APPLY HERE: http://www.intelemark.com/work-for-us/

Call Agents and Virtual Receptionists:

ACD Direct is a business that offers contact center solutions to businesses. ACD Direct hires home agents to make inbound and outbound calls, see site for more details.
Alpine Access provides customer service solutions for businesses. This company is a member of the Better Business Bureau and hires at home customer care professionals. Average pay is $9.00 per hour. Please note that they do charge a $45 fee for a background check.
Arise – For over a decade, Arise has pioneered a unique businesses model working with a network of at-home independent businesses capable of providing call center services for Arise clients, which include many Fortune 500 companies. Essentially, the next time you call a company to make a reservation, or dispute a bill, you may be speaking to a small business owner working from home. Arise creates thousands of work-at-home opportunities each year.
Aspire Lifestyles hires home-based concierge personnel to assist companies with responding to customer service queries and client requests for information via phone, email, and chat. Positions available in the US, Canada, the UK, and Singapore.
ContractWorld hires work at home customer reps for large companies like, Pizza Hut, Loreal, and KFC.
Convergys hires home-based call agents to provide customer service support. This company offers paid training, hourly wages, as well as benefits like, paid time off, 401k retirement plan, life insurance, medical, dental, and vision. See site for more details.
Fancy Hands hires remote-based workers to complete customer service requests like: Making phone calls on behalf of people, scheduling appointments, tracking down the best price, finding hotels, and data entry.
GabbyVille hires home-based Virtual Receptionists. Unlike some of our competitors, employees aren’t a commodity to us. We strive to draw out each person’s strengths and put them to work for our customers. Because, we believe that top notch customer service can only be delivered by happy employees. We work for our clients Monday-Friday from 9am – 8pm EST. So, we offer our employees the option of working shifts that work with their lives. Business Services Associates must be able to type 50 wpm (minimum), provide exceptional customer service, possess extraordinary oral and written communication skills, and must have previous answering service or receptionist experience. If you’d like to become a GabbyVille Business Services Associate, send us a cover letter and resume to career@gabbyville.com.
Just Answer is a website where any question can be answered by a live operator. Become a live virtual agent; get paid a percentage of all answers that are accepted.
Liveops is a virtual call center company. They hire at-home agents to perform inbound and outbound calls for customer service, customer acquisition, customer retention, revenue maximization, political, disaster relief, incident response and fundraising.
Sutherland Global Services hires remotely for tech support, customer service, back office, inside sales, as well as management and supervisory positions. Both part-time and full-time candidates receive paid training and flexible hours. Positions are available to US and International residents alike.
Talk 2 Rep hires at home agents to conduct various phone items, such as to sell a service or product, conduct a telephone survey, upgrade a customers’ service or handle a customers inquiry.
TeleReach offers telephone marketing services. This company hires home-based positions in, appointment setting, lead generation, information gathering, seminar reservations, website marketing, product introductions, trade show follow-up, direct mail follow-up, prospect education, script development, list development, list updating, database sourcing, list merging, prospect, identification, tracking reports, prospect feedback and program evaluation.
VoiceLog is a company that offers third party verification (TPV) services. They hire work-at-home positions for live operators – independent contractors, TPV Agents with multiple foreign languages available. Live operators make $8.50 per hour where TPV agents are compensated per call. Can work as little as 3 hours per shift.
West at Home offers home-based positions for home agents that complete customer service calls. Pay is based on per minute rate or per call rate. This company offers paid training.
Working Solutions hires independent contractor home-agents to provide sales, technical support and customer service. Home-agents can put their experience to work and enjoy the freedom of working when they want, where they want. They select highly educated, experienced professionals with product knowledge, certifications and industry experience to match our clients’ business needs. They never charge any fees. Home-agents earn anywhere from $8.00 -$20.00 per hour, depending on the program.

Over 100+ Work at Home Job LeadsDigital Earning:

CashCrate is an online platform where you can start earning money by completing offers, taking surveys, watching videos, and shopping online using their site. I’ve played around on the site a little bit and you’ll want to make sure that you read all of the fine print on each and every offer. Many offers require an email address, which means you’ll receive offers from them and other marketers. Tasks pay out anywhere from a few cents to $30.00 or more, and you’ll receive a $1 for signing up for an account. Payments are made via check or PayPal.
Fusion Cash is an online platform that allows you to make money from taking surveys, watching videos, shopping, completing short tasks, and much more. Sign up and immediately earn $5.00 just for joining. Most offers pay between .25 to $30 per offer, and payments are made via PayPal, check, or direct deposit once your account reaches a $25 threshold. Some offers do require a credit card number, so if you don’t feel comfortable giving out that information, just stick to the offers which display the No CC icon. Fusion Cash is a member of the Better Business Bureau.
InboxDollars here you can earn cash for surveys, reading emails, playing games, redeeming coupons, searching the web and shopping online. Membership is free and you’ll receive $5.00 for signing up. Payments are made via check.
SwagBucks is an online platform where you can earn digital dollars called Swag Bucks, which can be redeemed for gift cards and coupons. You can easily earn Swag Bucks by watching videos, playing games, answering questions, shopping online, and even surfing the web using their tool bar. Refer your friends and you’ll earn even more Swag Bucks. Your digital dollars can be traded in for gift cards from Amazon, Target, Starbucks, PayPal, and Walmart.

Direct Sales Opportunities:

Please Note: These business opportunities require a small investment upfront, but give you all the tools and support that you’ll need to start your very own home-based business in the direct sales industry.
ABC Fundraising –  Earn up to $5,000 per month or more! Work from home setting up fundraisers for schools, churches and non-profit organizations. Since 1993 ABC Fundraising has helped over 50,000 groups raise over 50 million dollars and we want to help you start a new career today. Recently one of our distributors earned $7,200 by simply setting up a school-wide fundraiser with our flagship fundraising product. Get a FREE information kit now and sign up for our free online webinar to learn more about this exciting business opportunity.
Avon – At a time when opportunities are scarce and finances are tight, you can start an AVON business and EMPOWER your life. As the world’s largest direct selling company and leader in beauty, anti-aging skincare, and fragrances, we make it easy for you to sell and succeed, right from the start. Why Sell AVON? You have your own business, You set your own hours, You determine your family/work/lifestyle balance, Minimum start up investment, No inventory required, and Exclusive Avon Opportunities. See why more than 5 million people around the world are enjoying financial success and personal growth as Avon Sales Representatives. Join today!
Beachbody – If you love helping people, are passionate about Health and Fitness, and want the opportunity to work from home with unlimited income potential, health and fitness coaching may be the right fit for you. Beachbody is the creator of well-known home fitness programs such as P90X, Insanity, Turbo Fire, and more. As a coach, it’s your job to keep accountable, motivated, and supported your customers who start these programs at home and make sure that they finish them and reach their goals with Success! Your job can be done all online. It’s your chance to end the trend of obesity and help others on their journey to a healthier and happier life!
Become Beauty – Sharing the gifts of become has it’s privileges – generous product discounts, earn extra income for you and your family, travel to exotic destinations, and make memories that last a lifetime. Spend only a few hours a week sharing our Australian beauty secrets and helping everyone you touch become beautiful inside and out. With a small fee and minimum start-up order, you will be on your way to living the life you love.
CAbi – Simply put, CAbi is a designer clothing Collection sold in a relaxed home environment by a trained fashion Consultant. But as any Consultant will tell you, CAbi offers so much more than clothes. Imagine setting your own hours, affecting lives through relationships, and calling your own shots! CAbi is all about giving women their lives back and enabling them to put first things first … all while building a truly sustainable career.
Chelsea Row – There are two things that make Chelsea Row awesomely unique: incredibly powerful online selling tools and an amazing GROUND-FLOOR OPPORTUNITY. Boutique Owners who join now have a chance to shape the future of the direct selling industry and, even more importantly, their own careers. Our virtual trunk show party technology is designed to take your business to an entirely new level. You and your guests will see, hear, and shop with each other in a live video setting. It’s all of the fun of an in-home party with less time and no travel! Plus, our hostess rewards and compensation plan are fantastic, and our gorgeous jewelry comes with a lifetime warranty!
Dakomoda – What parent doesn’t want to dress their child in fashionable clothing made from superior materials? The problem of course, was that most parents couldn’t’ afford such luxury … until now! Experience the joy of beautiful clothing, community and profits of your own flexible home business. No need to be an experienced sales person to succeed. If you are a mom you are a natural sales person! Home Showcases are the heart of our business. Our hostesses are special and we genuinely appreciate them. Dakomoda hostess rewards are truly generous and help our partners earn generous commissions and our hostesses tons of free products. Join us today!
Healthy Hands Cooking provides stay-at-home moms with a passion for nutrition and kids, the chance to make a healthy income, while making a difference in kids’ lives. Keep 100% of your income, empower kids in your community with vital healthy living skills, and LOVE WHAT YOU DO!
Initials, Inc. business opportunity is creatively addressing the 14 billion-dollar handbag and home organization industry in a fresh way. With a hip, entrepreneurial approach and solution-based design, we have combined the best in class to create a new kind of business for women. On average new consultants earn $49 per hour and pay for their Starter Kit with their first party. Confidently build a business with Initials, Inc. and transform your future. We firmly believe that there is only one you! We inspire bold style, big dreams, and your best life! www.initials-inc.com/join
J. Hilburn – Join me, and a fabulous group of men and women, in selling men’s clothing for J. Hilburn, a men’s luxury retail brand. Being a stylist for J. Hilburn is the most flexible, lucrative, and fun job I’ve ever had. Start today by reaching out to me at denise.rosenblum@jhilburnpartner.com and check out our website deniserosenblum.jhilburn.com.
Jeunesse – Welcome to Generation Young! Jeunesse offers products that are at the cutting edge of technology and are perfectly positioned in the booming anti-aging marketplace. Partnering with us means you have an opportunity to work from the comfort of your own home, on your own time and you get to decide whether you want to create a part-time income through retail sales or build a full-time business. Click the link to learn more!
Kaeser & Blair is a leader in the $20 billion promotional products industry. We help entrepreneurs establish their own independent businesses helping companies build brand awareness and sales with high-quality imprinted items. As an independent dealer, you’ll sell to businesses, non-profits and schools with no parties, inventory to purchase or recruiting. We’ve helped thousands of women realize the career, earnings and work/life balance they deserve. We’re a rock solid family owned and family operated business that’s been in continuous operation since 1894.
KOKOON boutique without borders is a completely unique fashion company offering limited edition designs, all proudly made in the USA. An ever-changing selection of beautiful, contemporary styles designed for the busy, modern woman. With only 75 Representatives nationwide, KOKOON is the perfect flexible business opportunity for the socially savvy entrepreneur.
Makeup Eraser – Distributors and Free Affiliates wanted! High income potential with three ways to earn and a ground floor opportunity. Makeup Eraser offers a product that every woman needs: a reusable and chemical-free cloth for face cleaning and makeup that only requires warm water to perform beautifully. Follow the link to see a demo and learn more.
Nature Unleashed – Home is where the heart is … so if you have a passion for being proactive and protecting your family from harmful chemicals with your everyday cleaning, first aid, personal & animal care, then you may be interested in learning more about the rewards of becoming a Brand Ambassador for Nature Unleashed. If you enjoy helping others do the same while achieving personal financial fulfillment, all while working from home, then you may be interested in learning more about becoming a Brand Partner with Nature Unleashed. At Nature Unleashed, unleashing your potential and owning your own business is simple to start … simple to share … and simple to soar! Click here to learn more!
PARIS a Vous – Exclusive Direct Sales Company & Ground Floor Opportunity! Ever thought of owning your own French Bistro? Café? Or just sharing in the pleasures of the “French way of life”? Well, now you can! Looking for LEADERS who are excited to be pioneers and launch this amazing brand. Stipend offered to TOP leaders to aggressively launch and stimulate growth. Outstanding commissions, daily payout, bonuses and all-inclusive trips to France.  The only company offering authentic, all natural, French specialty foods in the growing specialty foods market. French wines, linens and home décor products soon to come. Enjoy a night of romance, indulgence and the traditions of France – No Passport Needed!
pawTree  – sit. stay. be social. – Start an adventure with your pets that is not only fun but profitable. Join pawTree and become a Sr. petPro by December 31,2014 and you will become one of our first founders. Our back office contains all the training tools you will need to make becoming a successful petPro Founder and leader.
Rodan + Fields – Redefine your future with the new breakthrough skincare experience from Rodan + Fields. Learn what’s possible when you combine the biggest names in skincare, an innovative business model and clinically-proven, award winning products. This is a particularly compelling time to be a part of Rodan + Fields as we are  expanding nationwide in 2013 and entering Canada in January 2014. Think this might be for you or someone you know? Contact me to learn more about the products, business opportunity, and my generous referral program!
Stella & Dot – Run your own fashion social selling business. Stella & Dot is so much more than a fashion brand – we are inspired by, and created for, strong women just like you! We designed a smart, stylish business that works when you do. Plus, Stella & Dot is more than just a company – it’s a community. At Stella & Dot, success is defined by your happiness. It’s your business, your pace, your way.
Traveling Vineyard – Pop open opportunity and get ready to change your life one cork at a time. The only real requirement of this job: being awesome. It helps if you like wine, too. Other than that, the rest is easy peasy. Maybe you’re looking for a little extra spending money. Or maybe you just need a reason to get out of the house. Your reason for becoming a rock star Wine Guide is up to you. But the opportunity is all yours—all $30 billion of it. You ready? Let’s rock this dream.
Younique – Uplift, Empower and Validate. That is what Younique is all about. The brother/sister team who cofounded this company firmly believe that women should feel valued, smart and empowered through opportunity of personal and financial reward. Younique is fairly new and very fast growing all-natural based quality make-up company best known for their Moodstruck 3D Fiber Mascara, so now is the great time to get in early!  This company thrives through a team based approach model. Whether you just want to earn enough money for a mani/pedi each month or work your way to the top, the opportunity is up to you, with the backing of a great team to help you along the way! Get paid within three hours of every sale to use for those immediate needs. Younique is the first direct sales to sell almost exclusively through the use of social media. You decide if you want to take it on the road. The choice is yours, what will you decide?

Editing:

Cactus hires freelance workers for various editing positions. Editors do not need prior experience in English editing. You should have a love for the language and the ability to explain your subject matter in grammatically correct English.
CyberEdit, Inc. offers highly-educated editing, resume writing, and technical writing services. Hires freelance Resume Writers & Essay Editors from Harvard, Stanford, Yale, Columbia and Princeton. Compensation ranges from $15.00 – $35.00 per hour.
Edit Fast is a company that offers editing, proof-reading, writing and indexing services. Hires freelance Writers, Editors and Proof-Readers. Editors bid on projects and Edit Fast charges the client an additional fee.
First Editing only hires experienced editors, but offers full-time and year round work in various editing capacities, such as, copy editing, business editing, proofreading services, book editing, thesis editing and many more.

Educational Political Calls:

NextWave Advocacy, LLC contracts with news junkies that are politically aware, home-based individuals who are critical thinkers to make outbound calls to educate citizens and help them participate in contacting their elected officials. No sales or fundraising calls are involved. This is not a telemarketing opportunity. The pay is $12.00 per hour with a minimum commitment of 20 hours per week.

Expert Advice:

Createpool is an online marketplace for information selling in the following areas (pools): Programming, Academics, Auto Repair, and Legal Advice. To become an expert, create an account, search online for questions, give advice, then make money. Createpool deducts a 20% service fee from each transaction and payments are made via check or PayPal.
Ether is a company that sells expert advice by phone and email. Set your rate and hours, they take 15% of what you make. Some examples are a therapist, doctor, nurse, tax expert, teacher offering their expertise to customers.
Check out this post for 9 more places to sell your expertise.

Marketing:

Finding Freedom Team! – Work for yourself, NOT by yourself! Team up with a motivated, compassionate group of women and make a difference in your personal and financial wellness! No sales, no risk, no “buy in”. Work when you want to, love what you do! We market a billion dollar, Fortune 500, Wellness Company. I’d love to show you the steps to improving your financial future!

Mystery Shopping:

Call Center QA is always hiring Telephone Mystery Shoppers from the United States. Work from home making calls and completing short online forms. Flex hours and great pay. No upfront costs or background checks. Payout via PayPal within 24 – 48hours. We have employed and paid thousands of people across the United States.
Corporate Research International is a mystery shopping organization. Mystery-Auditors (Mystery Shoppers) conduct phone and on-site evaluations. Membership is free. This company is a member of the Better Business Bureau.
Mystery Guest Inc. is a research powered marketing group. This company hires “Mystery Guests” that visit a business then complete an online survey. Participants will receive a subsidy or gift as stated in the contract. Membership is free. This company is a member of the Better Business Bureau.
Service Intelligence Experience Exchange is a company that offers Mystery Shopping services. Mystery Shoppers are paid $7.00 – $20.00 per job. Membership is free. This company is a member of the Better Business Bureau.

Nursing:

Aetna hires nurses to work from home (telework) in case management, pre-certification and as nurse consultants. Candidates must have RN license.
Fonemed hires home-based Nurses for triage calls and home based Customer Services Reps. Nurses must have RN license, pay is based on per call rate.
Humana hires home based nurses for Inpatient Case Managers, Concurrent Review and Case Management. Candidates must have RN license.
McKesson hires nurses for triage calls. Search for positions by remote or “work from home” with city and state blank. Candidates must have RN license.

Online Juror:

eJury.com is a tool that attorneys use to get ready for trials. Participate in mock jury; get paid $5.00 – $10.00 per case.
Online Verdict.com is a tool that attorneys use to get ready for trials. Participate in mock jury; get paid $20.00 – $60.00 per case.
Trial Practices, Inc. is a tool for attorneys to use to prepare for a trial. Participate as a mock juror and get paid $10.00 per hour.
Zap Jury is a tool that attorneys use to get ready for trials. Participate in mock jury for fun and/or money. Attorneys decide what they will pay per case, you can also be rewarded for referrals, see site for more details.

Sales:

Babee Covee is seeking enthusiastic and trend setting sales reps (showroom and road) to increase brand awareness and sales for major market territories in both USA and Canada. Outstanding customer service is required. Reps with existing account-base and experienced commission-based sales would be appreciated. We have leads ready to hand over. Babee Covee is one blanket used for six convenient uses from newborn through toddler years. The patent pending design is made, tested and approved by Moms. It has it all from fashion, versatility and convenience. Our products are tested to be baby safe and are manufactured in the USA. Learn more at http://babeecovee.com. Contact Alma Moussa for immediate consideration, phone: 925-302-9090 or email: service@babeecovee.com
DVMelite – We are seeking a customer focused consultative sales person! We are a cutting edge technology company in the medical industry providing marketing services to small and medium sized independently owned practices. In this position, you will be acting as a full cycle inside consultant, which means you will be conducting 20-30 minute consultative sessions with warm prospects that are booking an appointment to speak with you. This position is a fit for a person who is experienced in business, is tech savvy, and able to take a consultative approach with prospects; understanding their business and being able to make a well informed decision while still having an understanding in consultative sales. There is paid training and you would be on a 3-4 month hourly pay schedule until you reach the level needed to transition to the regular compensation of activity based plus commission. Many get up to $2-4k per month for PART TIME work so if you have a “let’s build something great” mentality and are a true client focused sales person and ready to prove it, we look forward to hearing from you!
Extended Presence hires home based Sales Professionals. This company offers training, competitive hourly base/salary and monthly bonuses.
Generation Sales Group hires individuals to complete sales calls, lead generation, and appointment setting tasks.
Intrep Sales Partners hires U.S. home-based sales consultants for appointment setting, lead generation, list acquisition, script development, admin support and database management. Has an A+ rating with the Better Business Bureau.
Zahavah Jewelry currently has positions open for home-based sales reps. This is a fun and easy job that can be done from your home office and by visiting stores in your area.  You will set up wholesale accounts and receive a commission on the pieces that are sold for the time that you work with that store. You will also receive commission when selling pieces to individuals and referring clients to our online store. This also applies for our Wedding Line. Positions are available now, contact for details.

Short Tasks:

Amazon Mechanical Turk here you can make money online working on HITS (Human Intelligence Tasks). A few of the tasks that I saw listed were, transcribing information from a business card to a form, payout $0.02 cents. Another task was to transcribe a voice-mail from audio to text (audio length 3 hours), payout $76.19. After you complete the task and the requester approves your work and the money is deposited into your Amazon account.
ClickWorker is an online platform where you can get paid for writing, translating, researching and collecting data. To get started create an account, fill out your profile, complete a qualification assessment, then bid on jobs. Payments are made by SEPA bank account transfers and via PayPal once your account reaches $1.00 and your tax information has been completed. ClickWorker’s clients include Groupon, Tennis Point, Honda, PayPal among others.
CrowdFlower is a virtual workspace where you can earn money by completing simple tasks on your computer. Tasks include Internet research, data collection, data categorization, content creation, content moderation, surveys, etc. While I was unable to find any information on pay rates and how and payments are made, CrowdFlower does have an A rating on the Better Business Bureau website and has been featured on sites like Forbes, the LA Times, and Telecrunch.
CrowdSource allows individuals to complete a variety of tasks, everything from from online profile verification, to writing, editing and marketing. According to their expected earnings information, writers can make $15.00 – $25.00 an hour, editors can earn $10.00 – $35.00 an hour, and market writers can make $12.00 – $20.00 per hour. For the higher paying projects, you will need to pass certain credential tests. Staples, Shutterfly, and Overstock are some of the companies that use CrowdSource.
Humanatic – Earn money from home with no start up cost! Humanatic is an awesome community of 40,000 real live people just like you that listen to pre-recorded phone calls for businesses across the world right from their home office. The amount of money you make is up to you, and there are no limits! You get paid for each call you review correctly and advance when you do well to higher paying categories! You can make it a part time job, full time job– it is really up to you! Tell your friends to get involved too, because we offer a sweet referral bonus!
The trivago Community is a platform where members working from home can write hotel and attraction descriptions, add new hotels to the website and complete existing hotel profiles, just to name a few activities. We are looking for motivated lovers of travel to help us make trivago the most comprehensive hotel search on the planet!
For more short task sites, click here.

Stylists:

Keaton Row is a free business opportunity where you act as a personal stylist for individuals. Earn commission on all items that you sell and even get free fashion and business training.
Stitch Fix is an online, fashion subscription site that hires part time stylists to work from home. Using the Stitch Fix online styling platform, stylists curate fashion solutions for clients. Must love fashion and have the ability to work between 15 – 29 hours each week.
Check out this post for more stylist positions.

Surrogacy:

ConceiveAbilities: Have you considered changing lives as a Surrogate Mother? Surrogacy offers women the unique opportunity to earn reimbursed compensation while having the time they need to spend with their family. We look forward to welcoming you to Team Baby! Are You Ready To Change Lives? Start Your Application Today!

Surveys:

MindField Online is an online survey site where you can earn cash for taking surveys. Simply sign up for an account, fill out your membership profile (you’ll get more surveys by doing so), complete surveys and once your account has reached a $5.00 threshold, you can request payment via check. MindField not only has an A+ rating with the Better Business Bureau, but they’re also a member of CASRO, which requires members to adhere a strict code of ethics and standards for survey research.
Survey Savvy is an online survey site where you’ll get earn money for sharing your opinions with companies. Most surveys pay out between $1.00 to $20.00 depending on the length and topic of the survey. Once your account has reached $1.00 in rewards, you can request payment via check. Survey Savvy has an A+ rating with the Better Business Bureau.
Tell Wut is a survey site where you can win prizes and earn rewards for sharing your opinion. Most surveys award 5 to 15 points per survey, but you can also earn points by referring friends (25 points), creating an account (100 points) and providing your information (100 points). Points can be redeemed for Best Buy, Walmart, Barnes & Noble, Visa, and various other gift cards. Tell Wut has an A- rating with the Better Business Bureau.
Toluna is a survey and product testing site where you can earn points for participation. Most surveys and questionnaires take 15 – 20 minutes and members earn anywhere from 15 – 20,000 points depending on the length. Points can be redeemed for sweepstakes tickets for gadgets or getaways, vouchers for stores like Amazon, even cash. Payments are made via PayPal and check.
Valued Opinions allows you to participate in  surveys and earn points for doing so. Points can be redeemed for gift cards from major retailers and brands like Macy’s, Amazon, and Marriott. Earn even more by referring friends, in fact you can earn up to $2.00 per friend who joins and completes two surveys.
Check out this article for more paid survey sites.

Teachers and Tutors:

K12 offers individualized and tuition-free online public schooling and has a variety of job openings for virtual teachers grades K – 12, in varying disciplines.
Kaplan hires remote based tutors and teachers for a wide range of subjects and areas from after-school programs to test preparation, higher education and professional training. They are looking for experts to teach finance, accounting, business, insurance, IT, real estate, legal, healthcare courses and much more.
Tutor.com is a company that offers tutoring services 24 hours a day, 7 days a week. To become an at home Tutor you must fill out an application and pass an extensive screening process. Tutors can work anywhere from 5 to 30 hours per week. Offers competitive pay rates.
See here for more teaching and tutoring jobs.

Tech Advisors:

Apple hires at home advisors for trouble shooting tech problems and issues.
Computer Assistant hires remote technicians to provide tech support for a variety of companies.
Dell hires remote tech support for a variety of positions.

Transcribers:

Production Transcripts provides transcription services to clients. Hires highly-proficient, experienced freelance, home based Transcribers, sporadically. See site for more details.
Tigerfish offers Transcription, Proof-Reading, Editing and Audio Engineering services to clients. Hires freelance Transcribers, see site for more details.

Virtual Assistants:

247VirtualAssistant.com is based out of Atlanta, GA and is hiring US based Virtual Assistants to work with clients on tasks such as office administration, project management, phone presence and other Virtual Assistant duties. Applicants are being considered for both full time and part time positions with flexible schedules, depending on the clients anywhere from $10 – $40 per hour depending on client requirements.
EA Help hires remote-based workers to assist their clients with administration and task project management. Applicants should have a bachelor’s degree and at least five years of experience as an executive assistant, project manager, or similar role.
oDesk is the world’s largest online freelance job board, where virtual assistants can search for administrative jobs, gigs and tasks.
Team Double Click is a company that provides professional virtual office assistants. Hires virtual sales associates, virtual services representatives, public relation virtual assistants, general virtual administrative assistants, and real estate virtual administrative assistants. Pay varies for each position, see site for more details.
Time Etc. hires part-time virtual assistants. If you have experience as a personal assistant, executive assistant, secretary, or admin assistant and can work for at least three hours per week – Time Etc. wants you. Pay ranges from $11 to $16 per hour, depending on your experience.
Virtual Office Temps offers professional business services: clerical support, administration, creativity, management, sales support and personal services. Apply to be a home-based virtual assistant and make $10 – $35 per hour based on project.
Zirtual is a San Francisco based company that hires U.S. based, remote workers to work as zirtual assistants. Full-time ZAs start at $12 per hour and work from 9am to 6pm each weekday. Part-time ZAs work from 10:00am to 4:00pm each weekday and start at $10 per hour.
Here are more sites that hire virtual assistants.

Virtual Public Relation Representative:

Bisbee & Company is a virtual public relations agency. Contact for more details on home-based PR positions.
Orca Communications is a PR firm for inventors and entrepreneurs. See site for various media and PR home-based positions.
Perkett PR is a virtual PR firm specializing in PR, social media, training and digital platforms.

Web Search Evaluators:

Appen Butler Hill hires search engine evaluators to provide feedback on Internet search results. This part-time telecommuting opportunity is open to both US and International residents. Average pay is $14 an hour.
iSoftStone hires independent contractors to evaluate search engine results to see if they are relevant to the term that was typed in. Average pay is $12 per hour.
Leapforce hires at home agents for search engine evaluator jobs in various languages. This position is open to US and International residents alike. Average pay is $14 an hour.
Lionbridge has work at home opportunities for Internet Assessors who evaluate the results of web searches. Position is open globally and individuals can work up to 20 hours per week. Average pay is $13.50 per hour.
Zero Chaos (Google Ad Rater) hires part-time telecommuters (10 – 30 hours a week) to evaluate the accuracy of Google ads. Applicants must have a BA or BS degree, be located in the US, and speak fluent English. Average pay is $15.00 per hour.

Website Testers:

Userlytics hires people to provide feedback on websites, applications, prototypes, concepts and more. To apply, register for an account, and then wait for an invite to complete an assignment. Once you’ve completed your assignment you’ll be paid $10 per task via PayPal.
User Testing hires people to test out websites. Each assignment pays $10/$15 for 20 minutes of work. To become a user tester submit your email address and apply to be a tester. Testers must take a sample test before receiving any assignments. Each test takes about 15 – 20 minutes and payments are made via PayPal.
Here are 9 more sites that will pay you to test out websites.

Writing Gigs:

Demand Studios hires freelance writers, copy editors and film makers.
Elance is an online job board for freelancers, search for various writing jobs (article writing, web content, copywriting, ebooks, blogging, etc) as well as design and programming jobs.
MetroParent is looking for talented, experienced freelance writers to write on parenting issues, kids, tweens, family travel and the like. Payment ranges from $30 – $350 depending on complexity of topic and number of sources required to do the story justice.
NextWave Advocacy, LLC contracts with politically aware, home-based individuals to draft advocacy letters on local, state, and national legislative and regulatory issues. The work does not involve creative, technical or copy writing. It requires the ability to express others’ ideas and thoughts in a letter format. The pay is $13.00 per hour with a minimum commitment of 20 hours per week.
Here are 75+ legit sites that will pay you for your writing.
For more money making opportunities, click here.
This page includes some affiliate and referral links. Please be aware that we only promote advertising from companies that we feel we can legitimately recommend to our readers. Please see our disclosure policy for further information.