Recent content by azhar2006

  1. A

    Merging several similar databases into one (table only)

    Thank you very much. This is what I wanted. And I apologize to the moderators if I have violated any instructions; I am truly sorry.
  2. A

    Merging several similar databases into one (table only)

    Hello everyone. I have three identical databases, each containing the same data, distributed among three employees. Each employee updates the data on their respective database. I want to merge these databases into a single database, eliminating duplication and retaining only the most up-to-date...
  3. A

    Update or Requery button

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

    Update or Requery button

    Thank you very much Sherk. The code worked fine.
  5. A

    Update or Requery button

    No it didn't work
  6. A

    Update or Requery button

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

    Update or Requery button

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

    help me correct my error for Count function

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

    help me correct my error for Count function

    Yes the text box is located on the main form
  10. A

    help me correct my error for Count function

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

    Solved Time Difference

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

    Executing a "Saved Import" or "Saved Export" programmatically

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

    Solved Can one import a named table from Excel into either a new table, or an empty table created for the purpose, in Access?

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

    Solved Time Difference

    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;
  15. A

    Pareto Graphic

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