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

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

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

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

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

Created report, and would like to display total net weight and total gross weight. As you can see in th attached files each case id has one or more record of net weight, so total gross weight will be Sum([netweight]+20) It is working for first case id but gross weight data is wrong in the...

I would like to join autonumber field and a text and save it to another field. For example Autonumber test_field 1 w1 2 w2 3 w3 44 w44 tried "W"+""[autonumber] in test_field format, but its not working...

How to update value from unbound text box to table. tried the following DoCmd.RunSQL "Update in SET remquantity_in =" & Me!Text35 & "where out.productid_out = in.productid_in AND out.ponumber_out = in.ponumber_in'" but it shows RUN TIME ERROR 3144 Syntax error in UPDATE statement Please help...

Hi, I am creating a warehouse inventory and I want to update each job with a unique job number. For example: Each job has different line of products coming IN/OUT. product1 ... 50 quantity ... suppliername product2 ... 25 quantity ... suppliername and so on So when I search using job number it...

Hi, Im new to access. Trying to build a inventory database, following are the tables and its fields product productid productname supplier uoq weight warehouseIN productid productname supplier uoq quantity PONumber invoicenumber caseid warehouseOUT productid productname supplier uoq quantity...