Search results

I have written a basic query that looks at the date field, department field and cost the cost field on a table. What I would like is a form that you can chose a date (19/09/2005) and a it looks at the table and calculates the total sum of money for each department for this date. Ie. Date...

I have a tabular form for a sales database. i.e: Product Qty Cost Cherry Coke.........1...............0.95 Diet Coke............1...............0.95 Sprite.................1...............0.55 Cherry Coke.........1...............0.95 I want a command button to open...

If you are unable to post please email to Danian.Wallis@ntlworld.com

colmoore Can you post the database so i can view what you have done. I am working on the same sort of projuct and would like to see what you have done. D

I am trying to make a Sales Transactions and Stock database I have so far created a Transactions form that when you scan the barcode it enters the data in to a table (tbltransactions). What I now require is: When the order has been complete, I would like a button that opens a new form to open...

ScottGem Thanks for the reply. Didn't fully understand where the data need to be put. I have looked at a sample database that you posted a little while ago for someone else. Looking at that database I realise I was not doing what you suggested in previous posts. Thanks for you help and...

ScottGem Thanks for the reply. I have tried what you have suggested but still no luck. I have attached the database for you to refer to. Thanks Danian

Not to sure where to check. I have the following Control Source = Cost (This is the filed i want the data to be added to on the table) EVENT After Update = Me!txtCost = Me!cbobarcode.Column(3) Name = txtCost Tried may different ways but still will not work any ideas...

Scott, I am having problems with the cost textbox. It does not seem to copy the data back to the table. You said to do the following. When i do this it does not seem to do anything. It also does not do a total calculation it just gives #error any ideas... D

Scott, Thanks for the advice. I did what you suggested (point 2). the problem i am now having is that the data that is being put automatically into the 3 textboxes (manufacture,Product Name & Cost)is no longer writting back the the table tblSalesTransactions. Also my Total cost textbox at the...

Here's the attachment

I have a simple sales form (frmSalesTransactions). When I enter a barcode number into the Barcode filed I would like the remaining fields (manufacture, Product Name and Cost) to automatically enter. All the required data is stored in tblProducts. I understand this is done via a Dlookup on the...

I have been playing all day. Here is a little update Problem: I have 2 tbls tblProducts & tblOrderDetails, i also have 1 form frmSellProduct. The frmSellProduct form looks at a field called ProductName on tblproducts which is a combo box. What i require is: when i click on a product name it...

I need a basic Product database that allows you to have a drop down menu to select a product from a table. In turn this puts the unit price in for you, you then put the quantity in and it calculates the total. I also have a stock control. When one is bought it takes the quantity down. Very...