Search results

Cool, thanks. Fiction? Non-fiction? Other categories?

You might kick off the conversation by explaining what Amazon's "KDP" program is. I take it that it has something to do with books.

The VBA project can be named anything you want. It defaults to the name of the Access database originally. To change it, you can right-click on it in the VBE and enter the name of your choice. I prefer a modest name, usually.

Sometimes, though, sharing a solution can be of benefit to someone else having a similar problem down the road. That's the reason we often request more than simply, "I fixed it." Thank you.

All of that stuff! Often, when trying to trouble-shoot a specific problem, Claude or Chatty start offering additional components beyond the one I'm working on. And at some point, I get lost in a series of responses, some of which are on topic, some of which are looking down the road. It gets...

This illustrates very well my experience with most AI LLMs. Going in, we assume a certain level of context and tend to think that the LLM will share that context. Sometimes yes, sometimes no. The thing is, LLMs lack contextual experience. To explain the problem as I see it, I resort to...

My first reaction would be a shrug of the shoulders. Unless you are critically short of space on the drive where the SQL Server instance is installed, it should not matter. It's not like Access where we have a hard 2GB file size limit. Even if you are using SQL Server Express, it's not that...

I decided to see what Chatty and Claude, a couple of my AI buddies, have to say about benchmarking performance for various database platforms. I figure they should have access to a lot of that kind of research which I don't have without hours of crawling the web. Unfortunately, it turned out...

In Post # 1 you indicated, "We dumped MS SQL Server for MYSQL as relational database due to speed we have been using this MYSQL databases with MS Access as front end and has proved to be reliable and our users like the speed compared to MS SQL Server which makes the speed horrible even if you do...

The inquiry at hand isn't about the names of tables or fields. The inquiry is about datatypes, e.g. like the one in your error message regarding a multi-value field. So, while you resolved your problem by switching from the wildcard to specifying field names, it's still ambiguous about why...

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?