Search results

Hi @Josef P. Thank you for your testing program. For your information, we can replace the subroutine in the subform with: Public Sub SetData(ByVal SourceDb As String) Me.RecordSource = "SELECT * FROM " & AddInTableName & "IN '" & SourceDb & "'" End Sub Another question : What should I do...

See my comment from November 3, 2023.

I just used ADO's OpenSchema method to determine the connections to the add-in. I added this code in a test add-on. Here is the code: Private Sub cmdTest_Click() Const JET_SCHEMA_USERROSTER As String = "{947bb102-5d43-11d1-bdbf-00c04fb92675}" Dim cnc As New ADODB.Connection Dim rst As...

When opening the add-in, I create the tables in the calling application and define the links to these tables in my add-in. This works perfectly with a single calling application. For a second calling application, I perform the same task. The problem is that the table links to the second calling...

Hi @Josef P. If I have 2 calls to the add-in by the same user, I will have 2 indications in the laccdb file instead of just one. The problem is also the case of improper closing or the laccdb file is not deleted. According to my tests, if the laccdb file is not deleted, the user data is...

In VBA, is it possible in a procedure of a complement (accde) to check if this complement is already opened by another calling database?

Good morning, As a problem never comes alone, here is a problem with the DoCmd.TransferDatabase Method with which I am trying to export tables from the add-in to the database of the calling application. During testing, using a button on a form of the add-in, I execute the following line of...

Thank you very much for your suggestions. Now I just have to make these changes.

When I initially created my add-in, I didn't think that the add-in's internal databases were shared. To solve my problem, if I understood correctly, I could for example export my empty worktables from the add-in to the database of the calling application and create a link. I will work with...

Hi, I tried to re-specify the use of the complement in my comment of September 26. The add-in is a custom ribbon creation development process. It creates, loads and modifies XML data from the UsysRibbon table contained in a database in edit mode. In edit mode, the add-in can be used in...

Hi, Perhaps the idea of adding a field representing the open application to tables in the add-in is the right solution. The only problem to solve is this: Currently, the contents of some tables are cleared when the add-in is opened. If I use the new solution, the deletion should be done when...

Hi @Pat Hartman, Thank you for your reply. This is what I also see. Wouldn't the solution be to prevent a second opening of the complement?

Hi, The add-in is a custom ribbon creation program. It creates, loads and modifies XML data from the UsysRibbon table contained in a database in edit mode. The data in XML format from the UsysRibbon table is decoded and distributed into tables internal to the complement (Attributes, Procedures...

Hi there. I created an add-in in accde format. This add-in uses databases internally. The contents of internal databases are editable while using the add-in. I thought that when the add-in was opened several times at the same time, each time we had an independent.accde file with its own...

Hello I took your database for a test. Hiding the ribbon is correct in edit mode but not when opening in live mode. After several tries and checks, I couldn't find the problem. So I recreated a new database with your forms. I simply used the 'DoCmd.ShowToolbar "Ribbon", acToolbarNo' method and...

Your explanations regarding the appearance of scrollbars are correct. The empty form is a form created for testing. All other forms with the same configuration have the same problem. I rather believe it is an Access problem. If the form navigation buttons are visible you do not have this...

Hi, In a form, if the properties "NavigationButtons" is false and "ScrollBars" is Horizontal Only or Both, we see a horizontal banner under the form after using the Maximize button and decreasing the size of the window until the bar horizontal scroll button appears. To reproduce the issue...

Check the site from time to time as another update will become available.

The 32-bit version is now available thanks to Colin. This version has not yet been tested.

It's not my supplement that's the problem. I think it's a problem with Access. This has happened to me very rarely with other supplements. I think I was experiencing the problem when the add-in was used with a database and at the same time the .accde file was opened with Access in design mode. I...