Search results

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 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.

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...

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...

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...

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...

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...