Mike Wolfe - No Longer Set (Page 38)

Setting the Ribbon Name in Code

You don't need to use the options dialog to set a custom ribbon for your Microsoft Access application.

Set Report Properties in Bulk

Looking to set a report property, such as an event handler, to the same value for multiple reports? Use this routine to automate the whole process.

twinBASIC Weekly Update

twinBASIC Update: June 26, 2022

Highlights include container support, IDE bug fixes, and a modest request for a complete backward-compatible rewrite of MS Access in twinBASIC.

Week in Review

Week in Review: June 25, 2022

Highlights include an elegant solution to synchronized scrolling, a novel approach to db schema versioning, and a deep dive into recovering deleted db objects.

Code Library

GetAttr(): Ribbon XML String-Building Helper Function

When you're building strings in code with lots of optional values--such as ribbon XML attributes--this simple function helps keep your code readable.

Ribbon

XML Callbacks: Adding Functionality to the Office Ribbon

To unlock the full potential of the Microsoft Office ribbon, you need to understand the role of callback functions. This quick intro will get you started.

Ribbon

Office Ribbon Development Resources

Links to resources and ribbon builders for VBA developers who want to add a professional touch to their applications with custom ribbon interfaces.

Code Library

XmlWrap() Function

This convenience function helps you write more readable code when building Office Ribbon-flavored XML strings.

Code Library

TagWrap() Function

This convenience function helps you write more readable code when building strings with HTML-style opening and closing tags.

twinBASIC Weekly Update

twinBASIC Update: June 19, 2022

Highlights include improved support for 3rd-party ActiveX controls, a new location for tB IDE releases, and a discussion about where to put non-visual controls.

Week in Review

Week in Review: June 18, 2022

Highlights include building custom progress bars, creating organizational charts, and yet another Access bug [sigh].

Presentations

¡twinBASIC Va a Madrid!

¡Hola, Madrid! Muchas gracias a Juanjo Luna por invitarme a hablar en su conferencia anual de Access.

twinBASIC

HOW TO: Creating a Standard (non-ActiveX) DLL with twinBASIC

With twinBASIC, you no longer need C++ to build a standard DLL. Call high-performance code from VBA without needing the Windows registry.

COM

ActiveX vs. Standard DLLs

What's the difference between an ActiveX (COM) and Standard DLL? When would you choose one over the other?

Announcement

Access at Microsoft Build 2022

You'll never guess what the Access team talked about at the recent annual Microsoft Build conference. I'll give you a hint: it rhymes with "beta curse."

twinBASIC

HOW TO: Creating an Office COM Add-in with twinBASIC

Ever wish you could turn your VBA code into a COM add-in that would run in 32- AND 64-bit Office applications? It's easier than ever with twinBASIC.

twinBASIC Weekly Update

twinBASIC Update: June 12, 2022

Highlights include ActiveX control support on twinBASIC forms and a discussion about the (accidental?) interface constructor language feature.

Week in Review

Week In Review: June 11, 2022

Highlights include a better date picker control, dashboard-style gauges, and drawing shapes in Access reports.

Debugging

Fixing a Persistent "Write Conflict" Error

If you are getting consistent "Write Conflict" warnings when using bound forms to update SQL Server tables with datetime fields, there may be an easy fix.

Migration

Scripted SQL Server Migrations

Use this batch file to automatically backup a database on one instance of SQL Server and restore it on a different instance of SQL Server.

Deployment

Mark of the Web (MOTW) Support Among Zip Utilities

What happens to the Mark of the Web when you extract files from a downloaded .zip file? It depends on what you use to do the extraction.

Migration

SQL Server Migration Steps

My SQL Server migration philosophy consists of two priorities: (1) Avoid disasters and (2) Minimize production downtime.

Whiteboard Sessions

Microsoft Access: A Victim of Its Own Success

Looking for bold new features in Microsoft Access? Don't hold your breath.

twinBASIC Weekly Update

twinBASIC Update: June 5, 2022

Includes a sneak peek of the upcoming ActiveX Control Extender support in twinBASIC.

Week in Review

Week in Review: June 4, 2022

Highlights include major changes to the Access roadmap, Richard Rost's Beginner Access video course is now free, and research on developer interviews.