Search results

  1. zelarra821

    Solved Between operator

    Good Morning. I have a problem searching in a date range. To do this, I use this function that @MajP created for me: Public Function GetBetweenFilter(Ctrl1 As Access.Control, ctrl2 As Access.Control, TheFieldName As String, Optional TheSql_Datatype As SQL_DataType = sdt_date) As String Dim...
  2. zelarra821

    Solved Copy format in CommandBar

    I have the following procedure to create a custom context menu: Sub MenuContextual() On Error Resume Next Dim myBar As CommandBar CommandBars("ShortcutMenu").Delete Set myBar = CommandBars _ .Add(Name:="ShortcutMenu", Position:=msoBarPopup, Temporary:=True) With...
  3. zelarra821

    Solved Update a subform

    Good Morning. I am trying to update a subform by changing a value in a field of the main form. What I do is, after updating the main form field, execute an UPDATE of the table in VBA, and I want it to update the summation. I leave you the database. I have hidden everything but the two forms...
  4. zelarra821

    Solved Clear properties of files from a folder

    Good afternoon. I am looking for a procedure that clears the properties of files from a folder. Googling, the most I've found is this, that what it does is list the properties, but I don't know how I can delete them. Sub ExtendedFileDetails(FolderName As String, FileName As String) Dim...
  5. zelarra821

    Solved Get the last value from a query using VBA

    Good afternoon. I need to get the last value as of today in a this query: I try like this and it doesn't work: Nz(DLookup("Registro", "CProximasCitas", "Fecha>=#" & Format(Date, "mm-dd-yyyy") & "#"), 0) It returns the value of today, that is, "Pesada", and it would have to return "Médico...
  6. zelarra821

    Solved Check if the backend exists in a split database

    Goodnight. As I say in the matter, I have a divided database and I want to produce a procedure that tells me if the backend exists, and if it does not exist, to open a window to choose the path where it is located. I have this code from @MajP, but I do not know how to remove the code that I do...
  7. zelarra821

    Solved Take repeating records

    Hello. Let's see if someone can help me. @MajP made me an example to, for example, save multiple authors in case a book had more than one. I have tried to contact him, but there is no way, I suppose he will be busy. It consists of having a union table (TLibrosAutores), where the Id of the...
  8. zelarra821

    Solved Print a landscape form

    Buenas tardes. I am trying to print a form, and I have succeeded in this way: Private Sub CdmImprimir_Click() On Error GoTo err_lbl Dim Titulo As String Dim Ruta As String Titulo = Screen.ActiveForm.Caption Ruta = BuscaCarpeta(Me) If Ruta = "" Then...
  9. zelarra821

    Solved Get the last entered value

    Goodnight. Well, as I say in the subject, I need to get the last value from the right column (cintura). As you can see, it does not correspond to the last date entered. Until now I did it like this: DLookup("Cintura", "T04Peso", "Fecha=#" & DMax("Fecha", "T04Peso") & "#") But it doesn't show...
  10. zelarra821

    Solved View a PDF in a form

    Hello. I am looking for a way to view a PDF in a form. I've seen what can be done with images and web pages in this forum post: https://www.access-programmers.co.uk/forums/threads/accdb-webbrowser-and-acropdf-pdf-viewer.313660/# post-1745918 Does anyone know if it is possible? Does anyone have...
  11. zelarra821

    Solved Last selected item in a list box

    Hi. I have a multi-choice list, and I want to get the value of the last selected item. That is, I have the list box on the left (the one on the right only shows selected items). The name and description appear in that list box. Well, what I want to achieve is that, every time I select an...
  12. zelarra821

    Solved FollowHyperlink with a phone

    Well, I want to know if I can make a clickable phone, in such a way that the user on the phone, when clicking, puts the number in the phonebook to call directly, as can be done with php. Thanks!
  13. zelarra821

    Get the different values between two tables

    Buenas tardes. I have two tables, in which I save the names of files that I have in a folder on my computer. In one of the tables (Table1), I save the name that I get when traversing the folders using VBA. And in the other table (Table2), I keep a manual record because each file I record it...
  14. zelarra821

    Error 2445 when formatting a text box

    Good Morning. I have a problem that I think is syntax. I'm getting an error 2455, which says you have specified an expression that contains an invalid reference to the Form / Report property. The line where it gives the error is this: Forms! [FPresupuestos]...
  15. zelarra821

    How to send images by whatsapp with VBA

    Hi. I need to send Whatsapps with images. Searching the Internet, what I have found uses the same system: they insert the image in Excel, copy it to the clipboard, and then paste it in WhatsApp. However, trying manually to copy images in WhatsApp, this system no longer works, because it does not...
  16. zelarra821

    Solved Position the cursor at the end of the textbox

    Good afternoon. I'm trying to get my cursor at the end in a textbox after updating it, but I can't. I have recorded a short video that supports my words and you can see the behavior. Video This is the code I have after updating: Private Sub Leido1_AfterUpdate() ' If IsNull(Me.Leido1)...
  17. zelarra821

    Solved Move fields after updating a form

    Good afternoon. I have a form where I show the file of a book. For each book, there are several states that it can be in. To go from one state to another, I have a button, which what it does is update the source table of the form through an UPDATE. Once the source table is updated, I update the...
  18. zelarra821

    Solved Multiple search engine with dropdowns

    Good afternoon. I am trying to make a search engine in a form, but it took several days, and I can't find a possible solution. I have this: https://www.dropbox.com/s/jmc4yg5m8qs2jwt/ScreenShot001.jpg?dl=0 I'm going to focus on dropdowns, not checkboxes, which I also use to filter. I think...
  19. zelarra821

    Solved Input mask for hours

    Good afternoon. I'm looking at the Access help for how to put an input mask to enter times that allows me to enter, for example, 0: 1: 34 without having to write a zero in front of the one, that is, like this: 0:01:34. Currently, the one I use is this: 9:00:00;0; _, and I don't know how I have...
  20. zelarra821

    Solved I can't clear a filter from a form

    Good afternoon. I have a continuous form that I filter through a few dropdowns (SrchMultimedia, SrchCategoria, SrchSubcategoria). The filter is applied through the source query of the form. I attach images for you to see (como = like): There you can see SrchMultimedia, but it is the same...
Top Bottom