Search results

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

Created ACCDE database, on selecting a level 2 navigation form I get this error "requested type library or wizard is not a vba project" all other forms are working fine, error is on only one form. Created an OnError event for the main navigation form: Private Sub Form_Error(DataErr As...

that updates thevalue to table directly, I would like to update the value to subform filed first and after saving the subform updating it into table. In short need to show the "truckno" value from main form to "truckno_out" in subform (continuos). Thank you

Need to update subform (continuous form)field from value from main form. Main form filed "truckno" Subform field "truckno_out" tried the code Me.out_Subform.Form.truckno_out = Me.truckno.Value but it updates only first record. Is there any way I can update all the line of records in subform...

Thankyou for the reply, figured out. Changed the criteria to [Forms]![frm_jobout1]![out Subform1].[Form]![productid_out]= [in].[productid_in] Working fine now

Hi, I am trying to run an update query which updates the value in a sub form to another table. Set a macro "open query" to a command button, when I click on command button a pop up window appears with message "Enter parameter value (field_name)". tried the same query in another FORM it is...