Search results

I'm sorry to hear you have trouble installing the AccessDiff 15 day trial. I've had the product installed since around 2007 and found it very useful for comparing versions of mdbs and accdbs for clients whose applications I worked on. On my computer, the latest version I have is the 2013...

Doxxing is a term for the practice of publishing personal documents about someone in order to cause harm in some way. It's used by political activists a lot, for example.

I'm sure someone with deeper mathematical knowledge will be along soon. I'll just reiterate that running both versions on a representative data sample, and comparing the resultsets could be helpful. Create both functions in SQL Server, with names that clarify how rounding is applied. I think...

It depends a lot on how precise your calculations need to be. I'm no mathematician, but I do know that rounding your inputs prior to operating on them mathmatically is going to yield different results than rounding the output at the end. I'd try it out on a good sample of your existing data...

Along those same lines, I recall an installation at a client site where the "network guy" had actually draped the Cat5 network cables over the top of a fluorescent light fixture instead of going to the bother of putting it above the ceiling tiles. When the lights were turned on or off in that...

Now that "email address" sounds a lot like someone we have all known for a long time, doesn't it?

Ron has shared a link to a presentation I made last month. I should note that after that meeting, I encountered a limitation that might be a show-stopper for anyone interested in going down this path. Specifically, one of the tables in the database I used has two Long Text fields. I had...

I have a tool that can do a side-by-side comparison of two accdbs. It's called AccessDiff. It is a paid commercial product. I used it regularly when I was still working with client databases and needed to compare versions during development.

Unfortunately, using Multi-Value Fields is not a great solution. I am not as adamant on this point as some, but I would strongly recommend against that, especially at this point, where you are just starting out and have more appropriate options easily available. Post #21 mentions junction...

Thanks, "Bruce"

Several of you us have difficulty recognising toxic content. Fixed it for you.

This is an apocryphal story. Having recently moved into a house in a new neighborhood, Mark and Karen were eager to meet their neighbors, so they decided to have a house-warming party. All of their neighbors were invited. As the guests arrived, most commented on the way Mark and Karen had...

Whether this diagram represents an appropriate design depends on how you need to track the data. Are you ONLY interested in an employee's Position, Shift, Assignment and Training TODAY? Do you need to keep track of an employee's current AND prior Positions, Shifts, Assignments and Training Do...

Irony is the art of expressing outrage when others mirror one's actions.

That's true. I was conflating this thread with another one where the OP was talking about customers.

This is an extremely important point. You have roughly 3 years to identify, develop and deploy the replacement for so-called Classic Outlook. Probably less than that as you can't count on your customers all waiting until the last possible moment to adopt the New Outlook just to support your...

Hm. That interpretation hadn't occurred to me. It's equally plausible, perhaps even more so than my own initial reaction.

No, New Outlook does not support COM automation. You can not send email from Access to New Outlook because of that. There are alternatives, including reinstalling what they now refer to as Classic Outlook. You can explore other options here: and here

"The forum can do anything they want with it.". That includes deleting them. 😉 Jon, as the site owner, has good an sufficient reasons for his management decisions. Far be it from me, at least, to question those motives or decisions.

That depends on what you mean by "running across it in Access". Importing data from a Web API is one place where you'll find it, a lot. And so on. Where to find VBA tools for JSON: https://github.com/VBA-tools/VBA-JSON