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

Paul, Thank you very, very much for your quick reply. All working OK so I can now continue!! Will go away and look at the NZ() and LEN() function. My books are at work and, to be honest, they are new to me!! Once again, thanks. F.

Sorry Paul, Me Again. The Total 1 or Total 2 value doesn't appear when the value is 0 which is great.....but!!!! TotalAll is Total1+Total2 but I just get a #ERROR if either Total1 or 2 has no value. I am really really sorry to be a pain but I have been chucked in the deep end at work. Thanks...

Paul, Thanks for that, it works a treat. Just one other thing. The CanShrink option for Total 1 and Total 2 are set to yes. Is there a way of making the field blank if it is zero? I have searched the forum's for "visible" but found no threads that are relative. I don't know VB so am lost...

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

Sorry, just realised I have put this in the wrong forum!! Yes I am a plonker...... Sorry.

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

Nice one, thanks for that. Will give it a go. F.

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

Thanks for both the replies. I will try it out later. But............ "Finally, me thinks your database is Un-Normalised. You might be better off normalising it" Excuse my ignorance but what does "Un-normalised" mean? As in many others, still finding my way round access. Thanks in...

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

Imo, Didn't realise the form had to be open!! Now all sorted. and again, and again, and again....... thanks for your help!!!! Foster.

Hi Imo, Thanks for the example and your help. As per your reply, I have created 2 queries, 1 for true and 1 for false, as in your example. When I run them, I get a message box appear which asks me to "enter parameter value" If I put in 0 for true and -1 for false it works fine. You do not...

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

M.O.P, thanks for your reply. What it needs to do is 1) add up the totals for each item. A Buy=£2.00 Sell=£3.00 B Buy=£1.00 Sell=£2.00 Then 2) add up the total buys Buy=£3.00, Sell-£5.00 and then 3) take the buy away from the sell. The reason for this is that I also need to have the...

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

Cheers Fella's. Work a treat. Much appreciated. Foster.

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