Search results

This isn't a self-assigned index. Access assigns indexes automatically based on the values under Options | Object Designers | Autoindex on import/Create, which as by default set to: "ID;key;code;num." Thus, any field that contains one of those text strings will be assigned an index by Access...

Well, actually, I think what you said about it being a corrupted index would explain why it's a single field that has problems, instead of the entire record. Since each indexed field has its own index, then that would explain why a single field has the issue, if it is only that field's index...

Thanks for that. I'll give that a try. I'll note, though, that this is an intermittent problem. Over the past years, we've been getting it once in a while. Then we went about 8 months without an occurrence. Then, last month, it started happening maybe once or twice a week. So this is just...

Thanks for the insights. The fact remains, though, that I don't think keeping Word open would work for me, since sometimes the document is opened in Word for review and possible printing; other times (as in this case), it's created in Word, exported to PDF, and then Word is closed. So, since...

Interesting. I hadn't heard that before. BTW, on a different topic, I just posted about a different issue. If you had any insights into that, it would be appreciated. Thanks!

Why would the size of the Access back end affect the amount of memory available for Access and Word?

This is true. But most of the time the users generate Word docs from Access, and then review them and then save and/or print them and close Word. So that might not be feasible. Also, wouldn't that tax system resources? These users are running with 8 GB of RAM, so not a huge amount.

So, occasionally we get the "search key not found in any record" error (error 3709). This usually happens when a particular field in a form is updated, and the record is attempted to be saved. The assumption was that there was a corruption in the back end. So we do a Compact and Repair on the...

Thanks for the notes. I don't think that's it. But I think I figured it out, as well as to why it's only happening on certain machines and only sometimes. The process involves opening Word, creating a doc, closing Word, then doing the same with another doc. These were previously two standalone...

Yes, I'm using late binding and Word is installed on all machines. And, as I said, it's an intermittent problem.

George: Yes, it certainly sounds like a VBA error. But I added code to all the error handlers involved in the process so that they identified the procedure the error was in, as well as the section of the procedure. This error was a generic error message, which led me to believe it was a system...

Seems I can't win! I don't mention a cross-post, I'm told to mention a cross-post. I mention a cross-post, I'm told not to cross-post. Sheesh! I copied my reply to you to post #6 because it applied. But simply because both you and he made the same statement doesn't mean the information you...

The purpose would be to see where the error is occurring, and, thus, be able to address it. Right now I've got a mystery "Object Required" error occasionally popping up in the middle of a process, and only on certain machines, and I don't know which line is causing it. The users are using the...

Anything that happens in the system outside of VBA. The form and report On Error event procedures handle these. In the past I've logged the types of errors that the On Error event traps. Some examples are: Your network access was interrupted. To continue, close the database, and then open it...

The built-in Form_Error and Report_Error error handlers are great for trapping system errors in caused by form or report code. But what about in a global module? Is there a way to trap system errors within a global module? (And, just to be clear, I'm not talking about the standard On Error...

Thanks everyone for the replies. I found a solution that works for me by the awesome Albert Kallal, as noted here. This is a very simple solution that only requires putting a couple of DLLs on the system, and everything else is handled with a few lines of VBA code. So, a very clean, simple...

No, the controls aren't in Access. They're in the HTML file. Access is simply hosting the HTML file in the web browser control. I mean, maybe there's a way to use it programmatically by setting the text box values and activating the button. And if someone knows how to do that, then that would...

OK, I downloaded the sample app and took a look at it. I see that it makes use of an html file "index-merge.html" that does the work, allowing the user to select files and click a button to merge them. Very cool! Unfortunately, I need something completely under the hood, done exclusively within...

ha! I didn't notice it. It's late. I'm tired. LOL OK, thanks! That looks like it might work.

How so?