Search results

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

Appreciate your input Doc, please don't misconstrue my comments as this is in no way personal at all. I'm grateful of the input, much easier to stay silent & let me fall into a pile of :poop:. There are beautiful brains on this forum with like-minded interests & this is intellectual debate...

Sorry to hear this: As @Gasman suggestion you can access Access update history via File > Account > below I know you said rolling back Windows is not an option but just in case; a previous version Another update causing more problems than they fix :mad:. This is so, so, bad, no wonder they...

Thanks George, oh that's surprising. I would've thought it was tightly coupled with SSMS due to TSQL. I would never have thought it independent. So shouldn't this forum be called 'Microsoft SQL Server'; not SQL Server?

Thanks CJ, I was following your lead :LOL:. Or maybe what is meant by the subforum's definition: As I stated in #13; which I believe was correct; it is relevant to SSMS not 'SQL Server' overall. The SSMA wizard linked will only import to SSMS.

Thanks Ron, I look forward to studying that many thanks.

In Visual Studio I enabled CoPilot; was helpful in correcting my errors in C# as half a decade since I looked at C#, & sometimes I couldn't make out what it was doing.

Thanks CJ, not sure that is entirely correct - the video linked was a migration to SQL Server using SSMA wizard (Microsoft Sql Server Migration Assistant); unique to only Microsoft Sql Server; not SQL Server. To generically state SQL Server here I believe would be incorrect as the Migration...

I'm in same position; I actually have not completed my app fully in Access & moved to SQL Server asap & I'm glad I did because the control-flow/ processes are quite different rendering considerable redesign to work in SQL Server; the more experienced here will hopefully correct me if I'm...

Thanks, I may have muddied the waters with 'a compiled procedure', but this is what I meant to #30; I finally grasped the point you were making. At least what I was trying to write anyways :ROFLMAO:.

Thanks all, yes I keep getting told off about referencing SSMS here; I appreciate the persistence in correcting me. I do want to learn correctly so thank you. Ok, having used various versions of the app I am building from several different companies; as an end-user at large companies, an...