Search results

  1. 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...
  2. 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...
  3. 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...
  4. 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.
  5. 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...
  6. 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"...
  7. 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...
  8. 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...
  9. 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...
  10. 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...
  11. 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.
  12. zelarra821

    Change ribbon from subform

    Hello. I have a form with a subform. I am trying to achieve, through a class module, that the ribbon of the main form changes when entering a textbox of the subform. I have tried Form.Parent.RibbonName = "RichText", but it gives me an error, and I don't know how else I can put it. Thank...
  13. zelarra821

    Solved Delete all records from all tables in a database

    Hello. I found a code to delete all records from a database: Public Function empty_tables() As Boolean '====================================================== ' Author: wongm003 ' Use to empty all visible tables in current database. ' ' Note: if you do not want to prompt the user for each '...
  14. zelarra821

    Solved Set the cursor position in a textbox using VBA

    I am creating a class module to manage mouse movements in a textbox and the ribbons that should appear in rich texts. I have some questions: 1. How can I use VBA to set the option to place the cursor at the end of the text that can be set in the Access options (Client Settings)? This way, I...
  15. zelarra821

    Solved Help with a YouTube video

    Hello people. I wanted to ask you for help. I'm looking for a video of a sketch from a program that was broadcast in Spain at the end of the 90s. I found it on YouTube, but it's restricted by copyright, something I don't understand why because there are more videos of sketches from that...
  16. zelarra821

    Solved Subtract hours

    Good afternoon. I have a table with start and end times for work, and, in between, stops for breakfast and lunch. I have created a dropdown with the type of time record: entry, breakfast start, breakfast end, lunch start, lunch end, and output. Now what I have to do is subtract: breakfast...
  17. zelarra821

    Solved Create a calendar to record work inputs and outputs

    Good night. I have searched this forum for examples of calendars, and I have found this attached majP that more or less adapts to what I am looking for. What it lacks is that it can add the hours that I record each day when I enter and leave work, in such a way that it later allows me to...
  18. zelarra821

    Solved Find approximate date

    Hello. I have a table where I keep the days on which a given event occurred. What I want is to search for a specific date (I have done this), and, if it does not coincide with any of the saved dates, search for the closest previous one. For example: 4-jan-22 6-jan-22 9-jan-22 13-jan-22 If I...
  19. zelarra821

    Solved Run a class module automatically on every form

    Buenas tardes. It seems to me that what I am going to ask is a utopia and, therefore, the solution is through the simple path. The thing is, I have developed a class module to disable all hotkeys. I want this to be executed automatically in each form without having to add lines of code to each...
  20. zelarra821

    Solved Set the properties of a COM port

    Good morning. Let's see if you can help me. I need to set the properties of a COM port to 9600-8-N-1. I found this link where it talks about how to do it, but doesn't give any concrete example: https://learn.microsoft.com/en-us/windows-server/administration/windows-commands/mode I have tried...
Top Bottom