AL: Updating API calls in VBA to work with 64 Bit, How To + API Viewer using Access - Peter Cole
2.7 هزار بار بازدید -
2 سال پیش
-
Power-packed session with Peter Cole.
Power-packed session with Peter Cole. He shows how to manually change API calls to work in 64-bit. Microsoft has a file with definitions you can download.
https://microsoft.com/en-us/download/...
Peter explains what you need to know to understand the different parts of an API declaration. He describes the uses of the PtrSafe keyword and the new LongPtr (Long Pointer) data type. What's the difference between Long and LongLong? What's the Any data type?
While it's nice to have a way to lookup the API syntax, and manually make changes yourself, the file you can get from Microsoft has some inconsistencies. It also takes time to find what you're looking for.
Peter created a free Access database application to give you an easy way to search the definitions for Declares, Constants, and Types. Updated version is here:
https://www.thememydatabase.co.uk/acc...
it's free -- click the Download button and then click Add to Cart in the screen that pops up. There won't be a charge.
If you have a declaration that needs to be updated, you can search for the correct Declare statement, see what it needs to say, and it will be ready on the clipboard for easy insertion into your VBA code.
If you want to do a web search for more information about a particular definition, the application constructs a search string you can paste into a web browser to get good details.
He shows with step-by-step examples how to update not only the Declarations and Types but also the code where Declared functions are used.
The examples range from the simplest to extremely complex.
Peter clarifies the often misunderstood use of the compiler directive #If Win64..
It is only required for 13 of the 1550 declarations in the text file.
He explains the #If VBA7 directive is only required if code has to be run in pre 2010 Office installation.
Peter finishes by demonstrating a utility that he has developed that updates an existing database, containing all the examples, with a single click. Having shown the update process he shows how the utility has created test forms to check that the updated code is working in 64 -bit.
00:00 Introduction
Objective
01:41 Recap Api usage
... more times to be added later
Example Declare
PtrSafe
text file download
Access32to64 Samples
Code Find User
Samples Clipboard
Clipboard Code
API Viewer
LongPtr
Test Clipboard
Text Size fit.
Details from web
Compiler Directives
VBA7
Update (The Slow way)
The Quick way...
Auto Updated
Test Forms
Updating API calls in VBA to work with 64 Bit, free Access tool
by Peter Cole ( ThemeMyDatabase.co.uk )
Tuesday 30 November 2021
AccessUserGroups.org
Lunchtime chapter host is Maria Barnes
Last Tuesday @ noon Central time CT -- join us!
https://accessusergroups.org/lunch/
SUBSCRIBE for MORE videos! ► https://bit.ly/AUGYoutube
✓ Join our online Access User Groups with free membership.
► Facebook ◄
Facebook: AccessUserGroups
► Twitter ◄
Twitter: AccessUserGroup
https://microsoft.com/en-us/download/...
Peter explains what you need to know to understand the different parts of an API declaration. He describes the uses of the PtrSafe keyword and the new LongPtr (Long Pointer) data type. What's the difference between Long and LongLong? What's the Any data type?
While it's nice to have a way to lookup the API syntax, and manually make changes yourself, the file you can get from Microsoft has some inconsistencies. It also takes time to find what you're looking for.
Peter created a free Access database application to give you an easy way to search the definitions for Declares, Constants, and Types. Updated version is here:
https://www.thememydatabase.co.uk/acc...
it's free -- click the Download button and then click Add to Cart in the screen that pops up. There won't be a charge.
If you have a declaration that needs to be updated, you can search for the correct Declare statement, see what it needs to say, and it will be ready on the clipboard for easy insertion into your VBA code.
If you want to do a web search for more information about a particular definition, the application constructs a search string you can paste into a web browser to get good details.
He shows with step-by-step examples how to update not only the Declarations and Types but also the code where Declared functions are used.
The examples range from the simplest to extremely complex.
Peter clarifies the often misunderstood use of the compiler directive #If Win64..
It is only required for 13 of the 1550 declarations in the text file.
He explains the #If VBA7 directive is only required if code has to be run in pre 2010 Office installation.
Peter finishes by demonstrating a utility that he has developed that updates an existing database, containing all the examples, with a single click. Having shown the update process he shows how the utility has created test forms to check that the updated code is working in 64 -bit.
00:00 Introduction
Objective
01:41 Recap Api usage
... more times to be added later
Example Declare
PtrSafe
text file download
Access32to64 Samples
Code Find User
Samples Clipboard
Clipboard Code
API Viewer
LongPtr
Test Clipboard
Text Size fit.
Details from web
Compiler Directives
VBA7
Update (The Slow way)
The Quick way...
Auto Updated
Test Forms
Updating API calls in VBA to work with 64 Bit, free Access tool
by Peter Cole ( ThemeMyDatabase.co.uk )
Tuesday 30 November 2021
AccessUserGroups.org
Lunchtime chapter host is Maria Barnes
Last Tuesday @ noon Central time CT -- join us!
https://accessusergroups.org/lunch/
SUBSCRIBE for MORE videos! ► https://bit.ly/AUGYoutube
✓ Join our online Access User Groups with free membership.
► Facebook ◄
Facebook: AccessUserGroups
► Twitter ◄
Twitter: AccessUserGroup
2 سال پیش
در تاریخ 1400/10/30 منتشر شده
است.
2,795
بـار بازدید شده