Search results

Thanks pbaldy, it was so obvious, it slapped me in the face! Next question, I am currently using two forms to enter the order - NewOrderF, where the CustomerCombo shows all the customers and now the NewOrderbyCustomerF, where the default to the CustomerCombo is the passed CustomerID (as...

Thanks pbaldy. I use the combofield in the NewOrdersF and it happily works. The problem is that I want to carry through the Customer ID/Name/Code to the NewOrdersbyCustomerF and not have to have a dropdown and I can't work out how to do that.

Thanks Plog. In answer to your questions: 1. I'm not sure what you mean by direct relationships and why 4 of them are wrong 2. The Cost price and Sales Price on the StockItemT are the default price - they can be over-ridden at ordering if needed. 3. The date fields can be used for some of the...

Hi, Can anyone see what I'm doing wrong here? I have 2 ways to add a new order - one from the main menu, where I have a dropdown to select the customer, which works perfectly. The second way involves having a button on the customer's orders form (OrdersF) and passing the CustomerID through to...

Thank you all so much. I've finally got it working. I used the same query I had at the beginning, with the same calculations, and now it works!! All the lines are shown exactly as I want them and not scrolling up. I don't know exactly which step I did that made it work but it does not and I'm...

There isn't a special char in the field, I was just using that to imply that I used the same calculation for both the CostPrice and the SalesPrice. Even using the expression in the aggregate calc doesn't work. Calculated field TotalCostPrice = [QuantityRequired]*[CostPrice] where...

That's what I was afraid of! If, instead of calculating it in the subform footer, could I calculate it in the form footer with a DSUM? Would that be a better way of handling this?

Thanks all for your input. My head exploded with this, so I took a few days to screw my head back on! In response to a few queries, I have convinced the user to use a Delivery table, so that has been changed. Customers can only purchase their own items, never any other customer's items, so a...

Thank you all for your replies. Some answers for you. 1. The CustomerID is in the StockCodes table because each customer has its own set of items and can only order its own set of items. 2. Supplier will be linked to stock codes in time but I'm working on the basics at the moment. 3. There is a...

Thank you June. I've attached it here. I'm on UK time, so I won't be able to respond until tomorrow morning, my time. Thanks to all of you for your help.

Yes, definitely continuous

I know, but it does. Here is a picture of my form - as you can see, plenty of room. As soon as I tab or enter to get to the next row with the first line going up above the new line for entry. This is my subform in Design. It's a continuous form so I'm very confused!

Thank you all for your help. I managed to do it, as you all said I would, using DSUM. My only remaining problem is that when I add a new order detail line to my order using the continuous subform and tab to the next line, the first line scrolls upwards so that I am left seeing only the order...

Thanks all. I'm going to go away and think about it and come back fresh on Sunday to look at it.

I haven't got a problem using the form/subform when adding new or editing orders. My problem is with the summary list of orders. As you can see from the picture above, I want to show a list of orders WITH the totals shown. That is why I added the totals fields to the header record - just to be...

Thanks. It is to give them all the important information in a quick view.

So my form looks like this: I want to be able to amend the PO Numbers, dates and status whilst still showing the totals. What do you mean by a left join - as soon as I put a query in, it changes to recordset unupdateable?

But how do I get round that?

I have the following queries:- OrderDetailsExtendedQ which has all of the OrderHeaderT and OrderDetailsT fields on it OrderTotalsQ which takes the OrderDetailsExtendedQ and sums the totals to give totals per order OrderHeaderQ which takes the OrderHeaderT, CustomerT (for the Customer Name) The...

The reason I am saving them in the header record is because when I display a list of the orders, I want to be able to change details e.g. delivery date, paid date, status, on that line in the list and not have to go into the whole order. However, once I use a query with multiple tables to...