• ** There has been a recent site upgrade. Please clear your browser cache to avoid issues. **
  • New forum feature - post voting and best solution

    Check out this thread for the details: https://www.access-programmers.co.uk/forums/threads/new-forum-feature-post-voting-and-best-answer.314134/

    This new feature looks great to me! :)

  • We now have 3 forum themes

    Go for the default (light) theme, Shades of Grey or Shades of Blue. I just added the Blue one.

    The thread about it is here: https://www.access-programmers.co.uk/forums/threads/new-forum-theme-shades-of-blue.314136/

Recent content by zelarra821

  1. zelarra821

    Solved Delete previous versions of a backup

    Yeah, sure, obviously it can be a problem if both of them are corrupt. My brother was about to lose a month of records in the POS that he has made in Access due to an error that he gave, and that has been the reason for doing this. What I don't know is if, changing that 2 to 5, for example...
  2. zelarra821

    Solved Delete previous versions of a backup

    Select Case DCount("Nombre", "T00CopiasDeSeguridad") Case 2 Kill DLookup("RutaCopiaDeSeguridadDonde", "T00Configuracion") & "\" & DMin("Nombre", "T00CopiasDeSeguridad", "Fecha=#" & DMin("Fecha", "T00CopiasDeSeguridad") & "#")...
  3. zelarra821

    Solved Delete previous versions of a backup

    I have created a table, and through the code that I create the backup by, I add the date, time and name of the backup created. How can I leave the last two in that table and delete the rest? Thank you so much for the idea! Private Sub Form_Close() CurrentDb.Execute "UPDATE...
  4. zelarra821

    Solved Delete previous versions of a backup

    Thank you very much, but I have managed to add the backup copies that are created in a table.
  5. zelarra821

    Solved Delete previous versions of a backup

    The name is, eg, 2020 10 21 Tienda BD.
  6. zelarra821

    Solved Delete previous versions of a backup

    Hi. I have a code that I got from the Internet that copies the database to me in another location with the date included in the name, to make a backup copy. I've been looking for a way to delete the "old versions". I have seen that it can be erased with VBA's Kill method. Now, I don't know if...
  7. zelarra821

    Solved Syntax error in a function for a query

    That was. Public Function Diferencia(CampoARestar As String, Id As Byte) As Single Dim regAnterior As Variant Dim StrSQL As String StrSQL = "[Id]" Debug.Print StrSQL If IsNull(CampoARestar) Then Exit Function regAnterior = Nz(DMax(Replace("Peso", ",", "."), "TPeso"...
  8. zelarra821

    Solved Syntax error in a function for a query

    Public Function Diferencia(CampoARestar As String) As Variant Dim regAnterior As Variant Dim StrSQL As String StrSQL = "Id<" & Id Debug.Print StrSQL If IsNull(CampoARestar) Then Exit Function regAnterior = Nz(DMax(Replace("Peso", ",", "."), "TPeso", "Id< " & Id), 0)...
  9. zelarra821

    Solved Syntax error in a function for a query

    Let's see, I'm trying to adapt a function that I had made for a form to find the value of the previous record in a query, and it gives me the syntax error that an operator is missing in "Id <" & Id: Public Function Diferencia(CampoARestar As String) As Variant Dim regAnterior As Variant...
  10. zelarra821

    Solved Input mask for a field in Percentage format

    Ok, thanks a lot.
  11. zelarra821

    Solved Input mask for a field in Percentage format

    Hi. "And the..." what? I don't understand. Thanks!
  12. zelarra821

    Solved Input mask for a field in Percentage format

    Good Morning. I need to know how to put an input mask to a field that I have with Numeric data type, Double field size, and Percentage format. I have tried to put 99.00 (in Spain we use the comma for decimals, and the point for thousands), but I divide the values of the field by one hundred in...
  13. zelarra821

    Solved Subform that hides the entered record

    I've already managed to solve it. I'll explain it around here in case someone else serves you. The problem was indeed the combo. I had him as an independent, and he gave such strange behavior. I have linked it to a field of the subform, and fixed. On the other hand, the problem that I did not...
  14. zelarra821

    Solved Subform that hides the entered record

    The problem with not displaying more than one record in the subform is because of the separate dropdown. When I map to one of the fields in the subtable, it shows me a second record as I start to enter values. It only remains for me to fix the problem that it saves the main form.
  15. zelarra821

    Solved Subform that hides the entered record

    I have found the error, but I do not know how to solve it. See if I can explain it. The main form and the subform are related by IDTPV. This field is auto-numeric in the main table, and long integer in the subtable. Since the first three fields in the main form are added as default values...
Top Bottom