Search results

  1. A

    Is there any kind of local setting that can override a date/time format specified in a table?

    Finally able to check the guy's machine (he was on vacation). From what I can see, everything in the Date and Time settings is identical to my own PC.
  2. A

    Is there any kind of local setting that can override a date/time format specified in a table?

    Will do. Always annoying when this stuff comes up, since IT insists we all have the same build and setup on our machines
  3. A

    Is there any kind of local setting that can override a date/time format specified in a table?

    Thanks for the response. So, this single user could have some kind of regional setting on his computer which doesn't include a time component?
  4. A

    Is there any kind of local setting that can override a date/time format specified in a table?

    This one sounds a little odd, I know. I have a table in an Access 2010 db, in which one of the fields has Date Type 'Date/Time'. The format for the field is 'General Date, which includes a time component. The field is auto-populated when a user enters a new record. Of the 26 users, 25 have...
  5. A

    Solved "Operation must use an updateable query" but only sometimes

    Thanks. I've found a workaround for it, but have no idea why it's working when the previous method (which has been in place, unchanged, for over five years) has started throwing up these errors. The original method had Db.Execute followed by a SQL statement which included a passed variable...
  6. A

    Solved "Operation must use an updateable query" but only sometimes

    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.
  7. A

    Solved "Operation must use an updateable query" but only sometimes

    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...
  8. A

    Solved Capturing the fact that a user has entered a string ending in a space

    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
  9. A

    Solved Capturing the fact that a user has entered a string ending in a space

    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...
  10. A

    Solved Capturing the fact that a user has entered a string ending in a space

    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.
  11. A

    Solved Capturing the fact that a user has entered a string ending in a space

    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...
  12. A

    Solved Capturing the fact that a user has entered a string ending in a space

    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...
  13. A

    Solved Capturing the fact that a user has entered a string ending in a space

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

    Solved Capturing the fact that a user has entered a string ending in a space

    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...
  15. A

    Solved Unable to find most recent example of a record

    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...
  16. A

    Solved Unable to find most recent example of a record

    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...
  17. A

    Solved SaveAs not erroring, but doesn't appear to do anything

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

    Solved SaveAs not erroring, but doesn't appear to do anything

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

    Solved SaveAs not erroring, but doesn't appear to do anything

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