HUG Access SIG Meeting 6:30 pm, July 18, 2012, 2011 at JCCC, Regnier 2nd Floor, RC 378
Presenter: Earl Long
Topic: String Functions and how they might be used in your Access Application
Earl Long is one of the original founder of the Heartland User Group.
He has been retired from business and now focuses on Political Advocacy and Consulting.
Presenter: Bill Diamond
Topic: Comma & Quotes in Strings
Most of us, experienced or novice, have had problems with Access when data contains a quote or apostrophe within the data. We may have been able to come up with solutions that got us around this event. What complicates this situation is a DAO solution most likely fails with an ADO call or heaven forbid, what happens if there is a quote and apostrophe within the same string element.
We will demonstrate a solution at the meeting which should account for all the above circumstances. Also, we will show coding that makes direct calls to elements on a form and alternate coding that makes the calls as variables which makes code much more versatile for reuse in other/future circumstances.
Bill Diamond in the past was a heavy user of Microsoft Access and picked up a few tricks along the way which he is willing to share with the rest of the group.
Microsoft Access 2010 24-Hour Trainer by Geoffrey L Griffith, Truitt L Bradly the lessons within the book are each accompanied by an instructional demonstration on the DVD - nearly 5 hours of video tutorials.
Give-away drawing for HUG members only. Sponsored by: Heritage Computer Consulting & Services, Inc.
Heritage Computer Consulting & Services, Inc.
7700 Wedd Suite 100
Overland Park, KS 66204