Search results

Hi PNGBill, I have done what you have suggested and I can't get the invoice amounts to total them sum of the customers. e.g. 100 customers but only 80 invoices. very bizarre! Code used: Qry_Running_Total_3rd Field: CountOfCustomerID Table: qry_Customer_Count Field: SumSalesValue...

Hi PNGBill, Thanks for the info, I will get onto it straight away and let you know the outcome. Thanks again. James.

Hi PNGBill, sorry to be a pain but I can't seem to get my query to run. I have at the moment got a query that runs a list of all the customers with all the invoices and line entries that they have purchased, then at the end I have created a new column to add up the line total, but how do I now...

Excellent, Thanks for the great advice PNGBill. Will try that out now. I will let you know and if I can get it working I'll place up a sample database. Thanks James.

Hello all, Its been a while. I have my little retail database and am now trying to add a customer account running total so I can check if they are over there agreed total or not. does anyone have any pointers on how I would go about this and the ability to reset the amount as and when the...

Hi All, After yet more help. I’ve got a combo box (AccountType) that on selection dynamically creates the fields in my subform (OrdersSubform), here is the code: Private Sub AccountType_AfterUpdate() Me.OrdersSubform.Form.UnitPrice.ColumnHidden = True...

Hi Team, Thank you for all your help. Just to let you know I have now got the solution: In the After Update Event I have placed the following code: Private Sub AccountType_AfterUpdate() Me.OrdersSubform.Form.UnitPrice.ColumnHidden = True Me.OrdersSubform.Form.TradePrice.ColumnHidden =...

You're a star! A will look into this now. Thanks a million. James.

Ah sorry John Big Booty, Does this make a big difference then? Apologies again :o, James.

Well I am having a slight issue on this as it is just running from a query which gathers its data from another query. This was going to be a later question as I need to know how to refresh the 2 queries on formload and when the form and subform data is inputted. Sorry I'm just not very good at...

Hi there, Thanks for the info. It is still displaying all of the 3 fields in question in the subform and also taking the UnitPrice and not the relevant fields i.e. TradePrice or DIY Price. I have attached a screen shot to show you what I mean. Thanks again.

Hi john, THanks for the reply. I have tried the following code but it doesn't seem to be working: Private Sub AccountType_AfterUpdate() Me.OrdersSubform.Form.UnitPrice.Visible = False Me.OrdersSubform.Form.TradePrice.Visible = False Me.OrdersSubform.Form.DIYPrice.Visible = False Select...

Hi All, I have asked this on a few occasions but I am now thinking it is not possible. I am trying to only use certain fields in a subform depending on what is selected on a mainform combo. Can anyone please point me in the right direction. Thanks James.

Hi there, The name of the combo is: AccountType The code that doesn't seem to be working or at least creating wierd results are the 3 queries which are shown in this thread: Query1, Query2 and Query3 If you selected Query2 then in the Products table the TradePrice field will be...

Hi there, I did try the AfterUpdate or Click event but nothing is working, it still picks up the UnitPrice and changes the Trade or DIY price to whatever the unit price is for the item. Can't work out why at all. Please help. Cheers James.

Thanks Lagbolt for your help. Still no joy. I am really struggling now so if anyone can help me sort this out then I would really appreciate it. THanks again for anyone looking and helping me to try and sort this nightmare out. Cheers James.

Sorry but it is a long question: I am using MS Access 2003. In a Form called: Orders I have a drop down combo box as shown below: cboAccountType Account Trade DIY If you select Account from cboAccountType I need to pull the following fields and add...

Thank you so much, it works a treat. THanks a million, your a star. Cheers James.

Thanks a million, I will redo the DB and see how I get on. Cheers James.

Hello all, I'm after yet more help if I may. I have a ship address which includes a field called: ShipRegion from a table called tblOrders I also have a field called Freight on my form (frmOrders) What I would like to do is gather the information from the ShipRegion and place it into...