The actual data type that LongPtr resolves to depends on the version of Office that it is running in LongPtr resolves to Long in 32-bit versions of Office, and LongPtr resolves to LongLong in 64-bit versions of Office. VBA now includes the variable type alias LongPtr.

Three important additions are the LongPtr type alias, the LongLong data type, and the PtrSafe keyword. The table at the bottom of this document summarizes the new VBA language features. To address this problem and enable VBA code to work correctly in both 32-bit and 64-bit environments, several language features have been added to VBA. This can result in memory overruns, unexpected results in your code, and possible application failure. The problem with running legacy VBA code in 64-bit Office is that trying to load 64-bits into a 32-bit data type truncates the 64-bit quantity. Included with the course is free, unlimited support and advice via e-mail.You only need to modify VBA code if it runs in the 64-bit version of Microsoft Office. It is assumed, however, that users of the course are familiar with the Visual Basic environment and the steps involved in building a Visual Basic application (such background can be gained from our LEARN VISUAL BASIC 5 and LEARN VISUAL BASIC 6 courses). No previous experience working with databases is presumed. Visual Basic and databases is presented using a combination of over 700 pages of course notes and actual Visual Basic examples. For Visual Basic 6 users, topics such as the ADO (ActiveX data object) data control and data environment, ADO data bound controls, and the data report designer are also covered. Topics covered include: database structure, database design, Visual Basic project building, the DAO (data access object) data control, data bound controls, proper interface design, structured query language (SQL), and database reports.

Visual Basic and databases is a tutorial that provides a detailed introduction to using Visual Basic for accessing and maintaining databases for desktop applications.

Vb6 download