Search results

yeah, it's easy to reprocuded it. Ms Access does not handle this error properly i think

Yeah, as no-experience access user, I am always scared this scenerio, code error cause forms/local tables coruption without knowing. I am not so clear what difference btw compact and decompile. I usually do Cmpact & Close before copy my accdb as a backup. Let me learn to use decompile as...

A side-question, In your modified code: Private Sub User_MainProductShowDetail() Dim rs As DAO.Recordset Set rs = Me.Form.Parent.Form.Recordset rs.FindFirst "[VendorID] = " & Txt_ID If rs.NoMatch Then MsgBox "Unknow Error - No Vendor Name " & Txt_QField1 & " !" End...

Dear all. Solved. With your advices, i followed and found that the subform record source was not table TBLVendor but from query Q_QinfoVendor_Source. And in Q_QinfoVendor_Source, there are no field names: Country and ROCNumber. Access introduces no meaningful msg in that case: Error '3709'...

I was guesting same then I build forms from scratch but same error. Please build the form at your side. Hope you can re-use my data, i suppect the local language characters might make filter work improperly... if so it is my nightmare

Sorry about that, it costs nothing with sapce before "OR"... but this is cut-down version I did not have must time to make it clearer

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