Search results

That should not be the question. The question should be what it should do. See and follow Command Query Separation: So both, functions and subs, are procedures. Both can have parameters (which could be used for quasi return values if declared ByRef), but only functions can have a return value...

Thanks for testing @Josef P. and @arnelgp . So yes, finally the Object Browser 'documentation' is wrong. The online documentation doesn't mention a default value of the 'compare' parameter at all.

I have accidentally noticed a behavior of the String.Replace function that does not match the documentation from the Object Browser. According to the Object Browser, the default value of the optional parameter 'Compare' is 'vbBinaryCompare': However, the actual behavior is not like this...

It should be noted that the Microsoft Access team, which is well-disposed towards our Access developer community, unfortunately has nothing directly to do with the VBA/VBE team. Therefore, my hopes for an extended VBA (see above) are unfortunately close to zero, too.

In terms of Access, I would like to have for example controls like 'FlowLayoutPanel' or 'TableLayoutPanel' in Forms to better organize controls. In VBA I miss e.g.: - Reflection - Programmatic access to the call stack - Constructor/Parameter overloading - Generic types - Nullable types -...

So just to be clear and avoid misunderstandings: You use images and not Unicode entities, is that correct?

@NelsonHawk : Could you post a database with this (empty) form?

Hi @accessmoraes, what kind of images do you use in your menus (the images on the left side of the description, separated by a pipe)? Are this Unicode signs?

Is it possible, that you have an orphaned/invisible Microsoft Access instance running on any client when this occasionally locking of a record happens? Take a look in the processes list of the Windows Task Manager and search for 'msaccess.exe'.

🤷‍♂️;)

Or disable, then enable, then hide the control (just in case your intention is to have it enabled when you make it visible later on).

Just for information: At least with Microsoft Access 2016 (just tested again) you can disable the command button directly without having to move the focus first.

@John Lee : Do you reference an accdb file in your accdb to be saved as accde? This would also prevent it.

A small addition on my part: And it is best to use a different password for each site/service. A password manager is ideal for managing passwords.

So if you would deploy an accde instead if an accdb as the frontend you could make it more secure as it would not be possible to edit any code or forms/reports in design view.

Is the frontend a accdb, or a accde?

Try this sql statement instead of yours to output the sql and check if the values added into maybe contain incompatible content like comma for example: Debug.Print "Insert INTO tbl_InvoiceItems" & _ "(InvID,ItmID,ItmSID,ItmSaleBalance,InvItmQty,InvItmPrice) VALUES " & _ "(" & me.Parent!InvID &...

Unfortunately, this is the case, even if, for example, an ACCDB is referenced in the current project. There is nothing you can do about it.

This is not quite correct, the type of 'matches' is 'IMatchCollection2'. It can be iterated with VBA like a Collection, but if an object of type 'Collection' is required for further/superordinate processing, it must be created explicitly.

I also tested a bit in the Immediate Window. These work fine: Debug.Print -16924727597.1152 ^ 2.28767123287671 Debug.Print -16924727597.1152# ^ 2.28767123287671# These not: Debug.Print CDbl(-16924727597.1152) ^ CDbl(2.28767123287671) Debug.Print (-16924727597.1152#) ^...