Search results

You've talked about tables and columns but not described nor shown any of them in your responses. In that environment, it's difficult for anyone to know what might have happened, nor to guess at possible reasons for the problem.

I thought about suggesting a full text index on this field, but like Tom said, I'm not convinced it would be all that helpful in this scenario because it's intended for a different kind of problem. It couldn't hurt to try, if only for your own learning.

It's easy to miss the importance of the distinction between date values and date formats. Arnel alluded to that in post #2 in his explanation of how to address the problem, and Minty further explained in post #7. The key point is that Format() does NOT change the date value stored in the field...

Having done some work with PowerApps for smart phone and tablet environments, I can tell you the main reason we don't write our apps to work on smart phones is that--except for some really simplistic applications-- their form factor and screen size militate forcefully against that approach. Your...

This could be one of those times a small repo database with sanitized data could be useful in helping diagnose a problem.

Somewhat different contexts, but I get the point. I've used a hammer to decommission ancient hard drives before disposing of the obsolete computers they were in. More than once, though, I've been delighted to find a backup of a file last used 12 or 13 years ago on an external hard drive. On...

Ah, a developer after my own heart. You just can't have too many backups.

My first thought would be to consider differences in ambient lighting between the two locations. I know I get different effects from closing or opening the blinds on the window behind my desk. Probably not as great as you describe, but definitely noticable.

Perhaps, if you want to use Adobe Acrobat to convert PDFs to PNGs, a good starting place would be the Adobe site. https://www.adobe.com/acrobat/hub/how-to-convert-pdf-to-png.html

What exactly have you tried so far? Do you have a copy of Adobe Acrobat 9.0 already? Have you investigated whether it even has that capability? VBA is a Microsoft Office product. Does Acrobat 9.0 even use VBA?

Winner.

I don't have direct contact with the MS Access team any longer. With all of the other priorities already on their plate, I don't think I'd try to insert this particular initiative into their plans anyway. I'm also skeptical that adding such a guide would make all that much difference anyway...

As I said, there have been many such attempts to provide guidelines for designing and building normalized relational databases, some brilliant, some less so. I bet a search right here at AWF would turn up more than one. The problem, as I see it, isn't a lack of written guides. The problem is...

A guide? Not a document as such. That's actually beyond the scope of the charter for Microsoft templates in general. We went to some trouble to provide a consistent Relationship Diagram for the Developer version because otherwise it's generated in the muddled state typical of newly created...

What theDBGuy was referring to: https://learn.microsoft.com/en-us/sql/tools/bcp-utility?view=sql-server-ver17&tabs=windows

Well, the crash is locking the database, so it makes sense that all are impacted the same. I qualified my comment about the problem by saying "if" it is caused by shutdown of a laptop. So that's not a definitive consideration. Rather, if a process is being interrupted during a write operation...

Ah, if the problem is that undisciplined users shut down their laptop without first closing any open applications on it, the only solution I can think of is a bigger stick, figuratively, of course. A mandatory training session could help. Passive aggressive behavior, unfortunately, is hard to...

Reading previous responses along with this observation, I'd like to call your attention to what appears to be the primary cause of the problem. "Crashing" the database application. That will invariably leave a dangling lock file and can cause other problems for your users. Your strategy needs...

RegExp is now on this computer. M365 is 32 bit.

Getting V1 produced by an AI LLM is fast. Bug-fixing V1, V2, V3, V4, and V5? No so fast.