Search results

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

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

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

Simple math: 1/1.95: In Excel, formatting cell to 16 dp & counting on screen the dp's I get 0.5128205128205130 Online Calculator I get 0.5128205128205128 In Sql Server using SELECT CAST(ROUND(1/1.95,16) AS DECIMAL (28,16)) AS WTF I get 0.5128200000000000 I'm lost for words :unsure:.

I have a SQL Server BE with table design as pic'd: Access can display a Decimal Type to 28 Precision (overall significant figures), to 16 Decimal Places BUT the spec of DP's have a maximum fixed value of 15 it seems ; so playing it safe I have dimensioned the design as 15 dp's; resulting in...

I've converted the BE to SQL Server & a previous listbox is causing the above error. I've removed all event associations with the form & commented out the code in VBA but I still get the prompt. It is strange that it is only this listbox (where there are many other controls on the form) which is...

Following this thread; I am trying to find the best execution plan to remain fully recalculable & benefit from caching with fast indexing for calculated columns. If I nest views I can index the first view (great) but any subsequent views thereafter loose the ability to index child-views as an...

Q1 - Why is the simple ID1 clustered index (PK in Test1T) & regurgitated in the view (dbo.vw_TestIndexView) not indexable? Q2 - A Non-Persisted Calc'd Col (in tbl) needs meet criteria below in order to be indexable as a non-clustered index; assuming true for the Total Calc'd Col: a -...

Think of an Orders Table where the Total is calc'd & value is not stored. I think I'm right in saying "only a column's data can be encrypted in SSMS". So it's not possible to protect your math in calculated fields. It also seems that an encrypted Stored Procedures weak-spot is the SP needs to...

Been working on the premise that if selling an .accde with an Azure db managed through SSMS 22, you can restrict important info/ stored procedures/ tables/ queries... from the customer. I imagine through creating different users/ schema's... creating an admin user account & encrypting data/...

Have many experienced this? I'm not talking about through Access or Query performance, I mean the actual application SSMS22 itself is extremely slow. Through Access is quick but I'm working in SSMS most of the time converting the BE for Access. Seems there are quite a few complaints with the...

Will the specification of the Decimal data-type apply to all calculations wrapped inside the Decimal data-type & each calculation inherit the accuracy specified by the parent Decimal type (26 decimal points in e.g.). I'm hoping it does because I have complex calculations which I do not want to...

In Access I used a composite index of 2 fields, but unsure best option in MSSQL for performance to avoid a duplicate record of the combination of the 2 fields? In the child table (relevant to topic) I have a foreign-key & a normal field. I think I have 2 options? Composite Index like in...

EDIT - On closing & reopening MSSQL the changes have taken effect fully. I can handle the 4 FK constraints manually; that's no big deal but would appreciate if someone can help in doing this for PK's? After importing to MSSQL I want to convert certain FK's/ PK's data-types. So need to drop all...

Silly question - how does one determine the existing join-type between a table-relationship from the Diagram-View in MSSQL 2022? Also can't see any indicators in the Table-Design itself. There seems to be a bug in double-clicking the relationship line does not open the relationship (articles...

Can anyone recommend a good book exposing common pitfalls...? I'm a complete novice in both Access & Azure. Seems that using an ODBC connection in MS Access exposes passwords... in the registry.... Also as I still have not finished my application which I am planning to sell as an .accde & Azure...

I have Option Explicit & Option Compare in ALL code behind forms, modules & classes. But I receive no highlighted prompt where the error occurs. I thought I'd solved it a week ago but I keep receiving it on compiling. Pretty sure it's not reference related as I've not changed anything there...

Built a simple testing form; in a separate db to obtain what the keys should be As per Richard Rost. Trying to assign KeyDown/ KeyUp the form itself one or the other: Seems ctrl-delete = Keycode-46 & Shift-2 Frm - Key Preview = Yes The KeyUp event is detected but I cannot generate/ detect the...

How does one protect against multiple records being selected on a subform? Current Event - if multiple records are selected it will not recognize Record Selectors Property - would be handy if it had a collection of the currently selected records but does not seem to have Situation The subform...

On math heavy queries what is the best way to handle titled? Was advised that other db systems would fail on a calculated field which obtains it's value from a calculated field defined in that query. So I'm not doing that. In an ideal world this makes it much easier but I will want to use MSSQL...