Search results

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

You could also search in the VBEs 'Object 'Browser' for 'acNormal'. There you can see that it belongs to the enumeration 'AcFormView', which makes clear that it's not to be used with the 'BackStyle' property.

@Imb : I would also be interested to see in a sample database how you replace two or more cascading combo boxes in the UI with whatever (you said you don't use any). I assume you are not replacing them with listboxes.

So your real-world controls are virtual controls whose properties and behavior you define in tables and implement in Access controls when loading a form, for example? Or have I misunderstood you? Can you explain your idea in a little more detail?