Tip Bank

DevX - Software Development Resource

Caveats of the CopyMemory API function

Here’s the correct declaration of the CopyMemory API function, which is so useful whenever you want to move a block of bytes between two memory locations: Declare Sub CopyMemory Lib

DevX - Software Development Resource

MakeFileName – Create a file name out of its parts

‘ Make a complete file name by assemblying its individual parts’ if Extension isn’t omitted, it overwrites any extension held in BaseNameFunction MakeFileName(Drive As String, Path As String, BaseName As

DevX - Software Development Resource

Retrieving Bitmap properties

The Picture box control does not directly expose any property that returns information on the bitmap currently loaded. You can retrieve this information by calling the GetObject API function, passing

DevX - Software Development Resource

Retrieve the currency symbol

It is very simple to retrieve the correct currency symbol, using just plain VBA statements: currSymbol = Trim$(Replace(FormatCurrency(0,0), “0”, “”)) If you can also determine if the symbol precedes or

DevX - Software Development Resource

Tricks with LCase and UCase

There are a few tricks that you can do with LCase$ and UCase$ functions. I doubt you will be using this tip in all your applications, but here they are

DevX - Software Development Resource

Always ensure that a printer is installed

Many developers incorrectly assume that a printer is always installed on their customers’ machines, and therefore omit to check that this is actually the case. The following function, deceiptively trivial,