Recent content by ili_sophia

hi arnelgp, thanks for the help. i tried to add in more data in the table and there is some error. 1. i keyed in Buyer table : A1003, AA885 , cost=$100 Shipment table : AA885,shipment amount = $50 Query results: A1003,AA885, $80, 4/5/2019, paid. Shouldn't be A1003,AA885,$50, 4/5/2019...

They share many same fields as they are from different report from different departments that i need to combine together. i have created a total shipment query group by the buyer number. for example buyer number AA885, it has a total shipment amount of $48. In the buyer table, there is a...

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

How do i make it criteria. where Po LIKE and/or Batch No LIKE?

There are both text Fields

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

i have to import the data every day from an excel worksheet as it comes from another system. With the imported data, the users of this access system can amend the data for certain columns such as MRName, Nettweight, Grossweight, etc... once it is completed it will be saved under the...

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

@Mark does this mean that it will only append records with the lastest run time?

Thanks plog for informing me about this. I will make the necessary changes however, some of the fields are presented this way because the data is actually imported from another system so i cannot make changes it.

I'm confused about the config record that holds the "Last import date" could you explain it. Thanks!

I need to create another table because the two tables are used by another creator for their own function hence I cannot combine the tables in the beginning. but the problem I am facing is that I need the Revised records to overwrite the original records from the "MaximMainTable" instead of...

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

Is there a way to do it without creating an external table The fields only consist of values no calculated values I have attached an example. it is not able to import rows 30-34

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