Search results

Hi All, I am trying to do this but, to be honest, do not really know where to start!! Could anyone point me in the right direction? I know the basics of access but not VB etc. I have a quote form from which I select a material (via a combo box) and then type in the quantity required. This...

Hope this makes sense. It doesn't really to me!!! I have some fields in a report which are (among many other's) Quantity1, Price 1, Total 1, Quantity2, Price 2 and Total 2. Total 1 multiplies the quantity1 and price1 together.............and the same for total 2. I then have a TotalAll which...

Hope this makes sense. It doesn't really to me!!! I have some fields in a report which are (among many other's) Quantity1, Price 1, Total 1, Quantity2, Price 2 and Total 2. Total 1 multiplies the quantity1 and price1 together.............and the same for total 2. I then have a TotalAll which...

Hi All. Once again, sorry if this has been asked before. Looked on the forums, couldn't find an answer, and I am sure it is simply and it is driving me mad!) I have a simple form ,simple report and a preview report button to link them. I need the preview button to preview just the active...

Hi All, Firstly, I have tried looking through the forum but didn't really know what to search for. I apologise if it has been asked for (many times) before. I have a form with 7 combo boxes on it (To pick materials from tblmaterials) What I need is for the first combo box to appear when the...

Hi All. Apologies if this query appears in an existing thread. Have looked but cannot find an answer as don't really know what to search under! I have a form with a field called "Handed Over" with a tick box. When the job (record) is "handed over", I have been going back through every job and...

Hi, please excuse me if this is an easy and/or a stupid question. Still trying to figure it all out!! I am trying to do some adding up in a query. What I am trying to do is the following: For Example. I have 4 fields. Item l Quantity l Buy Price l Sell. A 1...

Another "simple" problem. It is ifyou know how to do it! What I am trying to is have a form with say approx 20 drop down boxes on it. Each drop down box will list materials (from a table) that can be chosen. When the material is picked, the price needs to automatically appear. This bit I can...

I am relatively new to Access so please excuse me as I am sure my question is quite simple. I am trying to join information together within a form. For example, I have a table with 2 fields (Materials and Price) I have created a form (form 2) with a drop down box to choose a material from the...