Full Name: Jeffrey Coachman
Email: Jeffrey(dot)Coachman(at)at
t.net
Completely self-taught in Microsoft Access.
I became interested in Microsoft Office/Access about 9 years ago.
I have taught Access and Excel classes, and I have completed many small to medium sized projects.
I work now as a full time programmer in Microsoft Office.
Being an Expert here allows me to keep my skills sharp and help others, but most importantly, it helps me to learn and grow while in the company of the other great Experts here.
;-)
Passed 1,000,000 total Points on 3/16/2008
Passed 1,000,000 points in Access General Topic Area on 5/9/2008
First Wizard (300,000 points) in the Access Reports Zone
Passed 2,000,000 total points on 9/1/2008
First Sage (500,000 Points) in the Access Report Zone 11/9/2008
Passed 3,000,000 total points on 1/15/2009
Genius Access Forms (1,000,000 points), 2/21/2009
Passed 2,000,000 Points in General MS Access Zone 3/6/2009
Genius, Access Coding/Macros (1,000,000 points) 4/17/2009
Passed 4,000,000 Total Points 5/23/2009
Genius, Access Reports (1,000,000 points) 5/28/2009
*First Access Expert with 4 genius Certifications in 4 MS Access specific Zones
(Not quite sure when I made it to the Top 100 site wide, or Top 25 in the MS Access zone?)
Passed 5,000,000 Total Points 10/13/2009
Some of my favorite Solutions:
Explains why Non-standard interfaces should not be used:
http://www.experts-exchange.com/Microsoft/Development/Q_24252558.htmlExplains why Look-up Fields in a Table are not necessarily bad, just confusing in some cases
http://www.experts-exchange.com/Microsoft/Development/MS_Access/Access_Architecture-Design/Q_24315136.htmlExplaining why code that previously worked in Access 2003, now fails in Access 2007
http://www.experts-exchange.com/Microsoft/Applications/Q_24353315.htmlExplaining in what circumstances Aggregate functions can be replaced with joined tables for increased performance.
http://www.experts-exchange.com/Microsoft/Development/MS_Access/Q_24092679.htmlInteresting research on converting between Hijri to Gregorian dates.
http://www.experts-exchange.com/Microsoft/Development/MS_Access/Access_Coding-Macros/Q_23150468.htmlInstructions of how to write better code:
http://www.experts-exchange.com/Microsoft/Applications/Q_24353315.htmlTroubleshooting "Mega" (nested) Formulas:
http://www.experts-exchange.com/Microsoft/Development/MS_Access/Access_Reports/Q_24348750.htmlDiscussion of "Control Arrays" vs "Arrays of Controls" (I think I used the SLOCs term incorrectly though)
http://www.experts-exchange.com/Microsoft/Development/MS_Access/Q_23593296.htmlNot afraid to post "full" instructions (Note: Have since learned to use: SelLength, SelStart, SelText, &ect.)
http://www.experts-exchange.com/Microsoft/Development/MS_Access/Q_21401937.htmlKnowing new features in Access 2007 "Layouts":
http://www.experts-exchange.com/Microsoft/Development/MS_Access/Access_Reports/Q_24138574.htmlKnowing new features in Access 2007 "Report View:
http://www.experts-exchange.com/Microsoft/Development/MS_Access/Access_Reports/Q_24369082.htmlGeneral Design info:
http://www.experts-exchange.com/Microsoft/Development/MS_Access/Access_Coding-Macros/Q_24374369.htmlAccess, "Application Icon" clarification:
http://www.experts-exchange.com/Microsoft/Development/MS_Access/Q_23806291.htmlReport, Sum "Inactive" time Gaps:
http://www.experts-exchange.com/Microsoft/Development/MS_Access/Access_Reports/Q_24468693.htmlWillingness to work with an Asker to help *Them* solve the issue:
http://www.experts-exchange.com/Microsoft/Development/MS_Access/Access_Reports/Q_24463539.htmlDisplaying Null, Zero, Blank Values one a Chart
http://www.experts-exchange.com/Microsoft/Development/MS_Access/Access_Forms/Q_24536942.html?cid=1131#a24771720Access "Rounding" manually entered object positioning values:
http://www.experts-exchange.com/Microsoft/Development/MS_Access/Access_Forms/Q_24569658.htmlKeep Leading Zeros with a "CSV" file
http://www.experts-exchange.com/Microsoft/Development/MS_Access/Q_24553149.htmlDisplay Week Ranges (subtitle: "What is a Week, really?")
http://www.experts-exchange.com/Microsoft/Development/MS_Access/Access_Coding-Macros/Q_24561747.htmlUsing Date criteria in Crosstab queries (and other concerns when using a crosstab query as the direct source for a Report)
http://www.experts-exchange.com/Microsoft/Development/MS_Access/Access_Coding-Macros/Q_24577123.htmlPrinting "Continued" for data continuing from previous Report Page
http://www.experts-exchange.com/Microsoft/Development/MS_Access/Access_Reports/Q_24582570.htmlList the Query Name in the Query Result:
http://www.experts-exchange.com/Microsoft/Development/MS_Access/Access_Architecture-Design/Q_24635813.htmlDate/Time/Number Conversion discussion:
http://www.experts-exchange.com/Microsoft/Development/MS_Access/Access_Forms/Q_24664756.html"Padding" a Report with fake records to fill a Page, By Group
http://www.experts-exchange.com/Microsoft/Development/MS_Access/Access_Reports/Q_24702767.htmlConvert Hex To Text:
http://www.experts-exchange.com/Microsoft/Development/MS_Access/Access_Architecture-Design/Q_24767115.htmlInterestingly worded 20 point question:
http://www.experts-exchange.com/Microsoft/Development/MS_Access/Q_24771861.htmlOutline Report like MS Word: 1, 1.1, 1.1.1, 1.1.1.1, ...etc
http://www.experts-exchange.com/Microsoft/Development/MS_Access/Q_24785569.htmlDisplaying dynamically sized Graphics in unused Report Space
http://www.experts-exchange.com/Microsoft/Development/MS_Access/Q_24874532.htmlThoughts on the "ColumnHistory" Method in Access 2007
http://www.experts-exchange.com/Microsoft/Development/MS_Access/Access_Coding-Macros/Q_24897677.htmlFindingFilteredSubformReco
rds
http://www.experts-exchange.com/Microsoft/Development/MS_Access/Access_Forms/Q_24915666.htmlSome of my notable Solutions (By Askers replies):
http://www.experts-exchange.com/Microsoft/Development/MS_Access/Access_Forms/Q_23693568.html?cid=748#a24289717http://www.experts-exchange.com/Microsoft/Development/MS_Access/Q_23893434.html?cid=236#a22974917http://www.experts-exchange.com/Microsoft/Development/MS_Access/Access_Reports/Q_24113990.html?cid=236#a23557295http://www.experts-exchange.com/Microsoft/Development/MS_Access/Q_24227847.html?cid=236#a23901570 http://www.experts-exchange.com/Microsoft/Development/MS_Access/Access_Forms/Q_24232618.html?cid=238#a23935677http://www.experts-exchange.com/Microsoft/Development/MS_Access/Access_Forms/Q_24252467.html?cid=236#a23949058http://www.experts-exchange.com/Microsoft/Development/MS_Access/Access_Forms/Q_24252472.html?cid=236#a23953311 http://www.experts-exchange.com/Microsoft/Development/MS_Access/Q_24286517.html?cid=236#a24069042 http://www.experts-exchange.com/Microsoft/Applications/Q_24275845.html?cid=236#a24043739http://www.experts-exchange.com/Microsoft/Development/MS_Access/Access_Coding-Macros/Q_22875322.htmlhttp://www.experts-exchange.com/Microsoft/Development/MS_Access/Access_Reports/Q_24110282.htmlMisc:
How posts need not get "Ugly"
http://www.experts-exchange.com/Microsoft/Development/MS_Access/Q_24446389.html
