Search results

  1. A

    Msgbox this Number already exists

    Dear friend (theDBguy) I know I'm putting the expression in the BeforeUpdate event of StatFig but can you correct the formula for me please. If DCount("*"; " StatFig = '" & Me.txtStatFig & "'") > 0 then
  2. A

    Msgbox this Number already exists

    Thank you very much, my dear friend (The_Doc_Man) The number cannot be written by a user or by the program itself. This number is a military number that comes from third parties assigning this number to the registry. I am not a specialist or program. It is a number with a specific symbol.
  3. A

    Msgbox this Number already exists

    Hello again . I have a field in the table with properties of a number. It is filled by users. This field is roughly a unique number for each person that I don't want it to be repeated for someone else. I thought of using DCount. If a duplicate number is entered by a user, a message pops up...
  4. A

    Count function in ListBox

    Thanks DBG for the quick reply. Frankly, I don't know how to use ListCount .
  5. A

    Count function in ListBox

    Hello all I want to use the Count function to calculate the number of rows in ListBox. How do I write the function? I know how to use it in a continuous form, but I don't know how to use it in ListBox . Thanks in advance
  6. A

    How can I open a Form based on on a Query

    What the colleague (Ranman256) said is very accurate. You can use this code Dim stDocName As String Dim stLinkCriteria As String stDocName = "frmName" stLinkCriteria = "[ID]=" & Me![ID] DoCmd.OpenForm stDocName, , , stLinkCriteria Note that this section, I think...
  7. A

    Matching between a field in records

    I adopted your method because I could not find a solution to the above code. Your method is great, thank you my friend @bastanu I was hoping that the results were in (VBA) and not the queries
  8. A

    Free books

    Thank you (y)
  9. A

    Matching between a field in records

    Thank you very much, my friend bastanu , but I canceled the code and it became reliance on the query. Isn't this true?
  10. A

    Matching between a field in records

    Thanks for the help dear theDBguy but the same problem I have to hover the mouse over all the records.
  11. A

    Matching between a field in records

    I did that and also kept moving the mouse pointer to one field after another until I found the same. This is like I open the table directly in the view and filter it ascending and here I will find the similar.
  12. A

    Matching between a field in records

    Good evening guys Allow me to salute everyone and the organizers of this wonderful forum and the help they provide to others. I have a form that is based on displaying information from a table. In this table there is a field named (StatFig) that carries a number for each person and this number...
  13. A

    disable certain fields in a form

    I called the code in the form properties(Tag) but the fields remain available for input
  14. A

    disable certain fields in a form

    Note, dear sir, the example attached
  15. A

    disable certain fields in a form

    Thank you my friend did not work with me. Thanks for your time 🌷
  16. A

    disable certain fields in a form

    Thank you very much (Pat Hartman) but where do I put the (NoLock) and (Lock) and (bLock) in the text properties?
  17. A

    disable certain fields in a form

    To make this more general, you can pass the name of the control or control object to a subroutine. Speech in the utmost magnificence. Thank you very much for this valuable information. Yes, what I want is to use it for one model only. Not a general function. Now I understand after reading what...
  18. A

    disable certain fields in a form

    Good evening to all I found this code for dear friend(@arnelgp ) and made use of it for an existing field on the form. My question is how can I make this code a public function that works on all or some of the form fields. Thank you so much.... Private Sub textfield_GotFocus() Dim ctl As Control...
  19. A

    call section (C:\Program Files)

    Thank you very much, dear (arnelgp)
Back
Top Bottom