Search results

I would say you are pretty normal, except more honest than some about openly acknowledging mistakes.

The real problem is that you do not provide any information specific enough to interest others in looking into your techniques. Statements like this are both intriguing and frustrating. "The added value is that the database is almost complete automatically generated, independent of any...

I was able to create and use an append query today, after installing updates from yesterday. My installed version is M365 32 bit and MS365 64 bit (Current Channel) What version do you have installed?

Don't let the 1st impression dissuade you from taking seriously the good advice offered. DLast, DFirst, etc. are seldom useful when looking at historical data. In fact, it's hard to think of a situation where they are viable, although I'm sure there will be one I haven't thought of. The reason...

I've often noticed that creating diagrams in remotely hosted SQL Server or Azure SQL can be slow in SSMS, and not just in the most recent version. However, once a diagram exists, it usually loads noticeably faster. The times you mention do seem longer than I'd expect.

For starters, could you post a sample database illustrating the technique? Start with something simple. Show us how it works to get a conversation started. Thank you.

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.