Recent content by Hulm1

Ok brilliant thanks. I'll give it a go

Thank you all for your help. I will have a go with tblPakingFee. Meantime can I confirm that LostFocus is the right event? It is also an unbound txt box (a calculated one)

I am stuck on something here and losing hair. I have an unbound text box called "packingfee". I have another text box with a total value in it, let's call it TotalSale. I have 4 PackingFee prices which are based on values in TotalSale. If the value is <1 PackingFee = 0, if it is between 1...

That's done it. I didn't know you could have Group Footers. You'd almost thing someone had thought this through! Thanks again

Sorry, but could you possibly be a bit more clear? I delve in an out of access. I am looking at the Sorting and Grouping as I write this. The only sorting I have is on QuoteCategoryID at the moment. I am not clear how to do what you suggest. I mean the =1 one bit and how that relates to...

The issue is that in the Report footer I have a Grand Total. I put the Terms and conditions subreport into the report footer (under the Grand Total)and inserted a page break just before it. For some reason I cannot fathom, the grand total is pushed to the top of it's own page, even though the...

Ok that works great. I had to add a TermsID to my Quote Table and simply default it to one. This then forms the parent child relationship. Unless there is a better way? Is it also possible to suppress the page header information on the pages with the terms and conditions? Obviously it...

Ah yes! Thank you. I will do that tomorrow when I am back in the office. I appreciate your help

Hi I wanted to add some Terms and Conditions to an access report (a quotation). However, these run to two pages and I wanted to simply tack them on , and force a new page for each. However, I don't know how to add them. I tried simply adding a Label for each and filling it with the text but I...

These are bound forms. Five key tables are: Enquiry Estimate EstimateVersion EstimateProductService zmtProductService Relationship: one Enquiry to many Estimate one Estimate to many EstimateVersion One EstimateVersion to Many EstimateProductService One EstimateProductService to Many...

Once a project is "won" I need to create an Order Confirmation. I want to do this by duplicating the information contained in the "frmEstimate" and it's subform "frmEstimateProductServices" which is a continuous form with many records (items). I have seen Allen Browne's code for duplicating a...

I should have known that. Thank you

Something just cropped up. Where Quantity >=1, Markup and UnitPrice are calculated as they should be, the formatting goes. I have them set for Currency, 2 decimal points but this seems to be overidden. This seems odd?

I modified this slightly as follows in order to avoid the need for a RateOnly field. IIf([Quantity]=0,"",[SalesPrice]/[quantity]) AS UnitPrice The same for Markup. The reason is that it removes the "Error". SalesPrice comes out as "0" anyway if quantity is "0" I was then thinking I would put...

Brilliant thanks. It applies to all fields really. Sometimes the client wants a rate only in case the quantity is variable. That will do it though!