See My Code Tools

CodeDisk Word/VBA
Outlook/VBA ADO Code

Also see my "Did you know?" page

Hard To Find Tips:

1. Bring window to top by using an API
2. Minimize the MS Access parent window using an
API
3. Make table querydef warning message
4. Compare changed records in multiple tables
5. Connecting VB 3.0 to Access 97 data
6. Connecting VB 3.0 To MS Excel Without OLE and DDE
7. Using an
API to get the computer name from VB 4.0 (16-bit)
8. FindWindowEX
(API) VB 5.0
9a. Export Access table to Foxpro via VB 5.0
9b. Calling MS Access Objects From Another Application
10. ODBC query / Stored Procedures using the Connection collection
11. ODBC pooling
(API) VB 5.0
12. Transferring MS Excel data to MS Access via VB 5.0
13. RegQueryValueEx
(API) fails in VB 6.0
14. Using the GetVolumeInformation
(API) via VB (32-Bit) or MS Access (32-Bit)
15. Inserting data to a MS Word bookmark via VB/VBA (32-Bit) -
(Click here for more Word code solutions)
16. List last files opened via
(API) VB (32-Bit)
17. How to use the more elegant file browser
API instead of the Windows File Open/Save dialog API
18. How to call a Word macro from your application -
(Click here for more Word code solutions)
19. How to enable/disable a control box of a form, report, or the Access parent window via
API
20. How to query Outlook address book entries -
(Click here for more Outlook code solutions)
21. How to check the validity of an Outlook email address -
(Click here for more Outlook code solutions)
22a. How to handle the email logon profile prompt (Plus Mass Emailing) -
(Click here for more Outlook code solutions)
22b. How to email an attachment through automation to Outlook -
(Click here for more Outlook code solutions)
22c. How to query your registry
(API) - (Click here for more VBA code solutions)
23a. How to parse the numbers out of a street address -
(Click here for more VBA code solutions)
23b. How to parse a filename from a path -
(Click here for more VBA code solutions)
24. How to return field names from a table -
(Click here for more VBA code solutions)
25. How to return the Windows and Windows System directory/folder name
(API) - (Click here for more VBA code solutions)
26. How to determine if MS Word is loaded
(API) - (Click here for more VBA code solutions)
27. How to check for an exclusively opened database -
(Click here for more VBA code solutions)
28. How to place a phone call through VB/VBA code
(API) - (Click here for more VBA code solutions)
29. How to select a disk file through VB/VBA code
(API) - (Click here for more VBA code solutions)
30. How to write to different Excel sheets -
(Click here for more VBA code solutions)

31. How to call the color dialog box - (Click here for more VBA code solutions)
32. How to change the column (field) size or data type - (Click here for more VBA code solutions)
33. How to seek the Primary Key using ADO - (Click here for more ADO code solutions)
34. How to return the user name (API) - (Click here for more VBA code solutions)
35. How to check for a bad filename - (Click here for more VBA code solutions)

 

Click here to contact me for consulting and/or training.