Presentations

clsImExSpecs Presentation to the Access Europe User Group

A list of resources and further reading for my presentation on my custom Import/Export Specifications class module.

Mike Wolfe

• 5 min read
clsImExSpecs Presentation to the Access Europe User Group

Slide Deck

clsImExSpecs.pdf

Sample Files

The following files were used during the presentation:

Note that the sample database above was created live during the presentation.  It includes the full clsImExSpecs class module, the minimal ErrorMod error-handling module, and a Sale table that represents the imported Sale.xml data from above.

Presentation Recording

The presentation recording is available on YouTube on the Access User Groups YouTube Channel.

Further Reading

Creating and Editing Import Specifications via the Wizard
For one-off text file data imports, it’s hard to beat the simplicity of Microsoft Access’s built-in wizard.
No Longer SetMike Wolfe
Using the Wizard to Export to Text Files with Microsoft Access
In an effort to remain simple, the Access export to text file wizard manages to do the opposite, making simple updates to export specs unnecessarily cumbersome.
No Longer SetMike Wolfe
Documenting the Import-Export Specification System Tables
Documentation of the meaning and typical values that get saved to the Import-Export specification system tables: MSysIMEXSpecs and MSysIMEXColumns.
No Longer SetMike Wolfe

Here are some links to articles that came up during the presentation or were included in the chat:

Dark Mode in VBA
VBA may not have a preset “Dark Mode” like other modern development environments, but it’s not hard to create one yourself.
No Longer SetMike Wolfe
“Toggle” Hotkey for the Immediate Window
Am I the only one who finds it annoying that [Ctl] + [G] doesn’t *toggle* between the immediate window and the code window? Let’s fix that.
No Longer SetMike Wolfe
Everything You Need to Find Files
Or, should I say, You Need *Everything* to Find Files.
No Longer SetMike Wolfe
Use XML to Share Access Table Data and Avoid Internet Warnings
Anti-virus software and Microsoft policies make it harder than ever to share table data among Access users. The XML format is a simple way to avoid those roadblocks.
No Longer SetMike Wolfe
Better Global Constants in VBA with Dot-Driven Development
My global constant “C” class--with PredeclaredId = True--is a great alternative to traditionally-declared global Public Const’s.
No Longer SetMike Wolfe
Enum Type Naming Convention
The combination of “IntelliSense overload” and “global identifier case changes” convinced me I needed a different approach.
No Longer SetMike Wolfe

Past Presentations

If you enjoyed this presentation, you may want to check out some of my past presentations.  Each of these has accompanying videos of the presentation available on YouTube (links to YouTube included in articles below):

Form Templates Presentation to the Denver Area Access User Group
A list of resources and further reading for my presentation on Form Templates in Microsoft Access.
No Longer SetMike Wolfe
Advanced Combo Box Techniques
A list of resources and further reading to support my presentation on Advanced Combo Box Techniques.
No Longer SetMike Wolfe
ArrowKeyNav Presentation
A list of resources and further reading to support my presentation on Navigating Continuous Forms using WithEvents.
No Longer SetMike Wolfe
Troubleshooting Query Performance
A recording of the presentation, a list of resources, and further reading for my presentation on Troubleshooting Query Performance.
No Longer SetMike Wolfe
Defensive Programming - DevCon 2023
Links and resources from my talk tomorrow at Access DevCon Vienna 2023, Some Bugs are Better than Others: Defensive Programming Tips and Tricks.
No Longer SetMike Wolfe
Understanding COM - DevCon 2022
Links and resources from my talk today at Access DevCon Vienna 2022, Understanding COM.
No Longer SetMike Wolfe
Building Ribbons in Code
A list of resources and further reading to go with my Access User Group presentation on Building Ribbon Interfaces in Code.
No Longer SetMike Wolfe
DevCon 2021
Links and resources from my talk today at Access DevCon Vienna 2021, twinBASIC: The New Kid on the Block.
No Longer SetMike Wolfe
twinBASIC Update - DevCon 2022
Links and resources from my talk today at Access DevCon Vienna 2022, twinBASIC: Happy First Birthday!
No Longer SetMike Wolfe
twinBASIC Update: DevCon 2023
Links and resources from my talk today at Access DevCon Vienna 2023, twinBASIC + Access: Future Plans.
No Longer SetMike Wolfe

UPDATE [2024-02-02]: Added link to presentation recording on YouTube.

Never miss an article.

Sign up to receive a Sunday morning email with links and recaps of the seven articles published that week.
(I'll never sell your email. Unsubscribe any time.)


All original code samples by Mike Wolfe are licensed under CC BY 4.0