Search results

  1. zelarra821

    Solved Create a calendar to record work inputs and outputs

    @MajP , where can I download this calendar? I can't find the post you shared and I can't find it on the Internet either. I don't care if I have to buy it, but I'm interested. They do have an application to record time, but it does not allow you to plan your day to find out if you are meeting...
  2. zelarra821

    Solved Create a calendar to record work inputs and outputs

    I explain. I am a civil servant, and the Administration and I have a working day of 37.5 hours per week, but the calculation is made monthly by the Administration. Therefore, I have to, as you say, time the hours I dedicate to work, which an internal application tells me when I clock in and out...
  3. 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...
  4. zelarra821

    Solved Find approximate date

    Thanks, @arnelgp. It works for me.
  5. zelarra821

    Solved Find approximate date

    Ok, thanks. The code is based on an example that I got in Microsoft Help. I have to change recordset to recordset lone and put your code in the criteria.
  6. 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...
  7. zelarra821

    Solved Run a class module automatically on every form

    I appreciate your effort, @MajP . I think I'm going to use the simple form. Like @The_Doc_Man says, it's better to create a demo form with basic code. That's what I'm doing now: a demo database with basic features that I can use to create a database and save time, not doing from scratch.
  8. zelarra821

    Solved Run a class module automatically on every form

    That's amazing. Do you think it's worth to do all that only for not to write a couple of lines in each form?
  9. zelarra821

    Solved Run a class module automatically on every form

    I will wait, don't worry. Thanks
  10. zelarra821

    Solved Run a class module automatically on every form

    I'm looking at the page and I can't find how to do what you are doing. Could you show an example that I can apply?
  11. 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...
  12. zelarra821

    Solved Set the properties of a COM port

    The solution: Dim PID As Variant PID = Shell("cmd /k ""Mode COM1: BAUD=96 PARITY=n DATA=8 STOP=1""", vbNormalFocus)
  13. zelarra821

    Solved Set the properties of a COM port

    I can't probe it now because my laptop doesn't have COM ports. I have to do it tomorrow when I go to the shop.
  14. zelarra821

    Solved Set the properties of a COM port

    Ok, and all of this on a shell function, like I put above, doesn't it?
  15. zelarra821

    Solved Set the properties of a COM port

    You mean I have to put that Shell("Mode com1: baud=<96> parity=<n> data=<8> stop=<1>", 0)
  16. zelarra821

    Solved Set the properties of a COM port

    Ok, thanks. I will prove it
  17. zelarra821

    Solved Set the properties of a COM port

    I come from that post. I asked the developer about my case, and he recommended me another simpler module. However, in this one I cannot set the parameters of the scale, and I was given the link that you see above to configure these parameters, but it gives me that error that I have indicated and...
  18. zelarra821

    Solved Set the properties of a COM port

    Does anyone know how to fix the error?
  19. 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...
  20. zelarra821

    Solved Accede file

    Everything is more or less clear to me. Thank you very much guys for the information.
Back
Top Bottom