Recent content by KiwiGirl

I sure will. I'll throw one from the Pier.

That works perfect! You have saved me so much time. It would have taken for ever for me to work that out. Thank you very much for all your help.

Hey...I was wondering if upokororo was a Maori word then i looked at your location and thought No...but if i'd gone into your public profile, I would have seen that you were (once) a kiwi. The SQL for qryInvoicing is: SELECT T_JobRecord.Job_ID, [Staff_Forenames] & " " & [Staff_Surname] AS...

Thank you for that it works very well. I thought I might have been able to put it in a query which is where I really wanted it, but after spending time trying, I realise I can’t. I have attached the database in the hope that I can explain what I need to do now. What I'd really like to achieve...

Hi again The code produced a run-time error 2471 "the expression you entered as a query parameter produced this error: 'ATA01'. Which is the value of me.ServiceItemID. Thank you for perservering with me. KG

I have had a chance now to try out that code. It first came up with a complile error where it expected a list separator or a ). So I put a ) at the end of the line of code (because I didn't know where else). It then came up with the following error: Run-time error ‘3075’ Extra ) in query...

Yes you are right in saying that the comparison i am trying to make is to find the price in the [Price List] table where the value selected in the MyDate field (on the form) falls between the ContractStartDate and the ContractEndDate fields in the table. The price list contains items that have...

Thanks so much for your reply and for the link to the reserved words. Yes, i will definately change the "Date" feild to something better. I actually have the ContractStartDate and ContractEndDate in the [Price List] table and MyDate field on the form. As soon as I get a chance (in the next...

Thanks for your reply. Yes I had seen that link before I posted but i was not able to figure out the between criteria with any success.

Hi all I am trying to set a criteria in a DLookup and I don’t know if it’s possible. I’ve managed to get a result using the following code in a form but it only matches an exact date. strValue = DLookup("Price", "Price List", "ServiceItemID = " & "ServiceItemID" & " and...

I have attached the database so it will be easier to understand. The client proposal report has a Client ID parameter. There are only 3 clients; Client ID 3, 4, 5. If you look at Client ID 5, you will see what's happening. thank you

Thank you for your reply. I have a very small detail section anyway and yes it is set to Keep Together and also the Can Grow set to yes. Is it possible to set some kind of conditional pagebreak in the Report footer? (not that I know how).

Hi all I have a problem with the way the data on my report is printed. My report has one text field in the detail section, and can vary in size for different clients, and a large report footer (44.5cm) that contains a sizeable amount of text. Depending on the amount of data in the detail...