Recent content by dalski

Or Frm Design > Alt-Enter (Property Sheet) & pic'd. Good to use prefix same naming convention cboMyComboBoxName. I also like to rename txtBoxes with txt prefix to differentiate between the actual column names used as the data-source; just makes it clearer.

No it was a good post thanks KitaYama, sound OS related to watch out for Win 10 here if any of us come across a similar issue.

Not an ideal solution as really wanted to detect the error from a view. But what I did was run a stored procedure on a single record on the form in the before update event. If the error is raised in SQL Server using no try/catch I'm able to detect SQL Server's error 8154 (overflow) & then run...

Exceeded 1,000 char limit :ROFLMAO: & the above is only a fraction of what I've tried. Conclusion Thus Far I think the problem is related to batch statement parital completion & an implicit select transactionmaking it awkward. Sure I can easily avoid this by using a trycast() but that is not...

WARNING - this is long - get a cup of tea then begin reading :coffee:. The question is as in red above. I firmly believe that the answer is not in contacting Intel to build me a bespoke processor or computation algorithm, but to validate data by something like checking if the view has an error...

Thanks guys, Doc I changed the ctrl's to BeforeUpdate to call the data-validation fn & Me.Undo occurs there now avoiding a write if data-validation is not satisfied. AHeyne that's helpful thanks. I've managed to make that block redundant now & avoid loosing the current record by only...

Sorry guys, after struggling several hours & shortly after posting I think I've found a solution. In the AfterUpdate of the ctrl's call a function to do data-validation. If data-validation is satisfied then Refresh from the ctrl's AfterUpdate events to reflect changes, else if data-validation is...

My form is based on a DAO.Recordset, a dynaset based on a table & view on SQL Server with the recordset.Restartable = True. The join is done in the queryDef of the recordset of the form where the view is a calculation. Two important controls determine the outcome which sets the opposing ctrl...

Thanks Doc, I appreciate your candor & don't disagree I have a problem. I agree I do not need an additional scaling algorithm... Given the complex formulas & math done in Excel I certainly think this is possible & I appreciate Ron's guidance to stay away from floats. A miscommunication I think...

Thanks both, dear lord this is too much for me I struggle with basic addition of two numbers 🤮. I'm trying my utmost to reduce precision with decimal. If rounding worked before let coercion then I think I'd be ok to use float but the inaccuracies terrify me. I appreciate the external library...

Thanks Ron, I understand what's causing the error. I can't see much on googling Numerical Methods. I'm pretty sure my basic math is correct; if I need 9,999,999.999 in a certain column; multiplying/ dividing through several others with increased scale the numbers quickly get big. Maybe I need to...

I need high calculated columns with high-precision & scale Decimal types in Views/ SP's in SQL Server. As the calculations go through several layers of high precision with multiplication/ division operations the precision requirements are huge. The problem is sometimes big numbers will be...

Thanks guys, DbGuy it seems an input mask will not round/ truncate to nr of dp's spec'd in the mask. If there are more dp's in the stored value it will display more dp's > than spec'd in the mask. Thanks Doc, that's interesting & very useful to know. Ken, oh I like, I like very much :love...

Very nice solution, thank you Doc, this isn't well documented at all, an expert technique from you there I think, for others I used below. I left the change event so the user can enter more than 4 dp's if desired but is not burdened by many dp's on selection. Private Sub CtrlName_GotFocus()...

I'm having to work to many decimal places in my SQL Server BE & want the user only to have to enter 4 decimal places in the control. Much higher precision is needed for calculations... & the calc can populate the data in the BE which is fine. Restricting what the user sees is easy with the...