Features store/recall/exchange, undo/redo, copy/paste, all vb math operators and vb math functions. The math engine/expression evaluator come from the MS knowledge base article Q86688. Also features tray icon on minimize, drag and drop of form without caption bar, popup options menu with usage info, undo/redo history to twenty levels, auto clear when new expression, always-on-top option and more.… Read More »

This is a little something that I put together about thirteen years ago to manage recipes. Comes with database of 11,001 recipes. The main reason for building this was to learn how to interact with databases and grid controls. This does both, while giving you some tasty treats to sample. I cracked it open this morning in order… Read More »

This is a simple demonstration of how to give a standard combo box auto complete functionality.  As the user types, the input is matched with the items in the combo box. Attachments File Uploaded Size 924-20180120-090133-AutoCompleteComboBox.zip 1/20/2018 9:01:33 AM 1498

Here is a small project to generate css code for html to create a shadow for text. Hope you like it. Attachments File Uploaded Size 923-20180120-085112-CSSTextShadow.zip 1/20/2018 8:51:12 AM 5937

This is a string handling function that that reverse a given string. For example, Good Morning becomes gninroM dooG. The code reads a string into an array, which is no surprise. We could use a temporary “working” string, or an array to achieve the goal. What is a bit different here is that as the string is read in from the… Read More »

This snippet of code shows how to connect to a database using a Data Source Name (DSN), and a reference to Microsoft ActiveX Data Objects (ADO). To make the reference to ADO, while in the IDE, click Project, References. In the References window, select the version of MS ADO that you wish to use. In the picture below,… Read More »

Keep your application on top of all other applications. Comes in handy if you’re writing a “toolbar” type of application. Place the following code in a module. This is the reference and configuration for the system API that we are going to use to make our window topmost. Private Declare Function SetWindowpos Lib “user32” ( _    ByVal hWnd As… Read More »

This module allows you to write text to the Windows Event Log with with a single method call. Includes options for Type, Source, Category, and Event. Usage LogEvent([Applicaiton Name], [EventLog Type], [Msg to be logged], [Optional Event ID], [Optional Category Number]) Example Dim ret as Longret = LogEvent(“TestApp1”, EVENTLOG_SUCCESS, “Success event!!!!”) Code Copy the entire code below into… Read More »

This code demonstrates how to send mouse clicks to another application using the SendInput API, in user32.dll. First, you’ll want to place the following code in a module. This is where you define some constants, and make reference to the API you are going to use. Public Structure MOUSEINPUT    Public dx As Integer    Public dy As Integer    Public mouseData As Integer    Public… Read More »

I’ve been looking around for this code and no one could provide it. So finally I wrote it. It checks for duplicates in an array and returns true if there are any. Public Function AnyDup(NumList As Variant) As Boolean    Dim a As Long, b As Long    ‘Start the first loop    For a = LBound(NumList) To UBound(NumList)   … Read More »