Recent content by Joshlindsay

Hi Bill, We're still playing around with the quantities. This is a kind of a learn as you go project. Trying to decide if we want unlimited per estimate of just limit it to 3. Unlimited would be a case of wrapping a for each around my calculation code (I think) We're also thinking maybe we'll...

Perfect! Thanks Bill.

Thanks Bill. I've just tried importing this but even after deleting my own main menu it's exactly the same. Weird. Once of those estimate forms is the old design we we're going for but it didn't work out. I'll add Option Explicit to all my modules. Thanks.

Great news! The clever chap I work with has written a loop for our average price calculation. If rs.RecordCount <> 0 Then rs.MoveFirst Do Until Quantity <= rs!MaximumQuantity Total = (rs!MaximumQuantity - rs!MinimumQuantity) * rs!ClickPrice Subtotal =...

That sounds excellent. Thanks. We're using Access 2010.

Is that like the hyperlink examples they have on the Northwind and Services templates? I was trying to figure out how they worked. An estimate can be made up of purely mail components (these are easily selected from a table) or a print component (which needs to be calculated based upon a few...

Thanks Bill. ItemName (could also be names ProductName) in tblEstPrinting is the name for that printed item as each estimate can have more than 1 printed item (letter and brochure for example) so they need to be differentiated. That is the reason why I've got ProductName on the...

Same in Auckland. At least the weekend was nice.

What we're calculating is the impressions not printed items. It means that if someone gets a quote for 20 impressions one day, 250 impressions the next and 2200 impressions the prices are all calculated the same way rather than having a set price for the quantity break. It also means that there...

Thanks for your reply Simon. It's the fairest way we've found to calculate that price. It's not the price of an actual product but a component of one.

A walk on the beach. That sounds nice. Are you in NZ at the moment? I'm in Auckland which Google is saying is 10deg C. Cold but very sunny. Thanks for your help Bill.

Bugger. Try this. I've zipped with another piece of software and uploaded with Chrome rather than FF. Cheers,

Thank you both for your help so far. It is very much appreciated. Attached are some files for you. They way the system is currently working is it's taking a bunch of lookups from combo boxes in a form and comes back with a average click price which is multiplied by the number of sheets. We...

Thanks for the reply. This code will calculate a rate at which the printing is charged at (avgclick would be the price per sheet printed) based upon the quantity. The rest of our products are simple per 1000 rates. I've got a table setup with ID, MinimumQuantity and Rate which has all my price...

Price calculation loop driven from table. Is this possible? I've written a chunk of code which calculates an average price based upon a quantity - I'm pretty stoked with it being a complete novice. Basically the first 50 items are charged at a certain price, the next 50 at a certain price, the...