Search results

Thank you!

Hello everyone, I have created a query in the sample database that I would like to look like the table in the picture. Taking index 135 in Event A as an example, in the query there are two lines for this combination, one with a cross in type "Welcome" and one in type "Wedding". Is there any...

Thank you so much!! All clear

What I want to display is some of the default views but only in a specific file, but I don't know how to do it. I thought that maybe it was easier to start from scratch, so I started with this code but I get plenty of error messages that I don't know how to solve: <customUI...

Hello, I am getting started with Ribbon XML because I would like to create a custom one for one of the frontend files of my Access 2016 app. I would like to show only certain commands (so it really isn't creating the ribbon from scratch), but I can't use the default hide/show options because...

Hello all, it was finally due to an issue with the trusted files of the network... It was just a matter of permits. Thank you for all the tips, they have helped to arrive to a solution :)

So if all of this were equal in both computers, the "VBA parts" of the file should run normally?

MSA2016 Could you explain this a bit more detailed? Do you mean like this? How do I call this afterwards from my form? I am thinking of a code that in fact you helped me with it in this question about VBA. In this case, there is a button in a form that executes the code to export to excel and...

Unfortunately I cannot post my database but I am posting a super simple one... I hope it is enough. The code on the "On open" event is exactly the same. The error message pops up when trying to use the right-click. Thanks

Hi again, I have tried saving the file in a different computer in folder C:/Temp but it is still giving the same error: it can't find the objects that I defined in VBA in different forms/reports... the references are set just as they appeared in my computer so I don't know what to do... These...

Sorry about that, it says: 'App_Name' cannot find the object 'MenuName.' If 'MenuName' is a new macro or macro group, make sure you have saved it and that you have typed its name correctly. I will try checking that. Maybe my question is dumb but this is my first proper Access app... if it...

Hello everyone, I designed a database with plenty of forms and reports and when it was finished, I decided to split it. At first I did all of this in my computer but then I decided to move both the backend file (that contains only tables) and the frontend to a shared folder in the network. I...

I have finally managed to do all. Thank you all for your help. I attach the code in case it is of any use to someone. Thanks again :) :) :) Private Sub ExportOverviewToExcel_Click() 'Variables to create Excel App Dim xlApp As Excel.Application Dim xlWorkbook As Excel.Workbook Dim xlSheet...

The thing is that as I want to format the output Excel document and assign different queries in different parts of the sheet I do need to use the code. I have built the queries that will be exported (with the query wizard and then query design, no VBA) with a where clause that selects the...

To close up this thread, I would really appreciate if someone could explain how to select only the information of each query related to the Event of the form. Basically, how to adapt this "selection" of the current EventID to this way of exporting. I have read it has to be done using...

Apologies, I misread it! It is working now

I have copied the code and selected the reference to both Microsoft Office 16.0 Access database engine Object Library and Microsoft Office 16.0 Object Library, but I am back to compile error "User-defined type not defined" on line "Dim xlApp As Excel.Application" :(

I had added the reference but as it wasn't working I have tried to do it with Objects instead of Excel.xxx and now I get error "Object variable or With block variable not set". I have tried commenting the code and uncommenting line by line to see where the error is and it seems to be here, but...

Hello again, I have tried to do what you suggest in these posts but I am getting an compile error (User-defined type not defined). It highlights the "xlApp As Excel.Application" declaration of the code. The reference to the MS Office 16 is ticked, so I am guessing it's not related to this...

So let's say I define the menu in Load event of form A and then select it from the menubar in Form B, if I have to add other events to form A's VBA, it will not affect form B? Cheers