Search results

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)...

You can also link the txt file as a linked table and then execute an insert query.

In the original database example you uploaded, with no changes, I've also noticed that if you press the space key after typing the Cod.Cli.: 5 it works properly and the client 5 is selected using MS Access 2010.

It seems that's a problem with some old MS ACCESS versions. I've noticed that the problem is caused by the -1 value there are in the table. If you change it for a positive number, then it works with autoexpand=true.

The example you have attached works ok for me in MS Access 365, but not in MS Access 2010. Using Access 2010 it happens the issue hou have explained. The workaround for old Access versions is to change the autoexpand property in the cmbAnagraficaCodice combobox to False

I use the following workaround: Before setting the focus to the current control, set the focus to another control, it doesn't matter which one. Example: Private Sub AuthDateEntered_LostFocus() 'Private Sub AuthDateEntered_BeforeUpdate(Cancel As Integer) If AuthDateEntered < ReferDate Then...

I have done it several times and to avoid problems I follow these steps: - 1) Rename the old table with the new name - 2) Create a query using the the old table name with all the fields of the new table - 3) Change old table name with the new table name in all querys (Optional in some cases)...

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.

Yes, you are right. I found another examples that uses the same approach to call The EXCEL Library, but these examples are useless. What superprised me whas how do they do de call to the libraries using the API : "DispCallFunc" Thanks, very interesting article I totally agree!

Only for fun and after some tests, I realized that I could create a query with 50 UNION tables, when I tested the process with 51 an "Expression to complex" error raised.

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...

You are welcome! It has been an interesting challenge to convert it and I'm happy to have solved your problem. I don't think we see 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...

My point is, if the procedure fits on one screen on the top, if not, then before the first use.

No, Richard never uses spaces or puctuation/special characters at all.

Not related with the error but the PtrSafe in the #Else should be deleted.

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

Cascading combo boxes in a continuous can be difficult to do. See this discussion https://www.access-programmers.co.u...boxes-in-datasheet-or-continuous-form.275155/ Semi Unique Combox Record Source on Continuous Form

This screenshot shows the GetTickCount64() behavior of this API after 39 days on a computer turned on (32 bit Access). As you can see the equivalent declarations: Private Declare PtrSafe Function GetTickCount64 Lib "kernel32" Alias "GetTickCount64" () As LongPtr Private Declare PtrSafe Function...

This database has been tested with 32 bit MS ACCESS 2010 and works properly. LongLong type is not allowed in any 32 bit MS ACCESS version