Search results

Hi everyone. I need help with a problem I'm having with Word. I have a table with the field names I need to create, and I want to do it using VBA, so that it goes through the left column and generates the field as it appears in the right column, like this: {MERGEFIELD Example1}. I've only...

Hi guys. I need your help. I want to protect/unprotect a VBA project using SendKeys based on the value of a specific cell in a specific sheet. I created this macro, in which I set the sheet where it will check whether or not to protect the VBA project and the password, and then use SendKeys...

Hi guys. I'm having a problem with a bat file that I can't seem to solve, and it's driving me crazy. I want to count the files in a folder and its subfolders, but without including a file type or the name of a specific file. This is where the problem lies: no matter how many filters I use, it...

Hello. I've been thinking about it for a while but I can't find the error. I have this code to create a table, where I want to put the unicode compression in the "Name" field, but I get a syntax error. I'm sure it's a silly thing, but I can't find any information on the Internet and the...

Hi guys. I'm trying to make a loop that goes through the records in a table, but the program doesn't respond when I run it. This is the code: Private Sub CalcularImporte() Dim rstTable As DAO.Recordset Dim rst As DAO.Recordset Dim strSql As String Dim ManoDeObra As Double Dim Vehiculo As...

Hi, guys. I want to create a table by VBA in a accde file, but I get an error. I attach two files. First one is accdb file. It works fine. But if I convert to accde, I get an error. I don't know what's wrong. Can somebody help me? Thanks.

Hello. I am trying to close a form from the Form_Load event when a boolean variable is True. If I put this: Private Sub Form_Load() If Cerrar = True Then DoCmd.Close End sub I get the following error: 2585 This action cannot be executed while a form or report event is being...

Hello, people. I have this code to export a form to Excel: Private Sub CmdExportarExcel_Click() Dim xlApp As Excel.Application Dim xlBook As Excel.Workbook Dim xlSheet As Excel.Worksheet Dim strSql As String Dim rsDatos As DAO.Recordset 'Abrimos Excel Set xlApp = New Excel.Application...

Hi guys. I am attaching an example database on which I am going to explain what I want to achieve. I have the Season field, to which I have an input mask: 0000/0000;0;_ The user must enter the season in this way: 2024/2025, and if he enters it in another way, he must give an error, hence he...

Hello. I need your help. I need to create a report with multiple subreports, but have the source of these subreports dynamically set to a value. Let's see if I can explain it, because with what I've told you so far I'm sure your brain has exploded. The report I need to create is a balance...

Hello people. Let's see if you can help me. I attach a database where I have put the code DoCmd.GoToRecord , , acLast in the Form_Load event. When I enter the form, it appears like this: That is, it shows me only one record, because it is the last one. Now, here I pose two questions...

Hi, guys. I need your help. I've been using Outlook for several months, but I can't get it to work as I would like. I wanted to ask for help to try to achieve this. The fact is that I have created a series of rules to move emails to folders. What is the problem? I no longer get this message in...

I have this database that I share with you a form (FPautas) with a list box, called LstPautas, in which I want to put two buttons: one to select all the items, and another to delete all the selected items. Could anyone tell me how to do it? Thank you.

Hello people. I wanted to know if it is possible to undo changes when you change fields. If you are in a field, you change part or all of the content, but then cancel, what you just entered is not saved. Now, this does not happen if, by doing the same thing, you then change fields. Is it...

Hello. I have the following custom ribbon: <customUI xmlns="http://schemas.microsoft.com/office/2009/07/customui"> <ribbon startFromScratch="true"> <tabs> <tab id="T001" label="Salir"> <group id="T001G001" label="Salir"> <button id="Salir" label="Salir" imageMso="MasterViewClose" size="large"...

Hello. I tell you my problem. I want, when clicking on the form button that you see in the image I attached, to check if the active field is the dropdown also marked in said image and obtain the value. What is the objective of this? I want to add a code in that button to update the pricing...

Hello. I have prepared an example of what I want to achieve. I have a long text field with rich formatting that, after updating, saves in some fields the color of the text and the background of the text that the user has given it. Well, I want to apply that color to a string that unites the...

Hello people. I ask for your help. I am creating a database to make clinical records for patients (dogs and cats) with behavioral problems. I am going to try to explain with examples and everything as much as I can and can imagine right now. So, if something is not clear, or if I overlook any...

Hello. I would like to detect using VBA when I change a control: From subform to main form. From main form to subform. I have tried events from one and the other and I can't find the key. I have made this small example, to which I ask you not to try to understand the logic of the name of...

REFORMULATED QUESTION: see my post below. I put it in a simpler way and with a very simple database.