Search results

I have a standalone form with buttons on footer section. I would like to use it as subform too. So when it plays role of subform, these buttons will be move up to its header. it becauses the mainform already has some buttons at bottom of screen while I dont want many button at screen bottom. I...

Dear all Can anyone help to move control Txt_ID from Header to Footer section with VBA code of button Btn_MoveCtrl? I tried with Move method but it is only moving within a section Private Sub Btn_MoveCtrl_Click() Txt_ID.Move End Sub Thank you

Yeah, you're right. We were on wrong debugging direction with that given weird error msg.

Hi Majp. Thank for your valuable time of debugging. At first, the problem is solved. We found the issue on post #19 Yeah, my vendorID is random number, I dont want increament number as if someone see that they can estimate how many vendor/customer I have in system. The local language...

Yeah, I already changed my query like that, so there is no potential issue if we add new field on TBLVENDOR in future. Howeverm abit concern, if a table on network db has many fields, getting TBLVENDOR.* might slow down performance while i just need few fields. Right? In fact, my project has...

I did not say it is Access's error. Post #20, @Josef P. has mentioned it too, developer makes a wrong SQL on filter string, however Access does not notice error when applying filter but it only noitice when we change current record on subform. It makes we not think the problem comes from...

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.