Provide a quick, creative biography in 140 characters or less.
More bioFull Name: Jeffrey Coachman
Email: Jeffrey(dot)Coachman(at)at
Microsoft Access MVP 2010
Completely self-taught in Microsoft Access.
I became interested in Microsoft Office/Access in 2000 (hence, boag2000).
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
Lost track after this...
Some of my favorite Solutions:
Explains why Non-standard interfaces should not be used:
http://www.experts-exchange.com/Microsoft/Development/Q_24252558.html
Explains 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.html
Explaining why code that previously worked in Access 2003, now fails in Access 2007
http://www.experts-exchange.com/Microsoft/Applications/Q_24353315.html
Explaining 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.html
Interesting research on converting between Hijri to Gregorian dates.
http://www.experts-exchange.com/Microsoft/Development/MS_Access/Access_Coding-Macros/Q_23150468.html
Instructions of how to write better code:
http://www.experts-exchange.com/Microsoft/Applications/Q_24353315.html
Troubleshooting "Mega" (nested) Formulas:
http://www.experts-exchange.com/Microsoft/Development/MS_Access/Access_Reports/Q_24348750.html
Discussion 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.html
Not 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.html
Knowing new features in Access 2007 "Layouts":
http://www.experts-exchange.com/Microsoft/Development/MS_Access/Access_Reports/Q_24138574.html
Knowing new features in Access 2007 "Report View:
http://www.experts-exchange.com/Microsoft/Development/MS_Access/Access_Reports/Q_24369082.html
General Design info:
http://www.experts-exchange.com/Microsoft/Development/MS_Access/Access_Coding-Macros/Q_24374369.html
Access, "Application Icon" clarification:
http://www.experts-exchange.com/Microsoft/Development/MS_Access/Q_23806291.html
Report, Sum "Inactive" time Gaps:
http://www.experts-exchange.com/Microsoft/Development/MS_Access/Access_Reports/Q_24468693.html
Willingness to work with an Asker to help *Them* solve the issue:
http://www.experts-exchange.com/Microsoft/Development/MS_Access/Access_Reports/Q_24463539.html
Displaying Null, Zero, Blank Values on a Chart
http://www.experts-exchange.com/Microsoft/Development/MS_Access/Access_Forms/Q_24536942.html?cid=1131#a24771720
Access "Rounding" manually entered object positioning values:
http://www.experts-exchange.com/Microsoft/Development/MS_Access/Access_Forms/Q_24569658.html
Keep Leading Zeros with a "CSV" file
http://www.experts-exchange.com/Microsoft/Development/MS_Access/Q_24553149.html
Display Week Ranges (subtitle: "What is a Week, really?")
http://www.experts-exchange.com/Microsoft/Development/MS_Access/Access_Coding-Macros/Q_24561747.html
Using 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.html
Printing "Continued" for data continuing from previous Report Page
http://www.experts-exchange.com/Microsoft/Development/MS_Access/Access_Reports/Q_24582570.html
List the Query Name in the Query Result:
http://www.experts-exchange.com/Microsoft/Development/MS_Access/Access_Architecture-Design/Q_24635813.html
Date/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.html
Convert Hex To Text:
http://www.experts-exchange.com/Microsoft/Development/MS_Access/Access_Architecture-Design/Q_24767115.html
Interestingly worded 20 point question:
http://www.experts-exchange.com/Microsoft/Development/MS_Access/Q_24771861.html
Outline 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.html
Displaying dynamically sized Graphics in unused Report Space
http://www.experts-exchange.com/Microsoft/Development/MS_Access/Q_24874532.html
Thoughts on the "ColumnHistory" Method in Access 2007
http://www.experts-exchange.com/Microsoft/Development/MS_Access/Access_Coding-Macros/Q_24897677.html
FindingFilteredSubformReco
http://www.experts-exchange.com/Microsoft/Development/MS_Access/Access_Forms/Q_24915666.html
Complex Charting question:
http://www.experts-exchange.com/Microsoft/Development/MS_Access/Q_24915121.html
*Simple, Basic* Language change in Reports:
http://www.experts-exchange.com/Microsoft/Development/MS_Access/Q_26406485.html
Quick and dirty way to determine what db your tables are linked to:
http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/SQL_Server_2008/Q_26406250.html
Print SubReoprt based on number of records:
http://www.experts-exchange.com/Microsoft/Development/MS_Access/Access_Reports/Q_26525924.html
Synchronize Column Widths
http://www.experts-exchange.com/Microsoft/Development/MS_Access/Access_Forms/Q_26538835.html
Eliminating the "<>" (Not equal to)column in a Crosstab query
http://www.experts-exchange.com/Database/Miscellaneous/Q_26574399.html
Insert "Clickable" hyperlink in an Email:
http://www.experts-exchange.com/Microsoft/Development/MS_Access/Q_26606114.html
Group Report by broken, non-standard Sort.
http://www.experts-exchange.com/Programming/Languages/SQL_Syntax/Q_26607345.html
Zoom a Form Control at Runtime:
http://www.experts-exchange.com/Microsoft/Development/MS_Access/Q_26663761.html?cid=1131#a34297711
Do Not save Pivot table chart Filter field settings:
http://www.experts-exchange.com/Microsoft/Development/MS_Access/Q_26676564.html
Create Report of All aggregated data
http://www.experts-exchange.com/Microsoft/Development/MS_Access/Q_26669287.html
Extract Attachment Field Datatype Files
http://www.experts-exchange.com/Microsoft/Development/MS_Access/Q_26855303.html
Hide/Suppress Blank Last Report Page in Access 2010
http://www.experts-exchange.com/Microsoft/Development/MS_Access/Q_26866681.html
http://www.experts-exchange.com/Microsoft/Development/MS_Access/Q_27377442.html#36906378
Coloring the "Overlap" in Charts/Graphs
http://www.experts-exchange.com/Microsoft/Development/MS_Access/Q_26951035.html
Subreports Grouped by Date
http://www.experts-exchange.com/Microsoft/Applications/Q_27246393.html
Employee Skills matrix report:
http://www.experts-exchange.com/Microsoft/Development/MS_Access/Q_27088108.html
Print Full Page of the same Label
http://www.experts-exchange.com/Microsoft/Development/MS_Access/Q_27419461.html
Keeping Subreport Columns
http://www.experts-exchange.com/Microsoft/Development/MS_Access/Q_27596705.html
ConcatenateMaiMergeCombine
http://www.experts-exchange.com/Microsoft/Development/MS_Access/Q_27596187.html
Misc:
How posts need not get "Ugly"
http://www.experts-exchange.com/Microsoft/Development/MS_Access/Q_24446389.html