Recent content by PulseTeqUser

Thank you for your speedy response. I am now getting the field populated! Just got to work out how to do the sorting - afraid I am very new to all this.

I thought that would probably be the way to do it but I can't get the field to populate and it shows on the form even though I have set the Visible Property to No

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

Thank you for replying. However, the form contains a sub form where we enter the various items on the order. I store each of these against the order and total the values so we can see the total for each order. If I don't hold these totals in the table how can I query how much we have spent with...

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

The DLookup solution is what I need - thank you very much

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

Thank you for your help. I have got it working now.

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

Wonderful, thank you! Can I ask what you changed in the database for future knowledge?

I appreciate your help. Here is the database

Thank you for responding but I am not sure what you mean - are you able to provide an example?

Thank you for replying. I see in Layout view that the field on the subform is being populated. However when I look at the Orders Placed form I am just getting #Error. Some screenshots included to illustrate.

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