Recent content by azhar2006

I have been following since 2018, he knows what I mean:)😁

Thank you very much Sherk. The code worked fine.

No it didn't work

Thanks a lot for the reply I know. Access saves the data as soon as you move to the next field. What I want is to refresh the form because there is an unstructured field where the sum of records is calculated and another field that calculates the sum of vacation days. I can't see that unless I...

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

Thank you very much. Great job it worked well.(y)

Yes the text box is located on 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...

This will be quite convoluted to do in SQL. I believe you will need a helper function in vba

'Export DoCmd.TransferSpreadsheet acExport, acSpreadsheetTypeExcel12Xml, "Name Query", "D:\AZ.xlsx", True 'Import DoCmd.TransferSpreadsheet acImport, acSpreadsheetTypeExcel12Xml, "Name Query", "D:\AZ.xlsx", True

https://support.microsoft.com/en-us/office/move-data-from-excel-to-access-90c35a40-bcc3-46d9-aa7f-4106f78850b4

Look at this example. I think this is what I understood from the topic you want. SELECT tblCustomers.ID, tblCustomers.Cust_Name, tblCustomers.Starttime, tblCustomers.Stoptime, ([Stoptime]-[Starttime])*24 AS [Total hours] FROM tblCustomers;

Try adding a date field to each record and create a query based on the months of the year. Months: Format([Transaction date];"mmm")

This example. Try to look at the relationships.

What are the types of relationships between the tables in your database? Could you please attach a picture of the relationships. So that experts can answer your question. Your question is somewhat unclear.