Search results

Oh, sorry I thought you meant whether we should prefer HKCU or HKLM. I'm not an expert on this and going off the top of my head, but I believe you're correct that you can't guarantee HKLM will be generally manageable without elevated privileges. As to how to achieve that, usually the...

Is WIA deprecated? That'd be too bad, that's a nice library. As for ActiveX, I wouldn't count on anyone developing one. COM is considered old tech these days - not much new being done with it (all we can do to hold on what's there now...)

Nope. HKCU it is, where we can (exactly for that reason). My module allows you to specify any of the hives, but generally with in-app reg settings we're working in CU anyway (otherwise LM hive work has a natural tenancy to be better fitted for installer packages, where it's more expected to...

While we're at it, here's a quick module I came up with a while back for some basic reg tasks via VBA. It worked surprisingly well (I've re-used it numerous times since then). Name the module 'Registry' per my usual two-part naming convention Could probably convert to VBScript easily enough...

Does this value need to persist across application sessions? (e.g., if you close Access and re-open it, do you want a fresh count, or keep the prior version?) A few thoughts: - If you're trying to count the number of imports, just keep an import log and log the import (and date of import)...

Glutton for punishment, eh? Been a long time since I worked with VLC in Access/VBA. 5 years or so ago the ActiveX was reasonable well supported, and even then documentation was hard to come by. More recently in .NET, but not so much with streaming. If you're familiar with .NET at all, it may...

Generally speaking, yes. One thing we have to do a lot of in .NET is mapping. Map db fields to DTOs, DTOs to domain models, domain models to view models, etc. Gets old after a while, so you start looking at automapper tools. Anyway, this is actually out of the scope of MVC itself (remember...

Here's a demo of the DevExtreme data grid. Telerik has a similar one as well. Use the nav on the left of the page to see demos of different modes and features: https://js.devexpress.com/Demos/WidgetsGallery/Demo/DataGrid/Overview/jQuery/Light/ You can see the datagrid configuration options...

Hello, The MVC pattern is very popular for web development (for good reason: it suits it very well). That said, it's not the easiest thing in the world to describe, but I'll give it a go: MVC = Model View Controller Model: contains data (like a recordset, sort of...) View: contains the actual...

Regarding "regular" macros, I wouldn't bother with most myself, and skip right into VBA. Macros are ok for those that don't know VBA, but if you're going to do anything with Access, you'll eventually need to learn some basics of VBA. The AutoExec macro is of course helpful to call startup...

jdraw has one back in post #14. Data macros are stored as XML: you can open the macro editor, ctrl+A to select all, then paste into notepad++ to see (or vice versa). I had actually created a DM editor for one of the Wrox programming books using the fact that they're XML based (see attached)...

For SQL Server, we have a drop-in stored procedure that handles all the auditing. For every schema update, we run EXEC audit.Reconcile and it goes through the whole works and sets up all the necessary triggers and shadow tables (including updates to existing tables). Took a while to iron out...

Triggers in general (be it SQL Server triggers or Access data macros) are really in a class of their own. They're very easy to use for all the wrong purposes, have little few right ways to use them, but for those right ways to use them there's nothing else that can replace them. Auditing...

Never knew these things had a name, but I like it.

Some queries are Updatable (meaning they can more or less act just like a table: the values can be updated and the underlying table(s) are likewise updated accordingly). Some are not. It depends on how the query is written... certain operations, such as grouping and displaying counts, would...

Not really sure what you're asking... typically you don't do a calculation in a table (some later versions of Access allow it, but it usually shouldn't be done: it's in place to help support one of their attempts at web database and definitely falls into the "just because you can doesn't mean...

Shouldn't be an issue. The VM should be picking up on the host machine's connection by default, so whether or not it's wifi shouldn't make a difference. (note: there is much that can be done with advanced network configs in VMs, and again a grain of salt because I don't use Macs much, but if...

While I have a fair amount of VM experience on PC, I have very little on Mac (none past emulating mobile apps with Xamarin, actually). That said, I know numerous people who are "big hitters" so to speak and Parallels is what they use (and also being an Apple product itself, it might be less...

I thought Parallels was the goto for Mac VM platforms?

Yup. Yup. Yup. :) (I had edit my answer to state that a bit more explicitly right around the time you replied, but yes... in any programming (most any language), be it field name, table name, variable name, etc - best practice is generally to start with a letter of some sort (or in certain...