Search results

  1. I

    Combine two tables together and get a total sum with criteria

    Hi there, I have 2 access tables, Buyer and shipment. 1. the tables are linked with the fields buyer and buyer number. 2. The shipment table contains the breakdown of buyer number and shipment amount. 3. I need to sum up the shipment amount and add it to the buyer table. however, there is a...
  2. I

    Data mismatch

    Hi there, i have this code in my search command button where it searched based on two field MXD and Batch no. However, i get the error of data type mismatch in criteria expression does anyone know why Sub Search() Dim StrCriteria, task As String Me.Refresh If IsNull(Me.PO) Or...
  3. I

    save timestamp upon click of save button

    hi there, i have a date time stamp on a form but i realise that it will save the date and time when the form is opened. i would like for the actual date and time to be saved when the save command button is clicked. i have tried to add the code Me.DateTimeStamp = Now() but it gives the error...
  4. I

    Combining tables based on conditions

    Hi there, I have two tables "MaximMainTable" and "ModifyTable" and i would like to combine the two tables to create a new one. "MaximMainTable" consists of new records created. "ModifyTable" gets its data from the "MaximMainTable" and the users can modify the records to make it...
  5. I

    Unable to import empty excel cells into access

    Hi there, I have a form in access where it allows the users to browse an excel worksheet and import it into the table. the table gives an error of Type conversion failure when i try to import an empty cell into the access table for this specific column "Diff" The settings are Field size...
  6. I

    Browse for file glitch

    Hi there, I have a form where the users can browse for a file and import their excel into access. however, there seems to be a problem with the browse pop up screen. the browse pop up screen comes out fine with my ms access 2016. But when I tried it on other computer using ms access 2013...
  7. I

    Show all command button for subform

    Hi there, I have a form where the users can select the date and it will display the data in the subform. I would like to have a command button to show all the available records in the subform. I have attempted a code below. but I understand that from Dmin and Dmax is wrong. how do I...
  8. I

    Subform not showing all the data

    Hi there, I have a form where the users can select and search for the date in the table and it will appear in the subform. I have set the start date selection to be the min date in the table and the end date to be the max date in the table. However, I am facing the problem of the subform not...
  9. I

    Import and update access from excel

    Hi There, I have an access userform that allows the users to import in their excel worksheet and it will append the data to the tables. However, now I am facing the problem of updating the table. In the case where the users have already uploaded the worksheets into access but suddenly finds an...
  10. I

    Method of range of object Global failed

    Hello, I would like to export my access data to excel which also creates a graph based on the exported data. I have recorded my macro in excel and added it to my export command button on my userform. The chart was able to be successfully created the first time i use the export command button...
  11. I

    Create two columns from one, based on two different WHERE cause

    Create two columns from one, based on two different WHERE clause Hello, I have created a split form where it allows the users to select the date range and it will show in the data in the table below. I need to create two new columns based on the field of Loading Quantity (kgs) Both columns...
  12. I

    Check if tables match before importing excel to access

    Hello, I need to import my excel worksheet to a specific access table. However, when a user accidentally select the wrong excel worksheet, the tables would not match. Hence, the error would prompt Run time error 2391 Field "PO" doesn't exist in destination table "Printing". which would lead the...
  13. I

    Prompt for error in importing excel table (setwarning)

    Hi there, I have made a userform to allow users to import the excel file into the access table. So far i have made a combo box to select the worksheet in the workbook as well as to import it to a specific table "Dyeing". i would like the userform to prompt the user with a message box of the...
  14. I

    How to create a combo box to allow users to select excel worksheet to import to acces

    Hi everyone, I have created a user form to allow users to import the excel worksheet into a specific access table. However, the workbook contains multiple worksheets and i need to create a combo box to allow the users to select the specific worksheet they want to import. Is there a way for me...
Top Bottom