Search results

I think our big brother @The_Doc_Man knows what the military number is. It is a number that accompanies the employee from the time he enters the service until his retirement. It is impossible for two employees to have the same number, because this number consists of rows of numbers, each two...

Thank you dear Pat Hartman . Your words make sense. Certainly some errors occur in the update. For example, those who do not have military numbers or neglected to enter them by the person in charge of data entry. But to find 10 records with errors and correct the error or know who is the data...

Thank you LarryE Yes it works fine . Note you used the HAVING clause in SQL 🌻 (y) SELECT tblMaster.MilitaryNumber, tblMaster.IDEmployee, tblMaster.FirstName, tblMaster.Unit FROM tblMaster WHERE (((tblMaster.MilitaryNumber) In (SELECT [MilitaryNumber] FROM [tblMaster] As Tmp GROUP BY...

Thank you LarryE dear I modified your QueryAppend so that it only accepts MilitaryNumbers that are NOT duplicates in the Find Duplicates query.

Thank you LarryE dear INSERT INTO tblMaster ( IDEmployee, MilitaryNumber, FirstName, Unit ) IN 'D:\Data24.accdb' SELECT tblMaster.IDEmployee, tblMaster.MilitaryNumber, tblMaster.FirstName, tblMaster.Unit FROM tblMaster; I have attached this example for you. There is a main database located in...

Hello everyone Again I need help.:);) I have a table containing employee information and among this information is the employee card number which is a unique number as you know. I have created a query Append the data and it works in a new way and updates the data in the other database which is...

As I understood from your question you want Access to recognize the report when it is returned to you by the teachers, right? If so, you can use a barcode reader and put a barcode on each Word or PDF report. When the report is returned to you, Access will recognize the record of the report by...

I think you need such an expression. It will be calculated at the bottom of the report. =Count(IIf([Trade]="Purchased",0)) =Count(IIf([Trade]="Watch",0))

This is a thread by allen browne talking about Validation Rules http://allenbrowne.com/ValidationRule.html The important thing to understand about NULL is that it is not a value, but the absence of a value. Because it is not a value normal operators like =, <>, <, > etc. cannot be used. If...

As brother Gasman said, use a Select Case Dim rpt As String Dim c As Integer c = Me.Frame1.Value Select Case c Case 1 rpt= "Level1" Case 2 rpt = "Level2" Case 3 rpt= "Level3" Case 4 rpt= "Level4" rpt = "Rpt_SO_by_Customer" End Select DoCmd.OpenReport rpt, acNormal

DoCmd.OpenReport " Rpt_SO_by_Customer", acViewPreview, OpenArgs = True

Try this. And try to write the name of the report in this way. I think that most of the specialized brothers support my words in naming reports, queries, tables and even the names of fields inside the table design. There is an article by (Gasman) that explains this. DoCmd.OpenReport...

Good evening. Thank you Pat Hartman for your interaction with my topic and thanks to all the brothers in the wonderful forum. I will attach a part of the project with an explanatory image. Note the image that only those who have the same number in the (StatisticalNO) field will be updated if...

The same message appears to me, which is the total number of records in the table. While I have only updated two records. There is a technique in the query that tells you that you are about to run an update query, which will update a certain number of records. Also, if I do not update the...

Hello guys. Thank you very much to everyone. I deleted the previous topic because I found the error in the code. The error was in the variable type and also spelling errors in the field names. I apologize to all of you, especially Mr. (Gasman). 🌻 Now I have another problem, which is the message...

Yes I don't see it will you help me or not? I think you also don't know what the friend wrote (@arnelgp )

This is an example of the database I am working on. When I click the Execute button in the form I get an error message

Thank you dear (Gasman) This is the error message. The line in the code is this. It is a number. strStatistical_Figure = rs![Statistical_Figure]

Hello guys I have a database that my dear friend (@arnelgp) helped me design. It contains two tables, the first is called (A) and the second is called (B). Table (A) is the main table in the database. As for table (B), it is a table that I feed with information for specific fields and use a...

Thank you isladogs Yes I mean the motherboard number Public Function GetComputerSerial() As String 'gives serial number for processor / motherboard (?) Dim SWbemSet As Object Dim SWbemObj As Object Dim strSerial As String Dim strShowForm As String Dim strSerialInTable As...