Search results

This example shows how to turns a popup Microsoft Access form into a special always-visible sidebar or top/bottom bar on your screen — similar to the Windows taskbar, but completely customizable and made for your database application. Main things it can do: Sticks to one edge of the screenYou...

This example shows how to modify the behaviour of the MsgBox function by increasing the font size, buttons and window. It's far from being perfect, but it can be useful as a starting point for those who want customize larger MsgBox messages. Some examples:

After reading this article by Colin Riddington also known as @isladogs : https://isladogs.co.uk/msg-box-timeout/index.html I've been experimenting with this topic and discovered that we can change the title, message, or button caption of a standard MsgBox after it has been displayed using some...

Selecting files/folders using Windows API. I don't think this topic is new, but I couldn't find an easy way to drag one or more files from Windows Explorer and drop them into a textbox, so after doing some AI research, I ended up with this database. Warning! In 32 bit MS Access this code is...

This example shows how to save any text from the clipboard to a table so that it can be pasted later anywhere.

This code allows you to place a small status icon (e.g., a red circle, a green check, or a number icon) over your Access taskbar button. It also allows to create and display dynamic images (using GDI+) over the taskbar button. Some examples: If you are opening multiple front ends on the same...

This week I came across that I can set up a two-line title in pop-up forms, but not in standard forms, using some code like this: Me.Caption = "First line " & vbCrLf & " Second line" According to my tests, it only works in Windows 11 and on popup forms, but some people have reported...

As far as I know, there is no easy way to detect when records are scrolled in a continuous form using the vertical bar for example. This example attempts to fill this gap by using a class that detects when records are scrolled using a tricky method: - In the details section, there is a dummy...

This is another approach of the example I upload a few days ago: https://www.access-programmers.co.uk/forums/threads/convert-all-the-old-check-box-controls-on-a-form-to-a-modern-style.335129/ This example uses image controls to display the checkbox status and a transparent button to toggle its...

After reading this article by Colin @isladogs : https://www.isladogs.co.uk/settings-form-toggle/index.html, I thought it would be a good idea to find a simple way to convert existing forms with many checkboxes to a new modern style easily. So, I came up with the idea of creating a form wrapper...

This is an example how to replace the behaviour of tooltips in MS Access using classes. Some of the options are: - Tooltips are displayed with no delay. - Tooltips with or without Icons and titles. - Customize font and background tooltip text colors. Diferent customizations can be applied to...

This is an example of how to use a simple class to color selected labels in checkboxes and optiongroup controls. Example:

The short answer is: No So you might be wondering: “What is the maximum number of objects in a database?” The short answer is: “Nobody knows it!” I’m going to explain what tests I’ve done and what the results are: I have developed an easy procedure that is able to create any number of new...

VBA string functions: Len(),Right(), Instr(), etc. don’t work as expected with Unicode strings that contains code points above 65535, so I developed some string functions to manage this kind of strings. I know that Unicode characters above 65535 are rarely or never used, but I think it’s...

If I print some hexadecimal values, this is the result: ? &HF 15 ? &HFF 255 ? &HFFF 4095 ? &HFFFF -1 ? &HFFFFF 1048575 ? &HFFFFFF 16777215 ? &HFFFF = &HFFFFFFFF True ? &HFFFF , &HFFFFFFFF -1 -1 All hex decimal values from &H0000 to &HFFFF are considered signed integer type so...

Sometimes it can be interesting to print the recordset bookmark values assigned by Access. This simple function transforms the Variant value in an Hex value that can be printed. Output example: 00-2A-25-03 Public Function BookmarkToHex(bookmarkValue As Variant)...

This example shows how to add an icon to the Notification Area /Systray), with different menu options and how to hadle them. If no icon is supplied then MS Access Icon is used to show the menu options.

When we want to use an external library in VBA we usualy use Early or Late binding to access their methods or properties, but this example shows we can execute functions in some libraries loading them at runtime without declaring them. I don't know if it it can be useful or not, but I found it...

This database shows how concurrency can be used in MS Access using Doevents. It also shows that if a process is not dessigned to be used concurrently and uses Doevents function in it , you have to prevent it from users to execute multiple times. Concurrency is when two or more tasks can start...

This is a compilation of different techniques I have found and adapted using images, buttons, labels, etc,