Search results

:D Instead of just using the Database and saying, there you go its done... I have gone through the coded bits by you RG and have fully understood all whats going on and I have even re done the bit you did so I know what to do etc etc, so if the teacher asks, I know! Thanks again mate. Steve.

WOW RG, that is so cool and so much better. I would like to thank you for your patience, time and effort you have put in, in helping me over the past couple of days. All I need to do now is my Switchboard then it is complete. Thank you once again! A very happy Steve :D

Would Tools then StartUp do the job?

It was Sandwich to Orderline ... 1:M and the fields that were used was SandwichNo to SandwichNo Steve!

Done!... Steve.

:eek: My teacher couldn't do it either! What do I do now :( Steve.

Lo RG! Just in my Database lab session now, going to ask the Tutor to help me :) Steve!

It's fairly late now :( I'l take the database with me to University and have a try at it then. Report back tomorrow sometime, so keep a look out! Steve :)

No RG, nothing as of yet :( If nobody on here can help me work it out, I'm hoping my Tutor can help me. Still playing about with it...a day on :eek: Steve :)

I still haven't been able to do it :( This is the only thing left for me to do now, completed the rest of the booklet today. RG/Rich, where do I attach the query to and how would I do it? Would I put it on the "On Load" event? Thanks chaps. Steve :)

Just been having a play about with it. I know what I need is there, its now just a matter of doing it! Once I have done the query, how do I attach it to my "Place an order" form so it update the total price in the "CostOfOrder" text box? Thanks! Steve

Done. If a mod wants to delete it, feel free :)

Fair enough. I just have no idea :( Steve.

Could you be as kind to help me out by doing one for me? What information do you need off my database (If any?) Thanks Rich and RG so far! Steve.

No, what I have typed is what it says :( I don't know how to do this part at all. Steve.

:D I just didn't understand your reply! of "Is it a course requirement that you accomplish the task in this manner?" :o I don't know about not having to use the loop on the recordset to get the answer, but I think we have to use one. This is what it says from our sheet... "To complete the...

1) The calculating of the order? or 2) The asking on the Internet for help :p With regard to my calculating query, where would I put that? I have no idea what so ever! Edit - I did not create that query. Our Tutor has supplied it for us in the sheets of paper we are working from. Steve :)

I need to calculate the total cost of the order and enter this into the "CostOfOrder" field which you can see in the picture... I need to read all the orderlines for an order into a record set and calculate the cost for each orderline. I need to use a loop in VBA to add them all together...

RG = Legend! I have been pulling my hair out for a day or so over this, thank you so much! It's all working perfectly now :D I'm hoping you can help me out on this one RG... I need to calculate the total cost of the order and enter this into the "CostOfOrder" field which you can see in picture...

Hi mate :) The "CustomerNo" field on the "Customer" table is Autonumber The "CustomerNo" field on the "Orders" table is Number Is this ok? Thanks, Steve :)