Search results

  1. A

    Restrict the number of records entered in form

    Yes dear, follow the topic from #4
  2. A

    Restrict the number of records entered in form

    Yes, my dearPat Hartman. What I understood from you is that I am using the code in the BeforeUpdate event.
  3. A

    Restrict the number of records entered in form

  4. A

    Restrict the number of records entered in form

    When I use the code in the BeforeUpdate event I get an error on the line to add a new record. But if I use the code in the BeforeInsert event I don't get an error. I get a message that I can't add a new record for today.
  5. A

    Getusername function

    Gasman I don't know why I love you so much. You are amazing 🌻 🌻
  6. A

    Restrict the number of records entered in form

    I don't know why I love you so much. You are amazing Gasman 🌻 (y)(y)
  7. A

    Getusername function

    It just converts the numbers and letters in the inputbox into stars.
  8. A

    Getusername function

    Code written by Daniel Klann March 2003 64-bit modifications developed by Alexey Tseluiko and Ryan Wells (wellsr.com) February 2019
  9. A

    Restrict the number of records entered in form

    "s_date = Date() AND NOT ( ISNULL( Me.ID ) )" (y)
  10. A

    Getusername function

    If you want to lock certain buttons inside the form, you can use (InputBoxDK) which is enough for that. I use it in most programs. Private Sub Option8_BeforeUpdate(Cancel As Integer) If Me.Option8 Then Me.Button name.Enabled = False ElseIf InputBoxDK("Enter the password to unblock the print...
  11. A

    Restrict the number of records entered in form

    But there is another problem. It increases the number of records from 20 to 21. Why. Should I make the number of records minus one, meaning 20 is 19 in the code? Can I add the number of allowed records to the message?
  12. A

    Restrict the number of records entered in form

    Thank you very much. I found the error, the error is when I add a new record. Of course Access does not generate the ID number until after entering the first information in this record. So it tells me an error. Because I added the statement ( AND ID). Dim CountOfTodaysEntries As Integer...
  13. A

    Restrict the number of records entered in form

  14. A

    Restrict the number of records entered in form

    Good evening everyone I am trying to use this code to restrict the user to enter only 20 records per day. But I get an error when executing. Private Sub Form_BeforeInsert(Cancel As Integer) Dim CountOfTodaysEntries As Integer CountOfTodaysEntries = DCount("ID", "tblMaid", "s_date = Date() AND...
  15. A

    Solved Hide pull down menu of navigation pane at run time

    As theDBguy told you
  16. A

    Problem opening form- program

    Did you create this database? Or did someone else create it? It may be protected by the motherboard or BIOS number. If you can, attach a copy of it here.
  17. A

    Filtering on Date fields problem

    https://support.microsoft.com/en-us/office/apply-a-filter-to-view-select-records-in-an-access-database-2a493ded-e544-4144-9103-b9b1d1865147#formfilter If you want the time with the date and do not want to dispense with the time, there is a feature to filter the date with the time for a specific...
  18. A

    How to Add feature to query Append ?

    Private Sub Form_Error(DataErr As Integer, Response As Integer) Select Case DataErr Case 3022 MsgBox "You added a record which duplicates an existing value." Response = acDataErrContinue Case Else Response = acDataErrDisplay End Select End Sub...
  19. A

    Query best practice or solution - question

    You can create a query based on your table. Add the course date. Then create a report based on this query. Create a form with a start date and end date field through which the report for each trainee appears from the beginning of the year until today. SELECT tblWorkshop.ID...
  20. A

    How to Add feature to query Append ?

    No, I did not add it.
Back
Top Bottom