Search results

Thanks Guys - Cracked it. Its not a large number, just a number as a double. I thought large number was for a decimal. Woops. Its just a number, formated to two decimal places. Awesome help on this forum!! Crash101

tblTE_RiskPercent_dbl has following properties and it comes up as 0.00 even though it is formatted as 0.00 with 2 decimal places. Format - Fixed Decimal Places 2 Input Mask Caption Default Value 0 Validation Rule Validation Text Required Indexed Text Align So it is a Large Number. However, if I...

@GPGeorge yes that works as a currency. Seems strange that it does work as double even with 4 decimals etc. Any other ideas with making it work as a number with 2 decimals?

Everyone, I have a very simple data value. This is 0.01. Here the immediate printout: TradeSetNo: 1 TradeNo: 1 CurrentBalance: 200,000.00 TraderID: RiskPercent: 0.01 Generated SQL: INSERT INTO tblTradeEntry (tblTE_RiskPercent_dbl) VALUES (0.01) So it appears to be working. However when I...

From a physics perspective, force is force and you would be correct. However, if when you put hydrogen dioxide together all the properties that it then demonstrates due to the effect of that lone pair to make it the perfect media and substance that does all of the things it does is remarkable...

Ok- so ethylene molecules are standard and everything is equal. Water isnt as of this 105 degrees. the causality of this angle is significant. This provides the mechanism of hydrogen bonding that makes it different to ethylene. this makes it highly polar and its liquid is heavier than its solid...

Hilter was a narcissist for sure as well as a drug user after 1941. The scarey thing is that if the nazi party was not so narcissistic the outcome of the war would be different. If Hitler had not gone to the aid of Italy, they would have succeeded capturing Moscow before the winter arrived. The...

The Doc Man - water is odd because its not 120o. The lone pairs push the hydrogen atoms around a bit. I think it is something like 105 sh from memory. If it didnt do this water would not behave like it does. Fluke, chance, its a wonder fluid for sure.

Thanks for the warm response. Yes, it wasnt the plan to put up access directly on the Web, more to sort out how it was going to work in a trial. Any advice on putting up a robust web DB would be warmly received. At the moment we are going through Word Press and using Maria DB as the back end...

If you consider water, there is a hell of a lot of reasons that it shouldnt do what it does, however it is a remarkable substance all caused by the 120 odd degree effect of its lone pair. As for a deity not having consciousness outside a body who knows. I find the neat organisation of things...

Bob - I hope you have a great Christmas and New Year!

Bob - thanks!!! That solved it. Something simple. Thanks for your time!! Crash

Gents and Ladies, I am educated and believe in God. I struggle with some religious concepts around God however. Looking the remarkable way that science and how so many things are inter-related, it seems highly improbable there is no God. Life as we know it only accounts for 15% of what is known...

Jgnore the error on start... you can open up frmTradeEntry. Cheers for your time in Advance. If you look at the first click on the Radio Button, it works, then when I do it again, it takes 2 clicks. thanks Alex

I have a form that has a text box and whether the text box has a value present it makes the radio button visible. Now on the first selection, it takes initially 1 click to select the Radio Button, after which it takes two. Does anyone know how to make it only one? I have a number of text...

Hi everyone - I am developing an access database before I put a database application on the web, just to make sure that I have everything working with the right structure. I have used VBA in excel for years. However, have just bit the bullet to get my head around VBA in Access. My first...