Jeffrey Coachman
  • Middle Island,
  • United States
Member Since: 2004/02/07
Industry: Accounting/Finance
Top Skills:
Tech Certifications:
Savant
Volunteer

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

More bio
Activity
Points this month14,132
Total points11,004,941
Questions: 126
Solutions: 8664
Articles:
Videos:
Courses:
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:
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
FindingFilteredSubformRecords
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
ConcatenateMaiMergeCombineFormatMultipleStringsTextRichTextHTML
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

More
Languages
No Languages shown

Level Progress

Current: Level 74
Jeffrey needs 245,059 points to level up.
LVL 75
  • Overall
    74
  • Microsoft Access
    72
  • Microsoft Applications
    19
  • Query Syntax
    16
  • Microsoft Office
    15
  • Microsoft Excel
    15
  • Microsoft Development
    14
  • Visual Basic Classic
    14
  • Databases
    12
  • Outlook
    9
  • VBA
    8
  • VB Script
    8
  • Microsoft SQL Server
    7
  • Programming
    6
  • Microsoft Word
    6
  • Visual Basic.NET
    5
  • Microsoft SQL Server 2005
    5
  • Adobe Acrobat
    5
  • .NET Programming
    5
  • Microsoft SQL Server 2008
    4
  • Microsoft SharePoint
    4
  • MySQL Server
    4
  • Windows 7
    3
  • Web Development
    3
  • Windows XP
    3
  • Office / Productivity
    3
  • Software-Other
    3
  • Windows Vista
    3
  • Microsoft PowerPoint
    3
  • Exchange
    3
  • ASP.NET
    3
  • DB Reporting Tools
    3
  • Oracle Database
    3
  • HTML
    3
  • Email Servers
    3
  • XML
    2
  • Microsoft Legacy OS
    2
  • Printers and Scanners
    2
  • Web Browsers
    2
  • Web Development Software
    2
  • ASP
    2
  • Windows OS
    2
  • Project Management
    2
  • QuickBooks
    2
  • InfoPath
    2
  • Crystal Reports
    2
  • Enterprise Software
    2
  • Spreadsheets
    2
  • Lotus IBM
    2
  • E-Commerce
    2
  • Programming Languages-Other
    2
  • Web Components
    2
  • Office Suites-Other
    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
  • Office 365
    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
  • 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
  • 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
  • IP Telephony
    1
  • Internet / Email Software
    1
  • OCR
    1
  • Web Frameworks
    1
  • Fonts Typography
    1
  • Version Control
    1
  • Desktops
    1
  • Adobe Dreamweaver
    1
  • Operating Systems
    1
  • Windows Batch
    1
  • Laptops Notebooks
    1
  • Server Hardware
    1
  • Windows Live Mail
    1
  • JSP
    1
  • PC
    1
  • Anti-Virus Apps
    1
  • LibreOffice
    1
  • Citrix
    1
  • Encryption
    1
  • AntiSpam
    1
  • Application Servers
    1
  • Big Data
    1
  • C++
    1
  • Components
    1
  • Computer Games
    1
  • Google Apps
    1
  • Microsoft OneNote
    1
  • Network Analysis
    1
  • Regular Expressions
    1
  • Server Software
    1
  • Software Firewalls
    1
  • Statistical Packages
    1
  • Storage
    1
  • iPhone
    1

Profile Validation

Email Verified
Expert Level Achieved