Porting VB-Specific Objects to Access 8.0

Code portability is extremely important, especially now that VBA is available in so many products. Someproblems might occur if you want to use VB4 or VB5 code in Access 8 without making any changes. If thecode you are porting references some VB-specific object, object method, or property, Access complainswhen you compile the imported code. For instance, the “App” object exists in VB but not in Access.Therefore, this statement won’t compile under Access:

 Msgbox App.Title

To get around this problem, create a class in Access 8 to “replace” the VB4 object, method, or property notavailable in Access. In this case, create a clsVBShadow class in Access:

 Option Compare DatabaseOption ExplicitPrivate strTitle As StringPrivate strEXEName As StringPrivate strMin As StringPrivate Sub Class_Initialize()        strTitle = "Microsoft Access"         ' Or whatever you want to return.        strEXEName = "?"        strMin = "?"End SubPublic Property Get Title() As String        Title = strTitleEnd PropertyPublic Property Get EXEName() As String        EXEName = strEXENameEnd Property' complete with more properties...

In any module in your Access 8 application, declare this global object:

 Public App As New clsVBShadow

At this point, any code you import from VB4 that accesses the App object still works unchanged, and youcan replace each method or property of that object with what you want.

Share the Post:
Share on facebook
Share on twitter
Share on linkedin


The Latest

your company's audio

4 Areas of Your Company Where Your Audio Really Matters

Your company probably relies on audio more than you realize. Whether you’re creating a spoken text message to a colleague or giving a speech, you want your audio to shine. Otherwise, you could cause avoidable friction points and potentially hurt your brand reputation. For example, let’s say you create a

chrome os developer mode

How to Turn on Chrome OS Developer Mode

Google’s Chrome OS is a popular operating system that is widely used on Chromebooks and other devices. While it is designed to be simple and user-friendly, there are times when users may want to access additional features and functionality. One way to do this is by turning on Chrome OS

homes in the real estate industry

Exploring the Latest Tech Trends Impacting the Real Estate Industry

The real estate industry is changing thanks to the newest technological advancements. These new developments — from blockchain and AI to virtual reality and 3D printing — are poised to change how we buy and sell homes. Real estate brokers, buyers, sellers, wholesale real estate professionals, fix and flippers, and beyond may