Search results

Thanks. Yes, I found ten different potential causes and have gone through and checked that none apply. If it happened every time, it might be easier to identify, but this is happening with the same queries. Sometimes they run, sometimes they error.

I know there are a whole range of causes for this message. What I can't find is a reason why a given query would produce this error then run without any problems a minute or two later. I'm getting it from different queries which run as part of a nightly refresh. All of these have run hundreds...

Thankyou! I set a global variable using the Change, then stored the final value using the After Update event. So simple now I know how, but it it was driving me mad. Thanks all for the help

Yep. If it's something simple I'm doing wrong, I'll be delighted. Each of the following returned the same for me. Private Sub Keyword_Change() Debug.Print Keyword End Sub and Private Sub Keyword_KeyUp(KeyCode As Integer, Shift As Integer) Debug.Print Keyword End Sub and Private Sub...

You may well be right, but I'm not in a position to refuse to do it, unfortunately. My options are limited to doing what the manager wants or demonstrating why it's not possible.

Thanks MajP and jdraw. On one hand, it's good to know I was thinking along the same lines. However, the same manager shot this down when I suggested it , since (quote) "It's still extra work for the user". I was hoping there was some way to detect the entry before Access 'fixes' it, store it...

This is what I want to do. However, not all the words end in a space. In some cases the users do want to detect something if it comes up as part of a word as well as on it's own e.g. "OVERHEAT" should get hits on both "OVERHEAT" and "OVERHEATED", while "FIRE " should not get hits on "FIRED" or...

Thanks for the reply. I added debug.print Keyword behind both events, but if I enter "test ", both are capturing "test".

I have a form that is used to enter search criteria relating to car warranty claims. One of the fields is an unbound text box that allows the user to enter a specific keyword. The problem I have is that Access removes any trailing spaces from any entered word and there are times when the space...

Thanks for the reply. The data itself had been recorded via a few forms, but I'm looking at a copy of it, so it's not linked to anything. I finally found out the cause, in case anyone else has the same problem. When I sorted the table by the 'Action' field, six records showed up as '#####'. I...

I try to run the following query and get a message "The Microsoft Access database engine stopped the process because you an another user are attempting to change the data at the dame time". SELECT Max(tblActivityTracker_Import.TimeStamp) AS MaxOfTimeStamp FROM tblActivityTracker_Import WHERE...

Thanks. Once I got past the 'save' problem, the process did close as wanted.

Thank you! I knew it wouldn't be something complicated. Works like a charm now.

Yes and yes. I should have said, I can manually create that file without any problems.

I have the following code which I found online in a standalone sub procedure, just to test it out for future use. It's in Access 2010, in case that makes a difference. Dim xlApp As Excel.Application Dim xlWB As Excel.Workbook Dim strMasterBook as...

Thanks for all the suggestions. The messages have to go out via email, as that's the company standard when sending anything outside head office. Getting them to switch to IMs or anything else would mean getting a policy change implemented and we'd be talking six months or more, if it happened...

Until VERY recently, the people receiving these emails were still insisting on faxed communication. IMs aren't even on the horizon.

I figured I might be clutching at straws. Thanks for the detailed answer.

Thanks, unfortunately it's VBA