Search results

Tom thanks so much, Rest API's are awesome! Anyone have an idea what is the best way to implement? Obv's needs to be encrypted. Is it a case of just having an encrypted users table with a different cypher for each user at an encrypted url. Or a case of a different encrypted path for each user...

Thanks Tom, I was a little worried about brute-force attacks & sql injection... I have not built a website yet & was hoping Azure would have these tools built in for 2026 & suprising they don't. You can set a range of IP addresses for dynamic IP's but only our lord knows what them ranges would...

Thanks for persevering with me, appreciated. So what is the solution in managing users online (restricting unauthorized people) using my Access FE? A Uses table in Azure like helpful thread would have been good but Azure only allows Private IP addresses through so I would run into a problem with...

Thanks Tom, using network names instead could be a good idea. I see benefit in applying 'helpful thread's logic of an external users table hosted on Azure & accessed by the FE but concerned with customers having a dynamic IP address & Azure's firewall, blocking existing customers because their...

Thanks George. :ROFLMAO:Difficult to bypass license manager. I'm pretty sure SSMS is required locally to access tbl's, SP's, Vw's... My competitor uses this method & I had to set it up with SQL Server Express (at three different companies). Occasionally having to go in there after creating an...

I'm new to App Development & the titled is quite terrifying as a noob. Reading the helpful thread with valuable contributions from @The_Doc_Man, @isladogs & @Ken Sheridan. I am trying to make it as difficult as possible to use my Access FE at a reasonable price. We all know Access is not the...

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