VB Tips

 
Home
Now in its 20th year. Visual Basic tips are listed on this page. Older ones are for VB 6.
Most newer ones are for VB.Net , VB 2005 , or VB 2008 .
Jump to Tips for Year
1997 1998 1999 2000 2001 2002 2003 2004 2006
2008 2009 2010 2011 2012 2013 2014 2015 2016
 
Top Downloads - Now in the 20th Year
Rank Web Page VB Source Volume
1 Create a VB Class to Process an Access Table using DAO
Create a VB Class to Process an Access Table using ADO
Create a VB.Net Class to Process a SQL Table using ADO Updated
CreateVBCode.zip [27k]
CreateVBCodeUsingADO.zip [54k]
See the details page.
v6, n2
v6, n7
v12, n1
2 Make VB's Dialog Boxes Larger - Updated April 2000
Make VB.Net's Dialog Boxes Larger - June 2002
See the Web Page v4, n4
3 Attach or Detach a SQL Server Database Using SMO See the details page. v13, n1
4 Update an Access Database With a Model's Schema using DAO DAOUpdate.zip [84k] v4, n2
5 VB Code to Generate a GUID
VB6 version updated December, 2005
GUID.zip [42k] VB6 Version
GUIDVB7.zip [12k]VB.Net
GUIDVB8.zip [13k]
v1, n1
6 Shell And Wait With Optional Terminate Shell.zip [34k vb6] v2, n5
7 ListView Basics LVBasics.zip [25k] v3, n12
8 Get Folder, Name or Extension from
Fully Qualified Name,
Plus: AddBackslash Method

Plus: AppPath for VB.Net
Path.zip [40k]
FilenameParseVB7.zip [32k]
v2, n10
9 Network User and Computer Name NetUser.zip [5k]
NetUserVB7.zip [12k]
v3, n5
10 Convert Long Color to RGB Values
System Color to Long Color Value
RGBDemo.zip [7k vb6]
SystemColorToRGBColor [4k vb6]
v2, n4
11 Show a File's Associated Icon in a ListView ListviewShowFileIcon.zip [14k] v6, n9
12 Location, Location, Location
Form Housekeeping
TBLocLoc.zip [24k vb6] v2, n2
13 Functions RegRead and RegWrite
Read and Write to the Registry
TBRegRd.zip [6k]
RegReadVB7.zip [11k]
RegReadVB8.zip [12k]
v1, n5
14 Add MRUs to Your Application MRUDemo.zip [20k vb5] v1, n9
15 Update Database to Allow Zero Length Strings AZLS.Zip [19k] v3, n10
-- Bouncing Golf Ball - Animated Cursor See Below  

Rank is based upon the last 3 month's downloads.
851 downloads in last 3 months. 1,212 in the prior 3 months.
Updated 2017/03/01

VB Tips 2016
Web Page All VB.Net 2008 Month Volume
Send a Text Message to a Smartphone via EMail SMSSendTextMessage.zip December v20, n5
Updated: Create a VB.Net Class to Process a
SQL Table using ADO - See below.
  December v12, n1
 
VB Tips 2015
Web Page All VB.Net 2008 Month Volume
Use Style.Add to Set a Label's Line Height Property LineHeight.zip December v19, n5
Cookies - Write, Read, Delete, Test for Cookie.zip September v19, n2
Find a Word in a String Using IndexOf FindWordInString.zip February v18, n7
Fancy Boxes using 'border-radius' and 'box-shadow' FancyBoxes.zip January v18, n6

VB Tips 2014
Web Page  All VB.Net 2008  Month Volume
Launch Browser using Windows Task Scheduler TaskSchedulerDemo.zip December v18, n5

VB Tips 2013
Web Page  All VB.Net 2008  Month Volume
Resize Window Based Upon Photo Size ResizeWindowBasedUponPhotoSize.zip August v17, n1
Find EMail Address in Text FindEMailAddress.zip July v16, n12

VB Tips 2012
Web Page  All VB.Net 2008  Month Volume
Overlay Images
Updated January 2016
OverlayFGontoBGImage.zip September
January 2016
v16, n02
Test Url Exists

ExistsUrl.zip

July v15, n12
Dynamic iFrame

DynamicIFrame.zip

June v15, n11
Gradient Background Image

Gradient.zip

May v15, n10
Sticky Heading and Footings

StickyHeaderAndFooter.zip

April v15, n9
Make a Seamless Repeating Background Image MakeSeamlessRepeatingBackgroundImage.zip March v15, n8
Dynamic Background Images

DynamicBackgroundImage.zip

February v15, n7
WebPaths - Get Various Request Properties
Add support for Mobile Devices

WebPaths.zip

January
May 2016
v15, n6

VB Tips 2011
Web Page  All VB.Net 2008  Month Volume
Popup a Photo in a New Window PhotoPopup.zip December v15, n5
Find Where in the World Using IP Address FindWhereInTheWorldUsingIPAddress.zip November v15, n4
Add YouTube Videos to a Web Site AddYouTubeToWebSite.zip October v15, n3
Working With Multi-Dimensional Arrays WorkingWithArrays.zip September v15, n2
CryptoQuote Solver A web application. August v15, n1
WonderWord Solver A web application. July v14, n12
Default Enter Button on Aspx Page DefaultButton.zip June v14, n11
Add or Remove Meta Tags AddRemoveMetaTags.zip May v14, n10
Using FrontPage with Asp.Net UsingFrontPageWithAspNet.zip April v14, n9
Copy SQL Server Database Schema to Another CopyDBsFromServerToServer.zip March v14, n8
Subroutine RW - Response Write ResponseWrite.zip February v14, n7
Dynamically Update a SQL Database Adding
Tables or Columns using SMO v 9/10
See the details page. January v14, n6

VB Tips 2010
Web Page  VB.Net  Month Volume
Create a VB.Net Class to Process a SQL Table
using ADO Updated
See the details page. December v14, n5
Add a Web Color Theme - cTable and cTheme
Updated January 2015 - Add 3D Effect
AddWebTheme.zip November
January 2015
v14, n4
Use the OleDbDataAdapter to
Read and Parse a CVS File into

a DataTable or Collection
CSVDataReader.zip [80k] October v14, n3
Backup and Restore a SQL Server Database BackupRestoreSQLServerDB.zip [80k] September v14, n2
Get a Domain's list of IP Addresses GetIPAddressesForDomain.zip [47k] August v14, n1
Excel Read Values from Spreadsheet ExelRead.zip [91k] July v13, n12
Javascript DisableButton Function Fails
with Safari and Chrome
  June v13, n11
Get Image Size Information ImageSize.zip [60k] May v13, n10
Button Graphic Maker
A Web Project
ButtonMakerAspNet.zip [44k] April v13, n9
Validate a Password's Format PasswordValid.zip March v13, n8
Test Credit Card TestCreditCard.zip [40k] February v13, n7
Which Browser
Updated for IE9
Updated for the iPad/iPhone
Updated for Edge
WhichBrowser.zip [42k] January
March 2011
June 2011
December 2016
v13, n6

VB Tips 2009
Web Page  VB.Net  Month Volume
Add Link html to a URL cAddURLTags.zip [1k] December v13, n5
Generate a Random Password GeneratePassword.zip [29k] November v13, n4
Checking a String for Empty with Function 'emt' emt.zip [2k] October v13, n3
Running a Single Instance on an Application SingleInstance.zip [21k] September v13, n2
Attach or Detach a SQL Server Database Using SMO See the details page. August v13, n1
Get SQL Servers and Databases Using SMO v 9/10 See the details page. July v12, n12
Copy Text to Clipboard from Aspx Page CopyToClipboard.zip June v12, n11
File or Folder Exists - Create and Remove a Folder FileFolderExists.zip [27k] May v12, n10
Connect to an MS Access Database using ADO See the details page. April v12, n9
Dynamically Add Rows and Columns to an Asp.Net Table DynamicTableSLN.zip [23k] March v12, n8
Add or Drop a SQL Server Database Relationship Using SMO cSQLRelationships.zip [2k] February v12, n7
Dump or Add html Non-Breaking Spaces and SomeBlanks emt.zip [2k] January v12, n6

VB Tips 2008
Web Page  VB.Net  Month Volume
Not Weekend - Calc Using 5 Day Week - Validate Date 5DayWeekSLN.zip [34k] December v12, n5
Cookies - Write, Read, Delete, Test for See September 2015 November
Updated September 2015
v12, n4
v19, n2
Download a File to the Client Browser Using
Response.WriteFile
cDownloadFile.Zip [1k] October v12, n3
A Dozen Date Functions
First/Last/Day of Prior/Current/Next Month and many more.
See the details page. September, Updated
December 2010
April 2011
v12, n2
Create a VB.Net Class to Process a SQL Table
using ADO Updated
See the details page. August, Updated
December 2010,
March 2011
December 2016
v12, n1

VB Tips 2006
Web Page  VB Source - Most VB 6  Month Volume
Enumerate Files from Starting Folder Using Extension
Uses Scripting Library [Scrrun.dll]
EnumSelectedExt.zip [37k] July v9, n12
Send E-Mail Using Lotus Notes LotusNotesEMail.zip [33k] March v9, n8

VB Tips 2004
Web Page  VB Source - Most VB 6  Month Volume
Launch Windows Explorer Displaying a Specified Folder LaunchExplorer.zip [11k] November v7, n10
Make VB6, SP6 Dialog Boxes Bigger See the Web Page April v7, n9
Set File Attributes using a Class Module
Read Only or Read Write
ReadWrite.zip [16k] March v7, n8
Copy File Creating Name using a Class Module - 'Copy (n) of'
Updated February 2006 - Add optional prefix.
CopyOfName.zip [28k] February v7, n7
Launch Excel and Open a Spreadsheet From VB6
using a Class Module
ExcelLaunch.zip [18k] January v7, n6

VB Tips 2003
Web Page  VB Source - Most VB 6  Month Volume
Mouse Push/Pop, Save then restore a Mouse Cursor Stack
using a Class
MouseDmoVB6.Zip [7k]
MouseDmoVB7.zip [14k]
December v7, n5
Forward a Command Line from one Application to Another
Using a DLL - Part II
VB .Net and C# Versions
By Michael Culley
MyAppVBNet.zip [45k]
MyAppCSharp.zip [42k]
November v7, n4
Forward the Command Line from One Instance to Another
Part I VB .Net, C# andVB6 Versions
By Michael Culley
ForwardCommandLineVBNet.zip [14k]
ForwardCommandLineCSharp.zip [11k]
ForwardCommandLineVB6.zip [16k]
October v7, n3
Using a VB .Net Class Library MyClassLibrary.zip [32k] September v7, n2
Update an Access Database with a Model's Schema
using VB.Net and ADOX
DBUpdateNetTest.zip [186k] August v7, n1
Copy Database with Data using ADO CopyDatabaseADO.zip [102k] July v6, n12
Update an Access Database With a Model's Schema
using VB6 and ADOX
ADOUpdate.zip [103k] June v6, n11
Launch Internet Explorer using the SHDocVw Library LaunchIE.zip [6k] May v6, n10
Show a File's Associated Icon in a ListView ListviewShowFileIcon.zip [14k] April v6, n9
Create an MSAccess Relationship Using ADOX ADOXCreateRelationship.zip [10k] March v6, n8
Create a VB Class to Process an Access Table using ADO CreateVBCodeUsingADO.zip [54k] February v6, n7
Using Shlwapi.dll [IE5] to Auto Complete a Text Box SHAutoComplete.zip [9k] January v6, n6

VB Tips 2002
Web Page  VB Source - Most VB 6  Month Volume
Copy Database with Data Using DAO CopyDatabase.zip [88k] December v6, n5
Shell and Wait with Terminate - VB.Net Version ShellVB7.zip [29k] November v6, n4
Hand Cursors - Mouse Pointers Hands.zip [8k] October v6, n3
Create a VB Class to Process an Access Table using DAO CreateVBCode.zip [27k] September v6, n2
Location, Location, Location, VB.Net/2005 Version TBLocLocVB7.zip [70k]
TBLocLocVB8.zip [71k]
August v6, n1
Functions: NotTooSmallBig, NotTooSmall, NotTooBig NotTooSmallBig.zip [7k] July v5, n12
Status and StatusOff
Using VB's Status Bar
StatusBar.zip [6k]
StatusBarVB7.zip [15k]
June v5, n11
Functions TraceOpen and TraceWrite
Tracing a Compiled Application
TraceWrite.zip [9k] May v5, n10
Using ADO to Read and Parse a Text File ADOReadParseTextFile.zip [23k] April v5, n9
Save Memo Field in DAO Database SaveMemoField.zip [9k] March v5, n8
Sort Icon in ListView Header SortIconListView.zip [9k] February v5, n7
Web Log Analysis, Analyze Urchin Web Logs WebLog.zip [58k] January v5, n6

VB Tips 2001
Web Page  VB Source - All VB 6  Month Volume
Using the Command function to
Pass Arguments to an Application
UsingCommand.zip [13k] December v5, n5
Is Registered
Determine if a DLL/OCX is registered
Registered.zip [10k] November v5, n4
Done Recently Function
Schedule Tasks
DoneRecently.zip [6k] October v5, n3
Send E-Mail Using Shell EMailUsingShell.Zip [34k] September v5, n2
Using 'With Events' WithEvents.Zip [6k] August v5, n1
Dynamic Image List, and
Dynamic Toolbar
Dil.zip [10k] July v4, n12
Restrict a Form's Size, and
Moved Event
MinWin.zip [44k] June v4, n11
Send Exit Code, and
Is Executing from IDE?
ExitCode.zip [16k] May v4, n10
Julian Date to VB Date and Back Julian.zip [6k] April v4, n9
TreeView Disable Node tvwDisableNode.zip [30k] March v4, n8
Encode/Decode a String Encode.zip [6k] February v4, n7
Get Available Disk Space and
Encapsulated Browse for Folder
FreeSpace.zip [11k] January v4, n6

VB Tips 2000
Web Page  VB Source - All VB 6  Month Volume
Send Text from One App to Another
Activating a 'Previous Instance'
Send2App.zip [26k] December v4, n5
Make VB's Dialog Boxes Larger - Updated April 2000
Make VB.Net's Dialog Boxes Larger - June 2002
See the Web Page November v4, n4
Store File in a Jet [Access] Database Field
DAO and ADO Versions
StoreFile.zip [148k]
StoreFileADO [150k]
October v4, n3
Update an Access Database With a Model's Schema using DAO DAOUpdate.zip [84k] September v4, n2
Desktop Wallpaper Pictures -- August v4, n1
ListView Basics LVBasics.zip [25k] July v3, n12
Using Conditional Compilation Arguments CCA.zip [13k] June v3, n11
Update Database to Allow Zero Length Strings AZLS.Zip [19k] May v3, n10
Show File Properties ShowProp.Zip [12k] April v3, n9
Set ListView Column Widths Using SendMessage API LVMax.Zip [6k] March v3, n8
Launch a File Using Its Associated Application ShellEx.Zip [17k] February v3, n7
Get Fully Qualified File Name using TypeLib Information FileInfo.Zip [27k] January v3, n6

VB Tips 1999
Web Page VB Source - All VB 6 Month Volume
Network User and Computer Name NetUser.zip [5k]
NetUserVB7.zip [12k]
December v3, n5
Generate Password GenPass.zip [7k] November v3, n4
Four Functions
1. FirstDayOfNext Month
2. NotWeekend
3. ForceUpperOrLowerCase
4. RemoveSpecialCharacters
FourFuns.zip [8k] October v3, n3
RegTool - Using RegEdit in Batch Mode RegTool.zip [44k] September v3, n2
Using the File System Object to
Read and Write ASCII files.
FSODemo.zip [15k] August v3, n1
What I Learned about DAO 3.6 and Jet 4.0 DmoDAO36.zip [3k] July v2, n12
Sleep - Allow Other Processes to Continue Sleep.zip [5k] June v2, n11
Get Folder, Name or Extension from
Fully Qualified Name,
Plus: AddBackslash Method

Plus: AppPath for VB.Net
Path.zip [40k]
FilenameParseVB7.zip [32k]
May
Oct 2005
Jan 2008
v2, n10
Drag and Drop Using OLE DDOle.zip [30k] April v2, n9
Consultant's Y2K Count Down Screen Saver Y2KCD.Zip [16k] March v2, n8
Truncate Path and File Name
using API DrawText
Trunc.Zip [14k] February v2, n7
Database Query Search  - Useful for
searching for Nested Queries
DBSearch.zip [51k] January v2, n6

VB Tips 1998
Web Page VB Source Month Volume
Shell And Wait With  Optional Terminate Shell.zip [34k vb6] December v2, n5
Convert Long Color to RGB Values
System Color to Long Color Value
RGBDemo.zip [7k vb6]
SystemColorToRGBColor [4k vb6]
November v2, n4
IsAuthor [is the author running the app] IsAuthor.zip [4k vb4]
IsAuthorVB8.zip
October v2, n3
Location, Location, Location
Form Housekeeping
TBLocLoc.zip [24k vb6] September v2, n2
Connect Me to the Web
Connect to Favorites
TBGoWeb200502.zip [82k] August 1998
November 2004
February 2005
v2, n1
Which Operating System
and Which NT
 modOS.zip [27k vb6] July v1, n12
Active Desktop - Launch Bar Tip -- June v1, n11
Build Class Properties TBBCP.zip [77k vb6] May v1, n10
Add MRUs to Your Application MRUDemo.zip [20k vb5] April v1, n9
Temp Name Please
Get Temp Path and Name
TmpNmPls.zip [4k vb5] March v1, n8
Lock Me Away - VB Erase Array Bug -- February v1, n7
Treeview Control - Performance -- January v1, n6

VB Tips 1997
Web Page VB Source - VB 5 Month Volume
Functions RegRead and RegWrite
Read and Write to the Registry
TBRegRd.zip [6k]
RegReadVB7.zip [11k]
RegReadVB8.zip [12k]
December v1, n5
Start Windows 95 or Windows NT Using Boot.Ini BootIni.zip [8k]  November v1, n4
Referential Integrity Generates Index
Copying DAO Indexes
-- October v1, n3
Passing Parameters to a Data Control -- September v1, n2
VB Code to Generate a GUID
VB6 version updated December, 2005
GUID.zip [42k]
GUIDVB7.zip [12k]VB.Net

GUIDVB8.zip [13k]
August
November 2002
v1, n1
Associated Database Tips
Web Page - Click to View Month Year Volume
Allow Zero Length String May 2000 v3, n10
Backup and Restore a SQL Server Database September 2010 v14, n2
Connect to an MS Access Database using ADO April 2009 v12, n9
Copy Database with Data using DAO or ADO July 2003 v6, n5
Copy SQL Server Database Schema to Another March 2011 v14, n8
Create VB Class Module Code for ADO February 2003 v6, n7
Create VB Class Module Code for DAO September 2002 v6, n2
Create VB.Net Class to Process a SQL Table using ADO
      Add methods, Copy, Count, Compare
August
December
2008
2010
v12, n1
v14, n5
Create Jet Relationship using ADOX March 2003 v6, n8
Create SQL Relationship using SMO February 2009 v12, n7
Dynamically Update a SQL Database Adding Tables or Columns using SMO January 2011 v14, n6
Save Memo Fields in Database Using DAO March 2002 v5, n8
Store File in Jet Database October 2000 v4, n3
Update an Access Database with a Model's Schema using VB6 and DAO September 2000 v4, n2
Update an Access Database with a Model's Schema using VB6 and ADOX June 2003 v6, n11
Update an Access Database with a Model's Schema using VB.Net and ADOX August 2003 v7, n1
Use the OleDbDataAdapter to Read and Parse a CVS File into
      a DataTable or Collection
October 2010 v14, n3
Using ADO to Read and Parse a Text File April 2002 v5, n9

History

May 2016 - I am not longer able to publish a top-ten list of most downloaded tips. The new server installed this month at GoDaddy does not keep records of tip downloads.
November 2012 - I am no longer creating a tip-of-the-month. I will create a new tip when I find something useful to publish.
November 2011 - All content was moved from buygold.net to larryrebich.com. Consequently the number of hits to this content was reduced - search engines have not yet indexed all the content. So the statistics for a few months will show a reduction in site usage.
April 2011 - I recently created a domain called: www.larryrebichtips.net. Tips found at this domain compliment the tips documented here. They can be run interactively.
April 2010 - I recently completed an RV Park reservation system. I am an investor in several parks. I call the reservation system WebInACan and the domain is 72d.me [72 degrees where our guests want to be]. I will publish some of the code written for that application as a tip-of-the-month.
August 2008 - Restart - I recently completed a major ASP.Net, VB.Net, SQL Server web application for a client. During the next few months I will publish some of the code written for that application as a tip-of-the-month.
June 2004 - The End - I've been Googled - After almost 8 years I am discontinuing publishing a Tip-Of-The-Month. During the past few months every time I think I've got a good tip I use Google to find that it has been published already, in most cases more than once. I will continue to maintain this site, and issue updates to existing tips and perhaps publish a new one if I can't find it on the web already. Its been a good run but all good things end sooner or later - now it is sooner.

Bouncing Golf Ball - Animated Cursor

Some years ago I designed an animated cursor [using MicroAngelo] that shows a golf ball bouncing off a golf club. If you would like a copy [1k] then click the preview picture. If you need instructions on how to change a cursor [mouse pointer] click here. This has become a popular download. More than 8,200 downloads since December 1999.

Recommended Software

From time-to-time I am asked to recommend software. See my recommended list by clicking here

Home    About... 

Updated 2017/03/01