Search results

I hope someone can help. I have a form for entering orders. It has a subform with a record for each item entered. When I look at the resulting Purchase Order the records from the subform are in the wrong order - with the last line entered displayed at the top. How can I get it to look the same...

Hi I have a table called Orders and a form called OrdersPlaced. There is a field on the form called TotalValue which is the sum of the values of the lines on the order. How call I get this value to update the field called TotalValue in the Orders table? Thank you

I have a table of orders which has the field Supplier. When I produce the Purchase order as a form based on the Orders table I want to be able to add the address details for the supplier from the Suppliers table. There is a relationship between Supplier in the Suppliers table and Supplier in the...

I have a form for entering orders. There is a field which is for the supplier name. I have linked to the Suppliers table so as to get the list of suppliers but when I select one it does not populated the Supplier field on the Orders table. How can I get this to work? Thank you

Hi Struggling to get a total on a subform. I have a form called Orders Placed. This has a subform called Order Details. This is a datasheet with each order line for the order seen in Orders Placed. There is a field called Total Price which is calculated thus =[Quantity]*[Unit Price] This...

Hi I have worked in IT for many years, mostly testing software but using some SQL and VB to tweak supporting tools. I am now semi-retired and working in an admin role for a very small company. We want to develop some databases in Access to allow some automation of processes. Lindley