VBA Notes

Category: Personal Publisher: Aurel B. Cortez Total Views: 252 Posted On: 06-11-2025

Some Notes


Option Explicit

'Listview API
'-----------------------------Start Listview API-------------------------------------
Private Declare Function SendMessag ...
			Read More

 
	
		
		
			Load Listview from Recordset
			
				 Category: Personal
				 Publisher:  Aurel B. Cortez
				 Total Views: 206
				 Posted On:  07-11-2025
			
 
			
Routine to load Listview from recordset

    'Initialize our listview and columnheaders

    ListView1.View = lvwList ' lvwReport

    & ...
			Read More 	
		
 
	
 
	
		
		
			SQL Classes
			
				 Category: Personal
				 Publisher:  Aurel B. Cortez
				 Total Views: 112
				 Posted On:  07-11-2025
			
 
			
cPaging

 


Option Explicit

Private m_PAGE_CURRENT              As Long 'Store current page
Private m_PAGE_PREV                 As Long 'Store the pre ...
			Read More 	
		
 
	
 
	
		
		
			Calendar Control
			
				 Category: Personal
				 Publisher:  Aurel B. Cortez
				 Total Views: 172
				 Posted On:  11-11-2025
			
 
			
 

 

Usage: Must have form DatePickerForm



'Call this with the ffg. code
Private Sub txtDate_DropButtonClick()
    Dim v
    Set DatePicke ...
			Read More 	
		
 
	
 
	
		
		
			ADO Module
			
				 Category: Personal
				 Publisher:  Aurel B. Cortez
				 Total Views: 173
				 Posted On:  11-11-2025
			
 
			

Option Explicit

Private Declare PtrSafe Function GetShortPathName Lib "kernel32" Alias "GetShortPathNameA" (ByVal lpszLongPath As String, ByVal lpszShortPath As String, ByVal cchBuffer ...
			Read More 	
		
 
	
 
							
1
2
3
4