Jeffrey Coachman
MIS Liason
  • Middle Island,
  • United States of America
Member Since: 2004/02/07
Industry: Accounting/Finance
Top Skills:
Tech Certifications:
CERTIFIED EXPERT

Provide a quick, creative biography in 140 characters or less.

More bio
Activity
Points this month0
Total points11,085,923
Questions: 128
Solutions: 8707
Articles:
Videos:
Tutorials:
Posts:
Group Discussions: 39
Professional Background
MIS Liason
IGHL (Independent Group Home Living)
June 2006 – Present
manorville, NY
MS Access Database Administration
Telephony
MS Office Support
Basic IT Support
Internet Access support
Hardware
More
Education
Suffolk Community College
Associate
More
Full Biography

Full Name: Jeffrey Coachman
Email: Jeffrey(dot)Coachman(at)att(dot)net

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
FindingFilteredSubformRecords
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
ConcatenateMaiMergeCombineFormatMultipleStringsTextRichTextHTML
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

More
Languages
No Languages shown

Level Progress

Current: Level 74
Jeffrey needs 164,077 points to level up.
LVL 75
  • Overall
    74
  • Microsoft Access
    72
  • Microsoft Applications
    19
  • SQL
    16
  • Microsoft Office
    16
  • Microsoft Excel
    15
  • Microsoft Development
    14
  • Visual Basic Classic
    14
  • Databases
    12
  • Outlook
    9
  • VBA
    9
  • VB Script
    8
  • Microsoft SQL Server
    7
  • Microsoft Word
    6
  • Programming
    6
  • Visual Basic.NET
    5
  • Microsoft SQL Server 2005
    5
  • Adobe Acrobat
    5
  • .NET Programming
    5
  • Microsoft SQL Server 2008
    4
  • Microsoft SharePoint
    4
  • Office Productivity
    4
  • MySQL Server
    4
  • Windows 7
    3
  • Web Development
    3
  • Windows XP
    3
  • Software
    3
  • Windows Vista
    3
  • Microsoft PowerPoint
    3
  • Exchange
    3
  • ASP.NET
    3
  • DB Reporting Tools
    3
  • Oracle Database
    3
  • Spreadsheets
    3
  • HTML
    3
  • Email Servers
    3
  • XML
    2
  • Printers and Scanners
    2
  • Microsoft Legacy OS
    2
  • Web Browsers
    2
  • Web Development Software
    2
  • ASP
    2
  • Windows OS
    2
  • Office Suites-Other
    2
  • Project Management
    2
  • Microsoft 365
    2
  • QuickBooks
    2
  • InfoPath
    2
  • Crystal Reports
    2
  • Enterprise Software
    2
  • Lotus IBM
    2
  • E-Commerce
    2
  • Programming Languages-Other
    2
  • Web Components
    2
  • Windows Server 2003
    2
  • Microsoft Server OS
    2
  • Microsoft Server Apps
    2
  • Web Applications
    2
  • Security
    2
  • Web Languages and Standards
    2
  • Productivity Apps
    2
  • Images and Photos
    2
  • Programming Theory
    1
  • IT Administration
    1
  • Active Directory
    1
  • Microsoft DOS
    1
  • Project Management Software
    1
  • SBS
    1
  • Photos / Graphics Software
    1
  • System Programming
    1
  • Windows Server 2008
    1
  • Internet Explorer (IE)
    1
  • Microsoft Dynamics
    1
  • Tax / Financial Software
    1
  • Email Clients
    1
  • Miscellaneous
    1
  • System Utilities
    1
  • Groupware
    1
  • Microsoft Visio
    1
  • Windows Networking
    1
  • Email Software
    1
  • COBOL
    1
  • Editors IDEs
    1
  • PHP
    1
  • Page Layout Software
    1
  • Microsoft IIS Web Server
    1
  • SSRS
    1
  • Contact Management
    1
  • Document Management
    1
  • Joomla
    1
  • Web Graphics Software
    1
  • Scripting Languages
    1
  • C#
    1
  • Hardware
    1
  • Peripherals
    1
  • Powershell
    1
  • Networking
    1
  • Web Services
    1
  • Adobe Flash
    1
  • FoxPro
    1
  • Multimedia Programming
    1
  • Remote Access
    1
  • WCF
    1
  • FileMaker Pro
    1
  • Voice Recognition
    1
  • Installation
    1
  • JavaScript
    1
  • Cloud Computing
    1
  • Consulting
    1
  • Voice Over IP
    1
  • Windows 2000
    1
  • IBM System i
    1
  • Presentation Software
    1
  • Windows 8
    1
  • Desktops
    1
  • IP Telephony
    1
  • Internet / Email Software
    1
  • OCR
    1
  • Web Frameworks
    1
  • Fonts Typography
    1
  • Version Control
    1
  • Adobe Dreamweaver
    1
  • Operating Systems
    1
  • Windows Batch
    1
  • Laptops Notebooks
    1
  • Server Hardware
    1
  • Windows Live Mail
    1
  • JSP
    1
  • PC
    1
  • Citrix
    1
  • Anti-Virus Apps
    1
  • LibreOffice
    1
  • Encryption
    1
  • AntiSpam
    1
  • Application Servers
    1
  • Big Data
    1
  • Business Management
    1
  • C++
    1
  • Components
    1
  • Computer Games
    1
  • Google Workspace
    1
  • Microsoft OneNote
    1
  • Network Analysis
    1
  • Regular Expressions
    1
  • Server Software
    1
  • Software Firewalls
    1
  • Statistical Packages
    1
  • Storage
    1
  • iPhone
    1