Tip Bank

DevX

ShowIcon – Extract an icon from a file and show it

Private Declare Function ExtractIcon Lib “shell32.dll” Alias “ExtractIconA” _ (ByVal hInst As Long, ByVal lpszExeFileName As String, _ ByVal nIconIndex As Long) As LongPrivate Declare Function DrawIcon Lib “user32” (ByVal

DevX

CConsole – A class for creating console applications

‘ CCONSOLE Class” Creates a console window and writes to it’ Example:’ Dim cons As New CConsole’ cons.WriteString “Hello World”Private Declare Function AllocConsole Lib “kernel32” () As LongPrivate Declare Function

DevX

Display the Windows Shortcut Wizard

You can programmatically start the Shortcut Wizard from your code, to give the end user the capability to create a new shortcut: Shell “rundll32.exe AppWiz.Cpl, NewLinkHere ” & App.Path, 1

DevX

Using ROWNUM To Retrieve

It is often necessary to get a list of values from multiple rows. Generally, this is done using the cursor, which tends to make the task more complicated.I tried to