Search results

Hi MajP. The attached db is already fresh-build. I thought my form was corrupt but rebuid it did not help. May you please digout further from clue that the error does not happen with short-criteria filter string?

wildcardstr = " like '*" & str & "*') " The wildcardstr is with a SPACE at its end, so it is OK

Oh, sorry the attached file was with "short-criteria fillter string". That is why no error. I have re-attached the correct DB file . Please help to take a look again

Yes, I tried it. I found that assigning bookmark on mainform causes subform's on-current event fires. That's why I said it is very strange/weird behavior. A question is, why does it not happen when reducing filter criteria string...?

Please apply type "ABC" in the search box first, then you click on #2, #3 record of filtered result.

Dear everyone I have been struggling for 3 days to debug but only narrow down some clues... I have a mainform and a continous subform, they act like split form. Main form has button to filter out records on subform, and when user click on a record in subform the main form will show current...

Appreciated so much for your suggestions, I just simply dont know about Application.SetOption "Error Trapping". It seems to be what I need. Let me try it out.

Yes Yes, like ebs17's comment, I want Access stop at every error code so that I can jump into it and investigate in detail. My Error handler mostly consists of "Resume Next", thus I disable error trapping to try catching all unforeseeable errors.

Hi all I have many forms and modules in VBA code. My code usually has a line in comment mode like 'On Error GoTo ErrorHandler thus, this error handler is temporary disabled during the code development. Now, I want to replace above line by using a compiler switch such as #If DEVMODE Then #Else...

The fresh FE gives no clue to indentify the user opening FE... that is the point, sir

Not so clear what you mean, but the case is user selecting "remember me" on login form for the 1st login, next time they will not need to type username & password again. This looks impossible if a fresh new FE is downloaded from server...

Hi Isladogs, Same FE file is downloaded from server to local (user's) computer everytime user start the application, thus how and where to store these login data?

Kind of lazy to handle an extra text file, many thing can be happened with that file which is outside of Access db

Hi Pat, I distribute same FE to 2 different teams: R&D and purchasing team. They have to login in with given username & password, this login form has "remember me" feature which is store on local table. If the FE is downloaded from server everytime user clicking on the shortcut, then"remember...

Changing BE extension looks great trick. btw: How do you hide tables in BE? If someone has BE PWD, will he be still able to access BE hiden tables? Thanks,

Hide Navigation menu, Hile acToolbarNo, Disable SHIFT key. Anything else, PAT?

Dear all. I have structure (type) in VBA and an array Private Type Item_property Itemname As String ItemMaterial As String End Type Dim ItemArray() As Item_property And I expect to init ItemArray like: ItemArray = { ("Knife", "Steel"); ("Ruler", "Plastic"); ("Ring", "Gold")} but It...

Ah... not every keystroke make data change, ex arrow keys. So the change event is the best to use

I just realized it, yes, it does search when paste data by mouse.

Hi @MajP I have applied your code to my application, it works and help to avoid the error 2185. However, I would prefer a blank window on my subform if filter returns no record. So in my case, i found a solution that is moving the searchbox to parent form and apply filter like...