Search results

vbaInet, once again you have come to my rescue and provided excellent support, thank you very much :) If your'e interested the Control Source for the total now looks like this: =IIf([DiscountOption]=1,[SubTotal]*(1-([discount]/100))+[courier],[SubTotal]-[discount]+[Courier]) All thats left...

Found it and got the 2 different option boxes linked :) Working on implimenting your code for total into my database now

It wasnt appearing on your example, but now it is working. The database I am working on is 2000, is the example you gave me achieveable in this version? I have been running yours in Access 2003 and the db I am working on in Access 2000 side by side and I cant seem to get the same effect. I am...

vbaInet, thanks for the example, that looks like something that would fit the needs of the system. The only problem I had was that the subtotal and total values were not appearing for some reason so I couldnt get a complete idea of exactly what was happening

It is not so much an extra discount, just an option to choose between wether the discount is recognised as a % or as a £ value. I have been looking at the calculations and the way the database works and it seems like it is asking too much to have an option to choose between the 2, since pretty...

Ghudson, I dont quite follow what you mean by suggesting that I print the SQL or how I would get the system to check for nulls The values have already been globally declared so this is not an issue.

Currently the subform allows you to choose different items and add them to a list. When an item is added to the list the total price is updated and displayed on the form as 'SubTotal' (Subtotal is never recorded as a value, just as a calculation based on the items added to the list). A discount...

vbaInet, I have just realised it is you helping me out again :) Yes, the subtotal is calculated automatically already based on the data selected in one of the subforms. A disccount then needs to be entered and a Total calculated from the subtotal and discount. The next stage after the discount...

How would that work with getting the value entered in the text box? Please talk me through your though the process you are suggesting Ultimately the discount would have to be converted into a % in the calculations since the total would be worked out using sub total and dicount (%).

SOS, thanks for that advice. I have been having a play around and the error seems to only occur when one of the fields is not entered. Is this something that is never going to work because the way the INSERT INTO statement is written its checking for ALL values? Or is it something that can be...

I am working on a database which requires an invoicing system. Sometimes a discount is including in the invoice and ideally this discount should be entered as either a % value or a £ value. I have given this quite a bit of thought and haven’t really managed to come up with a practical solution...

I am getting the following error: Run-time error '3134' Syntax error in INSERT INTO statement This is the piece of code I am directed to: Private Function addSuite() If suiteName = "" Or Description = "" Then MsgBox "Please enter a name and description for this suite!" Else If equip1 = ""...

Gemma, you are an absolute life saver! I looked at that code for ages thinking it was some massively complicated error somewhere deep within the code and turn out it was something as trivial as that, haha. Thank you very much! The 'GoTo' button now works perfectly as intended :D

I cant give you the code for the combo box since the error is occuring before the wizzard even finishes so I cant actually get a finished Combobox

What code do you mean? And is this what you mean when you ask about the selected value?: 'Record_Number' is actually of type 'AutoNumber' (I didnt realise this origionally) which for some reason is typically a 5 digit number in the 30,000ish range (starting at 31,069) with the following...

Haha, yeah quite a lot of this database is badly designed and coded and I'm stuck with cleaning up the mess, despite my complete lack of experience with VB. I tried what you duggested and created a combo box and chose the 3rd option in the wizzard (Fine a record on my form based on the vlue I...

I was wondering if it is possible to have a drop down box where you can select a list of options but at the same time be able to enter a value manually without having to choose from the list. Currently I have a drop down list when I click on the box and if you try and enter anything manually...

Hey, I am currently working on a database which was made by someone who is no longer contactable to help and my VB is not great. Basically within one of the forms there is a 'GoTo' button, which when clicked prompts you to enter a 'Record Number' which is not as simple as being an autonumber...

Also, missinglinq, the code you gave me to Form_load sub was causing an error because I didnt realise that there was already a Form_load sub defined in the code. I was creating a second Form_Load sub rather than adding to the one that was already there. Also the reason I couldnt right click on...

Thank you everyone for the help with this problem, it seems to be working nicely now :) Special thanks to vbaInet in particular for the lessons in VBA and putting up with my complete lack of experience, lol