Search results

Thanks MajP, Chat was wrong & you were correct as usual MajP, Format forced it thank you very much. Hope you're well mate. (y) 0.0000000000000000 Thanks Doc it was a Datasheet.

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

Sorry, please delete. Despite trying many times prior & this exact fix which did not work previously. I removed the data source, saved & reloaded. Then used the PT Query & it works. Don't know why it did not work previously.

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

That's good you saw a change & I'd think this is indicating moreso where the issue is. Maybe try Ctrl-H & manually going through each var individually. That's helped me before with Option Explicit not checking every single var. The problem will be in the FE. As you can see I've had it before &...

Thanks MadPiet, yeah I've read that too, & probably the reason why I've been on it a few days. On a positive spin I'm trying to obfuscate code as much as possible so that's a positive. But it is quite awkward I must admit. I keep looking back & forth.

Thanks Tom, I did check the execution plan's, there were quite a few steps compared to basic tut's I've done, I've spent a good few days researching & nearly finished rewriting with indexed views. I'll test & post results but i only have a few rows. EDIT - I am forgetting, it is necessary to...

I don't think you're getting it @Geirr: EDIT - apologies @Geirr, I see what you're saying; maybe something like below & edit all occurences via Ctrl-H... It is agg; I get what you're saying...

Thanks Tom, I was casting a decimal; probs made a crap job of obfuscating my real code; sorry. The biggest questions I have atm is - 1 - Is there a benefit to indexing a view on an column which is already an index in the table? 2 - Is it worth all the aggravation, trying to separate & nest...

I could be wrong in saying that you're experiencing a lucky coincidence here as you're likely testing in same office company with equipment purchased on roughly same date. If you are not linking to many libraries then with good luck you won't have many errors trying to reference non-mapped...

Thanks yes I'm aware. So if your variables are perfectly declared, inc'd all object vars, classes, types... then this is the next place I would look. Have you designed & built on a different machine. Then you've gone to a different computer & tried to run the .accde. Where the references (to...

I haven't even compiled an .accde yet. But: There must be on-click events/ macro's behind the main form to open the child forms? I'd look there first in code/ macro trying to reference a badly ref'd variable. 1 - Silly question here from me - with below settings right to flag any probs in all...

👏 Seems correct MadPiet. Thanks, I will not store calc'd data for now; appreciate your input. I have no real data in the application yet. In order for me to populate the data I need to build the queries & forms. Because the data is so inherent from different tables I need to build these in or...

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

Lightworks Video Editor

Thanks Sonic, MSN state any expressions within an indexed view (amongst other criteria...) 1 - Must be deterministic 2 - Precise - 'Only precise deterministic expressions can participate in key columns & in Where or Group By..' So I read that as 'if it's a calc'd column it must be deterministic...

Sounds like you're doing a pretty good job so far. Unsure how many rows are relevant (obvs more rows advocates Access). Excel would be easier for me. I imagine you could use dynamic SQL to populate each column & set some sort of mathematical floor & ceiling in conjunction with the random fn. Or...

Not bringing anything new here but commenting for moral support - double-clicking - mine opens in an existing instance (ver-22; but obv's due to file type assignment in Windows). I'm not experienced enough in SSMS to confirm if I've encountered a fresh instance of an application being launched...

Thanks for testing Sonic, appreciated & for your code; I got the same results so good! My concern is that both the MSN article & the Redgate tutorial states that if the criteria is not met then the view indexes (clustered & non-clustered) can produce unreliable results. It's the below that...

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