Search results

Hi All, I am still confused to why this isn't working. I have set up the 3 queries like John suggested but it still only seems to be pulling the informaton from the UnitPrice field. Am I doing something wrong with the RecordSource. Please, please, please help. Cheers James.

Hi ddrew, THis is a sample database uploaded by Thinh that will be perfect for you. Hope it helps, Cheers James.

Dear All, I am trying Total up the Customer Orders per customer for Tracking spend (RUNNING TOTAL) – If a customer pays then need the ability to reset to zero. Add the total for each customer account and then have a running total until it is cleared down and set to zero. I have added the...

Hi there, thanks again for your reply. If you change the prices in the product table i.e rudgwick bricks to 3 different price in the UnitPrice, TradePrice and DIYPrice, it doesn't seem to pick it up if you do 3 invoice examples using each of the accountTypes. It still only seems to pick up...

Hi John, Thanks for your help on this matter. For some reason though it is not picking up the different prices for each category. They are all just selecting the UnitPrice. Is therea reason for this. Thanks again. James.

Hi Again, Should the queries be taking the information for the prices from the products table or the order details table? They should be taken from the products table shouldn't they, although saying that I have tried both ways but seems to still come up with an error? Like I said before...

Thanks. Although I have now populated the table and doesn't seem to help. Mmmm I'm stuck.

Thanks again for the DB changes but it seems to show an error on the UnitPrice field. Can't work out how to change the field, as when the form loads it uses certain fields including the UnitPrice but I would like this to change if the TRADE / ACCOUNT or DIY is selected. When you select a...

Hi John, Thanks a million for your help. Starting to implement now and looks good so far. Will keep you posted. Thanks again. James.

Dear All, I am yet again in need of help. Basically I have the attached database that I require some guidance on please. If Trade is selected from combo box AccountType in the Orders Form then it displays the prices from the Trade Price in the products table. If Account is selected from...

Hi John, Just wanted to say a really big thank you for all your help on this one. It has been bugging me for a while and now you have fix it. So thanks a million. James.

Here it is is the database and the form in question is Orders

Hi There John, I'm getting in a bit of a muddle with this. Do you have an email address so I can attach it and send it through to you. With the PM I can't seem to attach a file. Thanks again for all your help. James.

Hi John, Can I PM you? Cheers James.

Hi John, Sorry I thought I had it but it now shows a dialog box asking for a parameter value. Why is this? Thanks a million. James.

Hi John, Thank you so much for your help. Very, very helpful reply!! Thanks again. James.

Hello All, I have a form in MS Access that I want to fill out like an invoice and then print just that particular order using a report but I can't seem to get it to work. Can someone help please? Here is the code I am using from a command button to open the report but it shows errors for the...