Search results

As noted, i up-voted your response. However, say I'm using Azure as my database, well it's being updated and patched all the time for you, and your software that uses Azure in most cases will require few updates. And same goes for having written web based (public facing) web sites (it's what I...

Yes, but it works the other way around – the end user has to start the remote session, not that you can! (and I don’t think any customer would give you the ability to remote into their computer). So, this works like “goto my pc” or “Team Viewer” or many of the other “support” systems. The...

Ok, first up, I’m a bit confused by all this talk of patches, updates etc. At the end of day, one wants to: Sell, and deploy some software to users. Such users don’t care about backups, patches, etc. They JUST want to use the software – nothing more, nothing less. They will NEVER had to deal...

Don't think windows ever included an extra windows license. Only exception was back in windows 7 days when they included windows xp mode (a vm to run older software). The other case was windows server editions- they allowed 2 free vm's for the one standard license (and they still do now to my...

At one time, I could recommend this idea - not anymore..... However, I can think of a few cases, where I have run a server OS. So, I had a server OS setup for SharePoint services. This was of course during time when Access “web services” and “Access web publishing” of Access applications...

Well, actaully, if you leave the solution exploer tree open, then in most cases, a live connection to SQL server does exist. And in fact, since about SSMS 21, OR 22? When I'm restoring a database, I now OFTEN have to close the explorer tree right before the "restore", else I receive a message...

Ok, long story short? You need to turn this into a SQL view. SELECT DISTINCTROW tblProducts.ProductID, tblProducts.ProductName, tblProducts.vatCatCd, tblProducts.dftPrc, tblProducts.itemCd, 0 AS RRP, 0.16 AS VatRate, tblProducts.Sales, tblWarehouse.WHID, tblProducts.taxAmtTl FROM tblProducts...

The issue(s) of a persistent connection doesn't apply nor effect nor help when using SQL server. The persistent connection works due to eliminating the time for windows to grant op-locks, and switch from single user file mode to multi user file mode (and to create the. Ldb locking file). In case...

Good for you! - glad this works. As noted, when working with a Access database, and doing things like a dsum() etc. on the data? You REALLY but REALLY want to build a expression that high-speed indexing can be used. Since this "goal" was going to increase the complexity of the expression...

Above is handy, but it's not able to use indexes. So this much depends on how large the table in question is....

Ok, so we want to "sum" a column called "Covers" from a table called "tbl_Net_RestaurantBookings", and pull based on a column in the database called CheckIn. so, the format is thus this: =DSUM("some column to sum","the table to work on", "[ColumnName] = "#some date#") So, you do not want to...

I just installed SSMS22 on my laptop (an older one). It seems to run just fine (loading wise is same, or even somewhat better then SSMS21). To be fair, SSMS (recent editions) is perhaps the slowest loading application I have!!! So, my current laptop? 4ghz, 6 cores, (12 threads), 24 gigs ram...

Thanks for having us, and hosting us here. Looking forward to a great new year, and sharing more fun and things here!!!! A merry Christmas to all, and all the best in the up-coming new year... Regards, Albert D. Kallal (Access MVP 2003-2017) Edmonton, Alberta, Canada

The above is not correct. If you use the before update event, you should be free to modify or do whatever you like. You most certainly do NOT want a me.dirty = false in either of these events........ So, before update triggers - but not yet done. That/this is a excellent place to do some...

Indeed - and the technique I outlined handles that case quite will. And for those not aware of what a "short circuit" means? It means that when you write a "compound" if/then statement, then 2nd (or more) parts of the conditions are NOT evaluated, and are skipped if the first (or previous)...

A great suggesting. In fact, I often try to avoid "nesting" if's too deep, EVEN when a "set" of conditions are requried. In other words, even with a "case" statement not appropriate, I still try to avoid nesting. You can do this by "reversing" the conditions. So, say this: (no need to...

The above is not quite true! If you use a accDB (non complied) application then YES the above is true. However, if you use a compiled accDE, then the above is NOT the case. In fact, any un-handled error will NEVER re-set local or global vars. Hence, we always deploy a accDE. Thus, even...

Yes, it is differrent. Keep in mind, that you suggesting benefits arise that the form now does not have that binding information. However, all you done is move that developer workload to another location - you STILL have to do that work! Remember, I do a LOT of web development work now, so I...

So, how about another example? Well, again, software industry was maturing - but then the smartphone came along!!! And again, huge doors opened up, as many business now wanted and could use some app software (for building inspections, for delivery, for taking on site pictures with quoting...

Actually, no! If you building desktop software, then Access STILL remains a great choice!!! Access is not really fading in terms of what it can do for a given business. The simple matter is that area of the industry has matured, and thus it means LESS investments are going into desktop...