Search results

We dont know which the form name called formC... since formC is opened from combobox. And my topic goal is to know this form name... Does it require extra work from user? User must to enter a wrong item to trigger NotInList event?

Hi Nifty Therefore the code fails and causes an error when you try to re-query the combo box on a closed form. -->Yes, this is the keypoint of my issue. 1) All of these forms and subforms are within one MS Access front end database used by one person? - One FE, one person 2) you can have many...

Hi Nifty, Thank for making the video, I have learnt alot from your youtube channel. My concern is in the case we have many form + subform (for example FormB1 - subformA1, FormB2 - subformA2...) what employ same combobox Cbx_Footprint. So, in the AfterUpdate event of frmFootprint, how do you...

Hi The Combobox_Click event does not fire when you click on "Edit List Item" of combobox, thus I still can't configure out how to pass the argument "Me.Name" to formC. So, formC does not know how it was opened. This is my problem.

Hi Moke It works in case formA, formB is standalone. In fact, my formA is a subform then the code CurrentProject.AllForms("FormA").isloaded always returns False. Furthermore, It is a bit manually, if later I have formA1, formA2 with same scenario, I will have to add these code again... what I...

Hi Mike That is a working solution. However, formA has servaral Combobox and we rarely edit items on formC thus I personally dont want many redundant requery action of these Comboboxes. (Form may be flashing on requery action as well)

Dear all I have formA and formB that both contain combobox Cbx_Footprint. User can click on "Edit item list" to open other form (formC) for adding new Items. When closing formC, I would like to requery Cbx_Footprint to have latest Items likely: Forms!FormA.Cbx_Footprint.requery However I dont...

Sorry, my typo, I was meaning "duplicate textbox". I have just done my code with your idea, it works as expected.

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