Search results

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,

Until recently I thought that we couldn't call APIs that return a LongLong values using 32bit MSACCESS. That's not true! There is a workaround. I came across that we can use these APIs if the return value in 32 bitness is the same size as LongLong type (8 bytes), for example; Currency or UDT...

Hello. I've been using V-Tools for MSAccess by Skrol 29 for many years. For my developing tasks, it's a "must" tool in MSAccess. Thanks Scrol 29. Recently, I upgraded to Office 365, and installed V-Tools with no issues and it worked properly for some days, but every now and then it dissapears...

I'm 57 and I've been working with Access since Access 2 and I still love it. I live in Girona(Spain) .