Seattle Access Group

Welcome to Seattle Access
A Forum for Microsoft Access Users and Developers
www.SeattleAccess.org
Your source for meeting information, newsletters and presentation content for

the Seattle Access Group  (meeting info)
and the
Pacific Northwest Access Developer Group (meeting info)

   Items For Immediate Attention
             SAG and PNWADG

t t LIVE MEETING SESSION -- January 17, 2012 t t

January 17th Meetings ...   Newsletter
                                l Live Meeting Only l
With the forecasts and predictions for areas of treacherous driving conditions, we will hold a Live Meeting session in lieu of meeting in Redmond (a one time exception). Although an online session does not provide us with the same personal interactions and networking opportunities, it does allow us to connect, exchange ideas, answer questions and continue with Scott’s presentation.

The meeting will start at 7 PM ...
Please allow plenty of time to install Live Meeting and get familiar with the setup. We ask that you mute your microphones, but you will need your computer speakers to hear the presentation.

Join the meeting
Meeting ID: PNWADG_SAG
Entry Code: AccessUG

l The meeting location will change monthly! l
Please mark your calendars with the date and location.

Date

Room

Note

1/17/2012

Bldg 34 - Quinault

Changed to LiveMeeting Session.
Our previous meeting location (2010), park in lot for buildings 34 and 35 (off 159^th Ave NE).

2/21/2012

Studio H - Chinook

Other side of 520; follow directions to Microsoft Commons.

3/20/2012

Bldg 50 - Okanogan

North of NE 40^th St, off 156^th AVE NE

4/17/2012

Bldg 41 - Townsend

Park in the garage we’ve been using for meetings at the Steptoe Room

5/15/2012

Bldg 34 - Quinault

Our previous meeting location (2010), park in lot for buildings 34 and 35 (off 159^th Ave NE).

6/19/2012

Bldg 40 -Steptoe

Scheduled location for remainder of 2012.

Campus map

Share a Tip -- Win a Prize!
New addition to Q & A ... Share a tip and have a chance to win a prize.
This is the perfect time to share a technique or tip that helps you to save time, improve performance, preserve data, or ??? Feel free to bring your laptop or files to make this a Show & Tell. After all, user group meetings are all about sharing, learning and networking. We want everyone to participate.

                    ? ? ? Want to receive the newsletter by email?   ? ? ?
Please ensure that you have specified the domain DataDynamicsNW.com as a Safe Sender in your local AND in your online email provider/service. Several accounts/servers have rejected the newsletter as spam due to the number of links to content. So, you may need to adjust the settings via your online (Comcast, gmail, hotmail, etc) or business email provider.

**One Month of On Demanding Training from Pluralsight **

   *   *   *   *   *   *   *   *   *   *   *   *   *   *   *   *   *   *

         Standard Monthly Meeting Format

In general, each group will have about 90 minutes for their meeting; including general announcements, Q&A, and the main presentation. In order to best server our members and presenters, the start and end times will vary based on the specific circumstances.

We invite everyone to join us for pizza and networking. Dues are voluntary and help offset meeting costs. We ask those who have not paid dues to contribute $5 per evening.

       *   *   *   *   *   *   *   *   *   *   *   *   *   *   *   *   *   *

Presentations

January 17, 2012   7:00 - 8:30 PM PT - Via LiveMeeting.
Topic Brainstorming Session -- Teresa Hennig, Access MVP
Please share your suggestions for what you'd like to learn more about in 2012. We need your ideas to help target presentations that will provide the most value --- Volunteers and suggestions for speakers are greatly appreciated.

F. Scott Barker, Integrating Access with Outlook
Due to popular demand following up on November’s session on using Automation from Access with various Office applications Scott will be going into greater details of using Automation to manipulate various items in Outlook such as tasks, mail, calendar appointments, and contacts. Code will be provided to add and delete the items using VBA code.

F. Scott Barker is a seasoned desktop and web developer with expertise in Microsoft Access, SQL Server, and .Net technologies. With more than 10 books and a dozen years as a trainer and writer for AppDev, Scott is able to build the bridge that combines technical expertise with real world experiences.

February 21st ---
HAPPY BIRTHDAY INETA !!!!   SPECIAL FEATURES :~S

Tony Toews Access MVP, Front-End Updater

Frank Wilson, Finding the Difference in Strings of Text
Frank, a partner at Data and Domains, needed an effective mechanism to find the differences in two strings of text. So, he created a function that evaluates the strings and shows the precise location and values of the differences. Frank will share his technique and lead us in discussion on how it might be helpful in other scenarios.

George Hepworth, Moving An Access Database to Office 365/SharePoint
George will demonstrate how to move a working database to SharePoint as a hybrid application. Based on his success in solving some of his own needs, George will share how he moved his “Work Effort” Access/SQL Server application to SharePoint so that he could connect to the data from anywhere. With a little trial & error, effort & adjustments, the process is now working smoothly. In addition to benefiting from George’s lessons learned, we will also get to see the final results and learn how to leverage the techniques that George found most effective. The data resides on Office 365, and he can download a copy of the Access FE onto a client workstation.

George Hepworth works primarily with small to medium-sized businesses and organizations, helping clients realize the benefits of MS Access as a data management tool. He offers full system life cycle development based on 15+ years of experience in organizational workflow analysis, data management, and development of dynamic solutions, as well as experience with multiple software development methodologies with client/server development. His technical expertise is complimented by his clear and concise communications and goal to ensure client acceptance and satisfaction of deliverables and of the project management process.
In his spare time, George answers questions and helps fellow Access developers on Utter Access and other on-line Access Forums. He has also authored books, and given public presentations on Access and Access-related topics, including his newest book, “Microsoft Access in a SharePoint World,” coauthored with fellow MVPs, Ben Clothier and Tim Runcie; available at Advisicon

        Downloads and Resources - Lots of new Links

Access 2010 Programmer's Reference
By Teresa Hennig, Rob Cooper, Geoffrey Griffith and Jerry Dennison, contributors and editors, Armen Stein, Jeff Boyce, Albert Kallal, Doug Yudovich, Ben Clothier. Tips contributed from our esteemed colleagues Dane Miller, Garry Robinson, Steve Schapel, and Larry Strange.

Contact Teresa for a signed copy -- or order from Amazon with Teresa’s link.

Limited Time Offer for a Free Chapter
Chapter 7, Using VBA in Access
(provided by Wiley Publishing, who retains the copyrights for this work.)

EARLY REVIEW: "I have to say that you have surpassed yourself with the Access Programmer's Reference this time. Very, very nice. I usually use books like that for reference, to look up stuff when I have a question, but in this case I have literally been reading it in large chunks and finding it hard to put down. Especially the new Access 2010 functionality, I have already learned heaps.
So thanks a lot for that, I just wanted to let you know that I am mighty impressed with this one. :-) "   Steve Schapel, Access MVP

Our Book on Database Models!
Microsoft Access Small Business Solutions, : State-of-the-Art Database Models for Sales, Marketing, Customer Management, and More Key Business Activities

Written by an unparalleled team of Access MVPs-
Co Authors:   Teresa Hennig, Truitt Bradly,
Larry Linson, Leigh Purvis and Brent Spaulding

Contributors and Tech Editors: Jerry Dennison, George Hepworth and Doug Yudovich;

Tech Editors: Arvin Meyer and Armen Stein

Limited Time Offer for a Free Chapter
Chapter 4, People, Organizations, Addresses
(provided by Wiley Publishing, who retains the copyrights for this work.)

Arguably the most comprehensive compilation of guidance and database models available. In addition to the printed material, the companion CD provides 76 files, including 31 databases.
An invaluable resource for the business person -- those who know their industry but may not have experience with Access. With this book, they can design a custom database with confidence! The book is also full of amazing tips that will give experienced developers an edge, especially when expanding into new areas. Plus, the Bonus Resource database is filled with tools and tips that can be incorporated into your projects - and become the foundation for your custom toolbox.

Learn how to design properly normalized database models for dozens of business applications.   -- ORDER HERE!

Teresa,
I love your books. I have them all.
RibbonX 2007 helped me creating stunning ribbons for my Access applications. Mudhafar July 2010

RibbonX Customizing the Office 2007 Ribbon

By Robert Martim, Ken Puls, Teresa Hennig

Order NOW from Amazon

From the fundamentals through complete examples for Access, Excel and Word, this book provides the information and walks you through the steps to customize and create Ribbons in all three programs.

Limited Time Offer for a Free Chapter
Chapter 17 - Security in Microsoft Office
(Provided by Wiley Publishing, who retains the copyrights for this work.)
Although written primarily for 2007, most aspects apply to 2010 and several areas are applicable to Office 97 through 2003.

More excellent tips on working with Excel, visit site of co-author Ken Puls, Excel MVP.

Calendar Year Dues ...
Demonstrate your support and appreciation ...
Still only $30 each and voluntary!
Or Join BOTH groups for only $45!

Since collecting dues, we've NEVER imposed a dues increase!!!
Members only drawings, downloads, software, reviews and more.

Seattle Access Group Meeting
January 17th         Newsletter

Live Meeting Session

The meeting will start at 7 PM ... (Scheduled from 7 - 8:30 PM PT)
Please allow plenty of time to install Live Meeting and get familiar with the setup. We ask that you mute your microphones, but you will need your computer speakers to hear the presentation.

Join the meeting

If the above link does not work, you can copy and paste the following link into your browser.
Https://www.livemeeting.com/cc/usergroups/join

and use these credentials:
Meeting ID: PNWADG_SAG
Entry Code: AccessUG

January 2012 - Topic Brainstorming Session - Teresa Hennig - Access MVP
Scott Barker, Using Outlook with Access.

Coming Soon ...

February 2012 - Tony Toews - Access MVP

Receive SAG Newsletters
   (Hot List)     (Return to TOP)

NEW Meeting Location
Cafe for Building 40

Directions: From SR 520 Eastbound ...
Exit NE 40th, Turn RIGHT onto NE 40th, and move into the far right lane. Turn RIGHT onto 156th NE - heading South.
Turn RIGHT onto NE 31st.
Turn LEFT onto the access road for Buildings 41 and 40
Turn RIGHT into the parking garage.
As you walk from the garage, Building 40 is on the RIGHT and the Cafe is the single story building in the middle. Walk the length of building 40, to get to the side entrance of the cafe.

Meetings are in the STEPTOE Room in the Cafe. The entrance is on the right side, by building 40. The meeting room is immediately to the right.

Map of Campus area including Building 40
Diagram of Cafe and Buildings 40 and 41
   (Hot List)

   Pacific Northwest Access Developer Group
(Return to TOP)                                                                       Newsletter

January 17th, Live Meeting
7:00 - 8:30 PM PT -
Topic Brainstorming Session -- Teresa Hennig, Access MVP
Please share your suggestions for what you'd like to learn more about in 2012. We need your ideas to help target presentations that will provide the most value --- Volunteers and suggestions for speakers are greatly appreciated.

F. Scott Barker, Integrating Access with Outlook
Due to popular demand following up on November’s session on using Automation from Access with various Office applications Scott will be going into greater details of using Automation to manipulate various items in Outlook such as tasks, mail, calendar appointments, and contacts. Code will be provided to add and delete the items using VBA code.

F. Scott Barker is a seasoned desktop and web developer with expertise in Microsoft Access, SQL Server, and .Net technologies. With more than 10 books and a dozen years as a trainer and writer for AppDev, Scott is able to build the bridge that combines technical expertise with real world experiences.

The meeting will start at 7 PM ... (Scheduled from 7 - 8:30 PM PT)
Please allow plenty of time to install Live Meeting and get familiar with the setup. We ask that you mute your microphones, but you will need your computer speakers to hear the presentation.

Join the meeting

If the above link does not work, you can copy and paste the following link into your browser.
Https://www.livemeeting.com/cc/usergroups/join

and use these credentials:
Meeting ID: PNWADG_SAG
Entry Code: AccessUG

Coming Soon ...
February 21 --- Happy Birthday INETA~~
Tony Toews, Access MVP - the Auto FE Updater - February 2012
will present and discuss his Front End Updater. In addition to seeing the benefits of the current features, you'll have an opportunity to ask for additional features that would be helpful for your projects.
                                                  *********

Would YOU like to Share Your Experience and Expertise?

Potential Presentation ... Backup and Recovery Solution
Would you like a presentation on Acronis tools for back up and recovery, True Image Home 11 and Acronis Disk Director 11 Home? If so, I will strive to arrange a presentation that also provides discounts for purchasing either or both programs. Let me know and I’ll go to work on your behalf.

If you’d like to join the roster of presenters, please send an email to Teresa@DataDynamicsNW.com and include a brief description of your presentation and your bio.

Receive PNWADG Newsletters            (Hot List)              (Return to TOP)

Usability Studies (Return to TOP)

    Share this invitation with your friends and associates.
                                                                                                        (Hot List)

Share Your Expertise
Microsoft Access Blog Power Tips

User groups are all about helping others in the community. Microsoft has made it easy to extend your reach --- your local talents will have a global audience on the Access blog on MSDN! And no excuses about not knowing how to prepare your materials, they thought too --- there’s a free toolkit to help you out --- the Contributors Toolkit (download from MS and from the SAG site). Check out http://blogs.msdn.com/access/ ...

                                                                                                (Hot List)

CONGRATULATIONS TERESA!

INETA
2011
Community Champion

Profile & Photo

“The purpose of the INETA Community Champion Award program is to recognize individuals with the highest levels of contributions. Those exceptional leaders and volunteers who devote innumerable hours towards hosting user group meetings, ...”

Community Credit
recognizes
Teresa Hennig

for her commitment and contributions
to the developer community. May 2009.

More info soon at Data Dynamics Northwest.

The purpose of this site is to enhance our user group communications, share information about Access and provide links to relevant resources.

Access users and developers will want to stay tuned as we continue to demonstrate how to integrate Access with .NET and other applications.

Our meetings are welcoming forums for networking, sharing and learning.
Join us for fun, informative evenings.

Items of Immediate Interest - and more!! (return to top)

SQL Azure: The Breakfast of DBA Champions -- Live Meeting Tue, Dec 13 8am PST or 6pm PST (Dec 2011)

Join Michal Lesiczka for a Live Meeting to learn how SQL Azure can be your path to new opportunities.

Are you used to administering on-premise SQL Server databases? Are you interested in tuning up your skill set to handle SQL Azure Database, which delivers SQL Server like functionality as a service on the Windows Azure Platform? In TechTrax session 4, will show you everything you need to get started provisioning, deploying and managing your databases in the cloud. Register now.

Free Webinar: SQL Denali, Windows Azure and Business intelligence! Tue, Dec 13 at 8:30 AM PT (Dec 2011)

"Unlock Your Business Potential: Drive Greater Application ROI, Deeper Business Insights, and Faster Time to Market," Michael Otey, Windows ITPro & SQL Server Magazine, will be taking a look at the different aspects of SQL Server 2012 and Windows Azure to help reduce IT costs and increase ROI.

5 Steps to Successful Backup & Replication for Hyper-V By WindowsITPro (Dec 2011)

As developers, we may be managing our own serve and Hyper-V environments without the benefit of a corporate IT staff to maintain it. This on demand webinar provides valuable tips that can make these admin tasks easier – and more effective.

In this web seminar learn the 4 critical steps to ensure virtual machines are protected on Hyper V. Key takeaways from this event include:

> Scalable host-based replication for Hyper-V

> Easy management with agentless backup strategies

> Deduplication strategies to save disk resources for backups

Windows SkyDrive -- Redesigned; Simplified Sharing and Collaboration (Dec 2011)

Learn now the new design and features in SkyDrive simplify sharing and make it more app-centric, particularly for Office. Now you can Share a file from within the app and complete your task without having to worry about which folder it is in because SkyDrive lets you share or permission individual files within a folder. This works for Office documents, photos, or any other type of file. Get more info from the Windows blog posting.

Office WebApps .. get started for free (Nov 2011)

Free SkyDrive account with your free Windows Live ID …

See how easy it is to share and collaborate

Try Office 365 for Free! (Dec 2011)

Office 2007 and SharePoint 2007 Service Pack 3 information (Nov 2011)
Learn about the timing and options for support, upgrades and transitions from Office 2003, 2007 and 2010 (yes, there is a forecasted end of mainstream support date for 2010). As they say, knowledge is power; so now you can use the when and what to help your client’s make informed decisions about their current and upcoming applications and projects. Learn More

SQL Azure Labs … Social Analytics (Nov 2011)
A new way to integrate social media with business apps. “Social Analytics” allows you to connect with customers and quickly respond to their comments and concerns. Sign up

MSDN with Visual Studio 2010 – Save 15 – 35% on renewals or upgrades (Nov 2011)
If you have a current or recently expired subscription to Visual Studio or MSDN, you could be eligible for a significant savings on a new subscription. F ind out more.

SQL Server 2012 (Denali) CTP3 – trial software for download and testing (Nov 2011)
If you’re excited about the enhanced security and other new features of SQL Server 2012, you don’t have to just take someone else’s word for it, you can download the beta and gain experience for yourself!
download

Cloud Computing – a Non-Technical Overview, by TechNet (Nov 2011)
It’s time to cut through some of the hype and get a basic understanding of what Cloud Computing really is, the impacts it will have … and where it fits in YOUR future. Read the article from TechNet …

Learning about the Clout? Watch the video … How to Build a Private Cloud (part 1) (Nov 2011)
From virtualization to a Private Cloud; the benefits of automating IT services. Part one of four by Chenley

Learn about Microsoft’s Offerings for Private Cloud (Nov 2011)
Purported to have the best price point for private cloud solutions, Microsoft is offering a wealth of services, documents and resources to help businesses, professionals and individuals make informed decisions and have smooth transitions into Cloud computing. Learn more:

Office 365 -- -More info and More Resources
Download an Office 365 trial from
Take it for a spin by getting started with TechNet videos and articles

Office WebApps .. get started for free (Nov 2011)
Free SkyDrive account with your free Windows Live ID …
See how easy it is to share and collaborate. Learn more

Best Practices for Migrating to Office 365 – White Paper from Windows ITPro (October 2011)
This whitepaper contains valuable guidance to help you understand what is involved, learn about the key elements, and follow best practices. Download the whitepaper from Windows ITPro

101 Code Samples For Office 2010 Development (September 2011)
Microsoft has compiled a set of VBA code samples for select features or feature sets that you can incorporate or modify to work in your applications. Each sample consists of about 5 to 50 lines of code, and includes comments describing the code and setup. All from Microsoft MSDN.

Free Online Database Class – and more -- (September 2011)
Thanks group member, Kathy S, for sending these links to free classes offered by Stanford University. The courses will be available this fall – from October through December.
Intro Databases:
Machine Learning:
Artificial Intelligence:

Excel Shortcuts – Keystrokes to help you Work More Effeciently – TechRepublic Article (August 2011)
Since many of our projects evolve from Excel spreadsheets, it only stands to reason that many Access users and developers also work with Excel. TechRepublic is providing a list of Excel shortcuts that can save time and reduce errors. In addition to using them yourself, you may buy some goodwill by sharing the tips with your clients and users. Get the list from TechRepublic (posted August 1, 2011).

Webinar: A Simple Approach to Desktop Virtualization Security (August 2011)
Whether you’re concerned for your own systems, connecting to your clients, or supporting an Enterprise, you need to be alert to the ever changing landscape of security threats and some effective approaches for minimizing risks while leveraging the benefits of mobilization and virtual desktops. This on demand seminar is provided by ITPro and sponsored by Citrix. Click to register.

Free Preview of FMS Total Visual CodeTools 2010 (July 2011)
Hurry and try it NOW --- Fully functional with all versions of Office and VB6 you use. Offer lasts through July – so try it and you’ll see why so many rely on FMS tools!Visit FMS and Get the FREE download!

Office 2010 SP1 Downloads and Answers (July 2011)
Those of you using Office 2010, may be wondering if you should install SP1, and if you do, what are some of the consequences that you should be prepared to deal with. A search for Office 2010 SP1 Issues could overwhelm a person with posting about both the issues it fixes and the issues it creates – during and after installing. When you’re searching for answers, you might find useful information and assistance at Microsoft Answers. You can also find Access related issues at the Access Blog

Webucator – Instructor led Online and Onsite Training (July 2011)
Webucator offers a wealth of technology and business training -- with a wide range of Microsoft training, including Access training. The content ranges from introductory courses to advanced programming. The SAG and PNWADG are fortunate to welcome Webucator as a new sponsor. Please check out their offerings and … look forward to special opportunities.

Back up and Recovery .. WinIT Pro White Paper (June 2011)
This article is an excellent follow-up to discussions a recent meeting about online backup services. Download the paper on how to select a provider for online backups.

On the topic of Online folders -- The Tech Republic Article (June 2011)
Dropbox: Convenient, absolutely; but is it Secure?

Creating Window Installation Files (May?June 2011)
At the May meeting, we briefly discussed tools for creating installation files. A member recommended NSIS as a good, open source option. Check it out, and share your opinions and experience with the group.

Access Tip - Streamline Reporting on Recurring Data Imports (May 2011)
Leading the way with scenario based articles, Mike Stowe walks you through creating an Access database to import and analyze data from a text file, complete with sample database. Visit the Microsoft Access Blog for this new article on how to make data easier
Link to article on the Microsoft Office Blog -
Or go directly to the article:
    PLEASE - use the blog post to share thoughts about the article and your preferences about scenario
     based articles -- as compared to feature based. --- For those who are hesitant to make public
     comments, you may send your feedback in an email to accesshelp@microsoft.com

Pluralsight Training --
Get One FREE Month of On Demand Training -- (April 2011)
What would YOU learn if you could take as many courses as you can complete in a month? Well, this is your chance to build your expertise, expand your horizons, and then ... share with the group.

This invitation is open to ALL group members, and you do not need to be present to be selected. To be considered, please send an email to Teresa and express how you will put the newfound knowledge to good use --- professionally, personally, for the good of the community. Many of you volunteer your time and expertise to help others, and this training may be an excellent way to increase your skills.

The Essential Guide to Virtualizing Desktops and Applications by Windows ITPro (May 2011)
With the features and mobility expectations for today’s programs, it can be beneficial to have a basic understanding of the key factors and options associated with virtual desktops and applications. For those of you wanting to learn more, Windows IT pro has offered a guide for download.

Hosted or On-Premises Archiving - OnDemand Presentation by Windows ITPro (May 2011)
With the convenience and affordability of external drives, it might seem that local backups are the easy answer. This presentation will cover several key factors that you should consider when determining what back-up option might be better for a given situation. Sign up

Clonezilla - Image Your Drives for Free -- (Tech Republic article and instructions for using Clonezilla) (April 2011)
Disc imaging is a valuable resource for disaster recovery, but it can also be used for maintaining and upgrading systems. Clonezilla allows you to clone the image of a machine and use it to restore the image to a single machine or multiple machines. In this Tech Republic article, Jack Wallen provides the background and walks you through the process.

Learn Access By Crystal -- (Nov 2010)
Access MVP, Crystal shares tips, videos and helpful links. Check back often.
Official Play List

Removing Crapware - from TechRepublic (Nov 2010)
One of the annoyances of a new computer is the amount of crapware that comes preinstalled. TechRepublic has a free report with suggestions and tools for identifying and removing unwanted programs and files. It also mentions why you don't want to defrag Solid-state drives (SSD), such as those in some high-end laptops. Read or dowload the file from Tech Republic.

AquaSnap 1.3 - Arrange Windows on Your Desktop (Sept 2010)
Nurgo Software offers a free tool that allows you to snap and anchor windows to the edge or corner of your desktop. It is compatible with all versions of Windows and can replace Aero Snap and Aero Shake in Windows 7. Read more and get the download at www.nurgo-software.com/products/aquasnap

Database Design Forum - GROUP on the MSDN Community Website (Jan 2010)
Under the SQL Server group, this forum is focused on the database design. The discussions include Access database design. Several of the authors and editors from Teresa’s upcoming book on database design are among the founding moderators and contributors to the forum; including Doug Yudovich, George Hepworth, Jerry Dennison, and me <g>.

SQL Server 2008 R2 Digital Tour (May 2010)
SQL Server 2008 R2 takes data management to “the next generation of computing.” Learn about the new and enhanced features from multi-server management to end-user reporting, watch a video, get links to training and other resources

Tips and Techniques for Queries in Access 2007 (Sept 2009)
From the basics to advanced topics, Luke provides insights and discusses some of the subtleties that will really make a difference.

The Basics of Writing and Testing VBA Code
Part 1 and Part 2 (Sept 2009)
Learn about code modules, write and call procedures, use variables and even learn the benefits of documenting your code. Excerpts from Beginning Access 2007 VBA by Denise M. Gosnell from Wrox (ISBN 978-0-470-04684-5, copyright John Wiley & Sons, Inc. 2007, all rights reserved.

(Hot List)

Links, Tips and Downloads and More ...

Rick Fisher's Find and Replace (May 2011)
Rick's tool will search through the design elements, such as the table and field names and modules (not the data). It can change the names of objects throughout the entire database. Version 9.0 works with Access versions from 2000 through 2010. Visit Rick's site for more details and the download.

Doug Steele's Web Site (May 2011)
Access MVP and author of “Access Solutions” shares tips and links to other resources on his website.

Optimize Access when using ODBC data source (May 2011)
Article referred to in George Hepworth's presentation April 2011 on DNS Less data connections. KB286222

PrimoPDF – The World’s #1 free PDF Creator - at least according to them. (July 2008)
PrimoPDF offers both a free and professional version that will work with Windows 98 through Windows Vista and can work with over 300 file types. Willie really likes PrimoPDF for client installations because it is remarkably simple and leaves a VERY SMALL footprint. Let me know what you think.

Virtualization Via HyperV
Are you ready? Are you hyped? We’ve been talking about it and our launch presentations will cover some of the key features and benefits. And NOW ... Microsoft has released Hyper-V for Windows Server 2008! Read more

SecureAble - What can Your Processor do? (July 2009)
A great tool that identifies some key features and capabilities of your processor chip, such as the bit length, if the memory can store non-executable files, and how it will support hardware virtualization. Did I mention it is free? Learn more and get the free download.

SQL Server 2008 Migration Solution Center --- Guidance about upsizing databases to SQL Server 2008.
In addition to guidance and other resources, there is also the SQL Server Migration Assistants (SSMAs) ... that helps those upsizing from Access, Oracle and Sybase to SQL Server.

Tips & Tricks – Webcasts and Podcasts from the Experts
Microsoft Webcast Home provides links to valuable resources from the experts. These webcasts and podcasts include great tips, lessons, recommendations and other invaluable tidbits. and ... it’s FREE!

Access 2003 Solution Center
This is a great starting point to find solutions, downloads, current topics and links to the latest updates.

Free online Training – Check out the courses and send comments and send me an email to suggest additional modules!
            21 courses for Access 2007
                 18 courses for Access 2003

For additional and past postings check pages for Links, Downloads, etc(Hot List)
(Return to TOP)

Access 2007
VBA Programmers Reference

Teresa Hennig, Rob Cooper
Geoff Griffith, Armen Stein
Order NOW from Amazon
REVIEW:   FIVE STAR REVIEW!!!!
This book has extensive coverage of an area vital to Access developers and power users, by a very knowledgeable team, ably led by Teresa Hennig. It includes something more than an overview explaining new features of Access 2007. That is important because: many features are new and changed in Access 2007, much of what we do with VBA is automating and enhancing features we use manually via the user interface, and the new Office 2007 user interface can be overwhelming without a helping "hand up". Then the book covers VBA from the basics to in-depth advanced levels. It is a worthy successor to the Access 2003 VBA Programmer's Reference and, in my opinion, "raises the bar" for VBA books. I'll be using it as a reference in presentations to my Access user groups, as well as a handy reference for my own work. I recommend it to Access power users, as well as aspiring and working Access developers.

Larry Linson
Microsoft Office Access MVP

CIPS Connections
Teresa Hennig, Access MVP
interviewed by Stephen Ibaraki. FCIPS, I.S.P., DF/NPA, CNP, MVP

Teresa's thoughts and recommendations for user groups, developers, managers and businesses in general.

Interview Response

... You provided an incredible contribution Teresa!

The very fine interview clearly demonstrates your passion, experience, insights, commitment, dedication ... It's also evident that you spent considerable time in thinking about and providing your responses. Your hard work and focus on value is very much appreciated. In fact, I feel so inspired by your efforts!

Thank you for taking the time and special care with the interview and sharing your considerable insights with the world. You are a very talented and gifted person who touches the lives of so many.

Moreover, you are making a significant historical contribution to our society, industry, and profession.

The world is like spiders web, you touch one corner and the whole thing shakes.
And such is your personal vision, voice, and work -- you touch all of us and impact our vision and lives for the future.

Stephen Ibaraki, FCIPS, I.S.P., MVP, DF/NPA, CNP

From My Client ...
May 4, 2007

Teresa,     "This could not have been any truer!"

“I also have time for my clients. Actually, I'm as passionate about my clients and their projects as I am about my groups. As a consultant, I am incredibly fortunate to get to work on projects from a wide spectrum of industries. Every project provides new challenges for finding ways to manage data, streamline and automate. Understanding my client's industries, operations and needs, I feel like I'm their partner and it is important to provide cost effective solutions. With the savings and benefits, my solutions typically pay for themselves in a matter of months. My biggest reward is knowing that I truly made a difference.”

"I am EXTREMELY PROUD OF YOU and equally happy! WOW!!!"
C. DiFranceisco
America First Search & Abstract, Inc.

Seattle Access Groups members are offered a 10% discount on FMS products.

Supporting .NET User Groups

   10% discount to members!
Edge Tech Corp is a leading memory supplier. EDGE sells 100% compatible Dell Memory and other DRAM upgrades. EDGE also offers flash drives and portable hard drives.

               What it Means to be an Access MVP

Thank you for sharing your passion and expertise and invigorating communities globally ...

Steve Ballmer, CEO Microsoft

My thanks to the Access community for helping me to earn such a prestigious award ... for six consecutive years. 2006-through 2011.

                                  Certificate            MVP Page

(Return to TOP)