Search results

Re: Macro - Crashing infrequently Oh I like the sound of that, rather than having a folder of log files everywhere. Will do a lot more indepth research.

Re: Macro - Crashing infrequently On a side note: I swear the people who use this stuff don't appreciate how much effort and hours of coding is implimented into each one.

Re: Macro - Crashing infrequently Thanks VBA. At present I have injected the simple one into problematic codes (as a stop gap) I want to eventually create one which will create log files/error files like yours when it occurs so I can then trace them easier. I will begin testing some of...

Re: Macro - Crashing infrequently Yeah... also half of the posts have been deleted/disapeared I did ask a mod to move/rename it.. something funny has happened as your post is at the top now :O

Re: Macro - Crashing infrequently Okay, brilliant, the code works perfectly without the setfocus. Will try implimenting that to users and test the system to see if any problems occur

Re: Macro - Crashing infrequently Hi, Cheers. I will try to remove ALL focus code. See above, I added the notes from the person who wrote the code

Re: Macro - Crashing infrequently Even thought I am in the change event for SearchFor and the code is setting the focus for SearchResults A totally different box? This isn't my code of course, but it looks as if the Setfocus code is used to swap between the Searchfor (text box) and the...

Re: Macro - Crashing infrequently I only used a basic Error Handling so have no more details regarding the error than this. The only code is in the SearchFor box. the search function works as follows it has 3 boxes. Text Box - Searchfor (users type the search criteria on here) Text Box -...

Re: Macro - Crashing infrequently Houston.... we have an error code. Error code 2110 Microsoft Access can't move the focus to the control SearachResults. So it looks like it is having trouble updating the search results listbox.

Re: Macro - Crashing infrequently Cheers guys, will check out both Sample DB's when I can (Zip blocked at work)

Re: Macro - Crashing infrequently Hi, I got my Error handler in the code without braking it. now I just need to test breaking it (any idea?) Private Sub SearchFor_Change() On Error GoTo Err_SearchFor ' Initialize error handling. SEARCH CODE HERE Exit_SearchFor...

Re: Macro - Crashing infrequently Thanks... I am still trying to get my head around the error handling but the links you provided me are good. Tried a few examples but couldn't get it to work. I will though.

Re: Macro - Crashing infrequently Thanks. I have some planned downtime on Wednesday to make these changes. I want to get a fully understandable grasp of Error Handling and impliment that at the same time.

Re: Macro - Crashing infrequently Right... thats a new one... (never had that suggested) I will do some major edits to it as the name field does have spaces in it, infact quite a few fields do. I'll underscore them instead.

Re: Macro - Crashing infrequently Hi I do appreciate that and wasn't hurt, I've been around long enough for little jokes not to bother me :p To answer the questions. I will try, the problem is I have been unable to break the DB myself. Users do it no problem but It seems random...

Re: Macro - Crashing infrequently Thanks VBA and this is what I am working on at present, the moment I can work out and impliment error handling I can try to trace it. I just didn't appreciate Rains sarcasm, Especially when it is evidented I am clearly new to the whole Access/VBA thing.

Re: Macro - Crashing infrequently Hi Rain... Well if you read my first post you'd realise the error is occuring when typing into a "search" box... As per the screenshot above and this new one bellow I will put it as simply as possible... Person typey where Blue box is and blue Error box...

Re: Macro - Crashing infrequently so if I am using this. 1 Sub|Function SomeName() 2 On Error GoTo Err_SomeName ' Initialize error handling. 3 ' Code to do something here. 4 Exit_SomeName: ' Label to resume after error. 5 Exit Sub|Function...

Re: Macro - Crashing infrequently Absolutely, and highlight it in yellow, problem is I am unable to replicate the error in Access Dev. I even sat for 3 hours typing into the search bar to recreate it and was unable too.

Re: Macro - Crashing infrequently That'll be my fault, I've never used Error handling before VBA (only been using Access for a month or so) And as for typing, well one example is at the top, it crashed when typing WA however it is random, any names can cause it.