Search results

Hello everyone I am trying to add an update button after adding data to a subform. But I want the place or location of this button in the main form

Hello my dear friends I am trying to use the (Count) function to collect the number of employees, but I get an error The employees table is in a subform and I am trying to use an unstructured field based on this expression, but I encounter an error in writing the expression below...

Hello guys. I am trying to convert tables from Access to SQL using the update added by Microsoft which is SSMAforAccess_9.5.0.msi and I think it will save a lot of time in creating tables and queries in SQL but honestly I don't know much about dealing with SSMAforAccess_9.5.0.msi and I think it...

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

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

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

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

Hi guys I am using this function to protect the database from copying and transferring it to another computer. And it works very well. But the problem I am facing is that I have to open a window (VBA) to put the Board Maker Serial Number for the program to work. Is there a way to create a table...

Hi guys I made a macro button for search. When I want to convert it to VBA language, I see that the conversion command is not activated. What is the reason? Thank you

Hi guys Have a nice day everyone. I have a listbox based on a query. I want to put a text box on the form that will collect the records in it (ListCount)

Hello guys. I have a database that contains almost general employee information. This database is distributed over the group of departments in which these employees work. Almost every month, changes occur to these employees, such as promotions, travel, and other matters. The employee concerned...

Hello guys How to display a crosstab query on the form? If there is an example, I would be grateful to you. Thanks I have three tables, each table contains sections. There is stationery such as pens, papers, and other materials distributed among these departments. What I want is to create a...

Hello guys . You have created a form based on a query. And put a text box in it for the purpose of conducting a search in the query records. I used this code that my dear brother (arnelgp) helped me write, but the code does not work. I don't know where the problem is Thank you very much Private...

Hello friends again I need help converting this code from VBA to an expression in a query. I've tried hard and failed to turn it into an expression. If Not IsNull(Me.txtsucc) Then strWhere = strWhere & "([Success] = """ & Me.txtsucc & """) AND " End If Thank you very much

Hi guys I have created a query and I used this expression in one of the query fields, but I encounter an error in the sentence. Can you help me fix the error Thanks to all . [Forms]![frmRptDeprmnt]![Combo];[Department];[Forms]![frmRptDeprmnt]![Combo]

Hello all I have a report based on a query, and in this query, I make a filter for the information included in it through a form. I have put a print button on the form that previews the report based on the filtering process through a text box. But when the report appears, all the data, not the...

Hello all I have a main form and a subform inside. I want to execute this expression (=Count([fullname])) on the subform and I put it on the main form. Thanks to all

Hello my friends:) I have a report with six fields, and I have a form with two buttons to print the same report. What I want to do is have one of the buttons on the form display the full report with all its fields, and the second button, when clicked, will show the same report, but with only...

Hello my friends Can i get your help with this code. I want to add (NumberUpgradeAfter) and (DateUpgradeAfter) to (strSQL) clause While rs.EOF = False strStatFig = rs![StatFig] strRtba = rs![Rtba] strNumberUpgradeAfter = rs![NumberUpgradeAfter]...

Hello, Hello guys . I hope to find someone to help me. I have a report in the database based on a query and through a button on the form the report appears to me with all its fields according to the query. What I want is to hide and show some columns in the report. for example. I need a report...