Search results

Created one main form contains a SubForm inside. There is two buttons on the main form, indicated by a) Save button b) Refresh button This button will insert data through the insert SQL string into seperate MS Access but under the same server before the data is displayed on the SubForm...

Wonderful solution. Simple statement.

I have created a subform, inside the subform, there are few columns, say columnA, columnB, columnC and columnD. In the actual table link to the above subform, there are extra one field, columnE or fieldE which is not shown in the above subform. columnE or fieldE is a number field. Default value...

Thanks MissLing for your advice. My questions are as following:- 1) I notice if the cursor is moved away from the textBoxA, the event textBoxA_AfterUpdate will be fired ONLY. It means the event textBoxA_BeforeUpdate is NOT fired although the textBoxA is null or empty. I have amended my code...

Are you saying adding extra event (as below) to the previous codes ? I added above code, it doesn't fire the event although the textBoxA is emtpy

Thanks. Simple coding and it works.

Problem remain even with Me.textboxA.SetFocus

Below is the sample code I have written What is the right way to show the cursor focus to the textboxA ? I notice the cursor show the focus to the object in the next tab index In the VB or VB.Net, I often write in this way. How abt the VBA ? Any advice

After few tries, with the few right combination of codes and in right sequence, my SubForm is working fine now .Share my finding in case some of you face the same problem in the MS Access 2000.

I am solving my problem with below temporary codes which I think is not the professional way Anyone can advise a better way ?

I notice something today, after the button SAVE is pressed and immediately I click on the SubForm, SubForm will show the latest info. Can anyone suggest something why this happen and how can I set the cursor focus onto the SubForm ?

A system is built by using the MS Access 2000. Inside a main form, there is one subform, one SAVE button, one REFRESH button and one text box. When a value is keyed into the text box, user will press SAVE button and theoretically, subform should reflect the immediate result with latest info in...

I am looking for the built-in menu come in Ms Access 2000, I cannot detect any a) Unfreeze pane - Already found. b) Filter For - Check the attachment below menu from the MS Access 2000. I have a subform which I prefer to use the built-in menu to control or filter data rather than hard code...

Thanks for your answer, how about question 2?

Subform - Freeze Pane and Filter For Menu 1) How to freeze pane a subform ? 2) How to display the "Filter For" menu ? I can see the menu at design mode, when I have set the form under the Start Up, the menu cannot displayed.

I have detected the problem, I should include the ResetSubForm under the Form_load event. Anyway, thanks

Press Shift key, don't release. Double click the file and wait till the whole thing is COMPLETELY loaded. Look for the form frmProduction_Schedule

Thanks for the advice. Master Link and Child Link field is set nothing, I don't use this. You also mention filter which I do not have the coding too. You can download the code I've attached above. I have comment the recordsource, it is same as earlier. Any other advice ?

No problem. Focus to the form name frmProduction_Schedule

I have tried, it doesn't work. My new code as below I notice when I press the button, the subform is refresh with data, however, in less than 1 second, the subform become empty again. Why ?