Search results

  1. zelarra821

    Solved Create several MergeField by VBA

    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...
  2. zelarra821

    Solved Protect VBA Project Programmatically with SendKeys

    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...
  3. zelarra821

    Solved Help with a bat file

    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...
  4. zelarra821

    Solved Unicode compression when creating a table

    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...
  5. zelarra821

    Solved Loop through records in a table that gives an error

    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...
  6. zelarra821

    Solved Create table by VBA in accde

    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.
  7. zelarra821

    Solved Closing a form from the Form_Load event

    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...
  8. zelarra821

    Solved Export to Excel and leave the workbook open

    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...
  9. zelarra821

    Solved Error with Input Mask

    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...
  10. zelarra821

    Change the origin of multiple subreports in the same report

    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...
  11. zelarra821

    Display a specified number of records in a continuous form

    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...
  12. zelarra821

    Filter mail in Outlook

    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...
  13. zelarra821

    Button to Select All and Delete selected items in a List Box

    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.
  14. zelarra821

    Undo changes

    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...
  15. zelarra821

    Add a button to correct spelling to a custom ribbon

    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"...
  16. zelarra821

    Solved Detect the active field and its value

    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...
  17. zelarra821

    Solved How do I convert color from forecolor to html?

    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...
  18. zelarra821

    Solved Form with multiple list boxes

    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...
  19. zelarra821

    Solved Detect the change of a control from the main form to the subform, and vice versa

    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...
  20. zelarra821

    Solved Find the first date backwards

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