Search results

ِAHa, good question dearThe_Doc_Man The number comes on the paper while one of the employees is performing his job, so the user transfers this number from the paper to the program. We have previously heard in the narrations that the Devil slip Adam and made him eat from that tree. This was the...

Private Sub txtStatFig_BeforeUpdate(Cancel As Integer) If DCount("*", "tblmastr", "StatFig='" & Me.txtStatFig & "'") Then MsgBox " This Number already exists. Please enter a unique Number to continue.", , "Error" End If End Sub

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

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.

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...

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

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

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...

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

Thank you (y)

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

Thanks for the help dear theDBguy but the same problem I have to hover the mouse over all the 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.

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...

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

Note, dear sir, the example attached

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

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

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...