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:
https://www.experts-exchange.com/questions/24252558/Can-I-use-cboBox-Column-1-to-place-an-initial-value-in-a-ComboBox.html
Explains why Look-up Fields in a Table are not necessarily bad, just confusing in some cases
https://www.experts-exchange.com/questions/24315136/Access-Combo-box-deleting-original-data.html
Explaining why code that previously worked in Access 2003, now fails in Access 2007
https://www.experts-exchange.com/questions/24353315/Running-Balance-Elapsed-days.html
Explaining in what circumstances Aggregate functions can be replaced with joined tables for increased performance.
https://www.experts-exchange.com/questions/24092679/Something-faster-than-dlookup.html
Interesting research on converting between Hijri to Gregorian dates.
https://www.experts-exchange.com/questions/23150468/Hijri-Calendar.html
Instructions of how to write better code:
https://www.experts-exchange.com/questions/24353315/Running-Balance-Elapsed-days.html
Troubleshooting "Mega" (nested) Formulas:
https://www.experts-exchange.com/questions/24348750/Mailing-a-report-but-the-subject-field-is-too-small-Microsoft-Access-2007.html
Discussion of "Control Arrays" vs "Arrays of Controls" (I think I used the SLOCs term incorrectly though)
https://www.experts-exchange.com/questions/23593296/Variant-vs-Control-type-in-For-Each-statement.html
Not afraid to post "full" instructions (Note: Have since learned to use: SelLength, SelStart, SelText, &ect.)
https://www.experts-exchange.com/questions/21401937/How-to-add-an-auto-complete-textbox-control-to-an-MS-Access-Form.html
Knowing new features in Access 2007 "Layouts":
https://www.experts-exchange.com/questions/24138574/Creating-an-Access-report-with-multiple-rows.html
Knowing new features in Access 2007 "Report View:
https://www.experts-exchange.com/questions/24369082/How-to-make-detail-section-of-report-hide-based-on-criteria.html
General Design info:
https://www.experts-exchange.com/questions/24374369/Ms-Access-Filter-Report-from-form-input-Have-solution-but-can-it-be-done-more-efficiently.html
Access, "Application Icon" clarification:
https://www.experts-exchange.com/questions/23806291/How-to-Change-the-Icon-for-Access-Application.html
Report, Sum "Inactive" time Gaps:
https://www.experts-exchange.com/questions/24468693/Calculate-Total-Gaps-In-Elapsed-Time.html
Willingness to work with an Asker to help *Them* solve the issue:
https://www.experts-exchange.com/questions/24463539/Graphic-representation-of-a-percentage-on-a-report.html
Displaying Null, Zero, Blank Values on a Chart
https://www.experts-exchange.com/questions/24536942/Access-2003-Remove-Null-Values-from-Access-PivotChart.html?cid=1131&anchorAnswerId=24771720#a24771720
Access "Rounding" manually entered object positioning values:
https://www.experts-exchange.com/questions/24569658/Why-won't-Access-2K-Accept-Exact-Top-Left-etc-Entries-in-Text-Box-Properties.html
Keep Leading Zeros with a "CSV" file
https://www.experts-exchange.com/questions/24553149/Export-Access-table-to-csv-file.html
Display Week Ranges (subtitle: "What is a Week, really?")
https://www.experts-exchange.com/questions/24561747/Determine-month-and-day-based-on-week.html
Using Date criteria in Crosstab queries (and other concerns when using a crosstab query as the direct source for a Report)
https://www.experts-exchange.com/questions/24577123/Problem-with-date-filters-on-Crosstab-Query.html
Printing "Continued" for data continuing from previous Report Page
https://www.experts-exchange.com/questions/24582570/Access-2007-Report-Add-Continued-when-a-header-repeats-on-another-page.html
List the Query Name in the Query Result:
https://www.experts-exchange.com/questions/24635813/How-To-Show-the-Query-Name-Using-a-Function.html
Date/Time/Number Conversion discussion:
https://www.experts-exchange.com/questions/24664756/Can-someone-help-me-with-time-fields-in-an-Access-2007-Form.html
"Padding" a Report with fake records to fill a Page, By Group
https://www.experts-exchange.com/questions/24702767/Access-Report-Fill-gap-between-end-of-lines-of-detail-and-report-footer.html
Convert Hex To Text:
https://www.experts-exchange.com/questions/24767115/VBA-code-to-convert-hex-to-string.html
Interestingly worded 20 point question:
https://www.experts-exchange.com/questions/24771861/build-an-expression-query-wheel-for-a-database.html
Outline Report like MS Word: 1, 1.1, 1.1.1, 1.1.1.1, ...etc
https://www.experts-exchange.com/questions/24785569/How-do-I-set-up-outline-numbering-in-an-MS-Access-Report.html
Displaying dynamically sized Graphics in unused Report Space
https://www.experts-exchange.com/questions/24874532/Size-OLE-in-report-like-CanGrow.html
Thoughts on the "ColumnHistory" Method in Access 2007
https://www.experts-exchange.com/questions/24897677/Access-2007-Report-with-date-range-in-column-history.html
FindingFilteredSubformReco
https://www.experts-exchange.com/questions/24915666/Combo-Boxes.html
Complex Charting question:
https://www.experts-exchange.com/questions/24915121/Trouble-with-Access-comparison-Chart.html
*Simple, Basic* Language change in Reports:
https://www.experts-exchange.com/questions/26406485/date-language-in-report.html
Quick and dirty way to determine what db your tables are linked to:
https://www.experts-exchange.com/questions/26406250/How-to-find-SQL-2008-database-path-and-use-in-code.html
Print SubReoprt based on number of records:
https://www.experts-exchange.com/questions/26525924/Selectively-print-or-bypass-a-subform.html
Synchronize Column Widths
https://www.experts-exchange.com/questions/26538835/2-Subform-how-to-sync-ColumnWidth-and-ColumnOrder.html
Eliminating the "<>" (Not equal to)column in a Crosstab query
https://www.experts-exchange.com/questions/26574399/How-do-I-rid-myself-of-the-column-in-a-crosstab-What-is-that-column-called-Why-is-it-there.html
Insert "Clickable" hyperlink in an Email:
https://www.experts-exchange.com/questions/26606114/Hyperlink-field-in-the-message-of-email-in-access-form.html
Group Report by broken, non-standard Sort.
https://www.experts-exchange.com/questions/26607345/MS-Access-2007-2010-How-do-I-sort-by-one-field-but-keep-like-groups-intact.html
Zoom a Form Control at Runtime:
https://www.experts-exchange.com/questions/26663761/Zoom-field-on-form-in-Microsoft-Access-2007.html?cid=1131&anchorAnswerId=34297711#a34297711
Do Not save Pivot table chart Filter field settings:
https://www.experts-exchange.com/questions/26676564/MS-Access-2007-Open-Pivot-Table-without-previous-criteria.html
Create Report of All aggregated data
https://www.experts-exchange.com/questions/26669287/Chart-or-Pivot-Chart-in-Access.html
Extract Attachment Field Datatype Files
https://www.experts-exchange.com/questions/26855303/Email-Database-Attachments.html
Hide/Suppress Blank Last Report Page in Access 2010
https://www.experts-exchange.com/questions/26866681/Remove-Blank-last-page-in-Access-report-with-group-page-break.html
https://www.experts-exchange.com/questions/27377442/Blank-last-page-when-using-Force-new-Page-in-group-footer.html#36906378
Coloring the "Overlap" in Charts/Graphs
https://www.experts-exchange.com/questions/26951035/Shade-difference-between-two-series-in-C-chart-object.html
Subreports Grouped by Date
https://www.experts-exchange.com/questions/27246393/Report-with-Multiple-Pages-via-Search-Box.html
Employee Skills matrix report:
https://www.experts-exchange.com/questions/27088108/Employee-Skills-Matrix-in-FlexGrid.html
Print Full Page of the same Label
https://www.experts-exchange.com/questions/27419461/Printing-Labels-of-Current-record-on-a-Form.html
Keeping Subreport Columns
https://www.experts-exchange.com/questions/27596705/Problem-formatting-report-with-multi-column-sub-report.html
ConcatenateMaiMergeCombine
https://www.experts-exchange.com/questions/27596187/Expand-shrink-width-of-text-field-on-a-report.html
Misc:
How posts need not get "Ugly"
https://www.experts-exchange.com/questions/24446389/Is-this-setup-in-a-workable-fashion.html