Recent content by deepcec9

While exporting the report to an excel format, it displays the "Sum of" value in wrong cell. Checked the format in pdf, working fine. Please find the attached screenshot. TIA

depends on product size. there can be 10-15 smaller products or only 1 single product.

Table name: out fields: netweightp (netweight of product) grossweightp lengthp widthp height netweight (netweight of case/pallet) grossweight length width height productid productname jobnumber

Not in datasheet view. subform is continuous

No the subform has pallet and product details, main form only have job number. There can be multiple pallets or products in one single job number.

can you please provide me the list of reserved words in access.

Hi, please correct me if im wrong doing an inventory management, created two tables in and out, which captures inward movement (cargo coming in) and outward movement (cargo going out). When cargo goes out it reduces the product count from the in table

no, the field name is productid. productA, productB and productB are data in it.

Need to update a field with sum of another field Scenario: fieldnames productid netweightpd(product netweight) netweightpal(pallet netweight) palletid In a warehouse job system is capturing product dimensions including weight. One pallet may contain multiple product, so total weight of...

UPDATE [in] SET [in].remquantity_in = [in].[remquantity_in]-[Forms]![test1]![quantity_out] WHERE ((([Forms]![test1]![inid_out])=[in].[ID]) AND (([Forms]![test1]![productid_out])=[in].[productid_in]) AND (([Forms]![test1]![ponumber_out])=[in].[ponumber_in]) AND...

Thank you for the rep Created an update query which updates the "remquantity" field in inventory table based on the primary key. And it is working fine. I created a command button on footer of the form which on click runs the update query. As it is a continuous form and displays more than one...

record source: "out" (tablename) fields are from table: "out" reduce the product quantity from inventory table "inventory" Eg: there are 20 phone and 30 computer in the warehouse. Today 10 phones and 5 computers are exporting So once I save the form click a command button it should run an...

Will make it clear. In a warehouse inventory when I select the job number system will list all the records with same job number in a continuous form, there are multiple products going out from warehouse with same job number. When I click on "SAVE" button i want to save these records and run an...

Sorry for the cross post... Can you please help me in creating a save button to update all the records in a continuous form.

Hi, Created a continuous form which lists records based on value from another form. Need to add a save button to the footer of continuous form which updates all the records in one go. Currently it updates only one record. TIA