Search results

How to write VBA code to lock or hide a subform field at a main form at Form_Load event ?

I know DCount, how to count the recordset of the subform? Don't mind to show simple VBA code here.

How to write a VBA to determine a subform whether has data or not ?

Wrong or right not so important in life!!! What is MORE important is the system currently work the way I am looking for . Output always overtake the concept. Anyway, thanks for your above sharing. Requery method really do not required in my case. See ya!

1) I wish to have the latest /updated value 2) In order for (C) to run, this is the only way to create unbound control but load all value at run time through the GotFocus event.

Above case is closed after I implement the below a) Use the unbound combo box b) Populate value at run time via the GotFocus event . Read more at here http://www.access-programmers.co.uk/forums/showpost.php?p=908190&postcount=6 c) Remain the application of the recordset

Thanks. Exactly it works as expected. Something new to me as I work too long in the VB and Vb.Net. For knowledge sharing, VB and VB.Net use the click event to populate the value whereas VBA use the GotFocus event. I notice the requery method do not required here. Again, thanks for kind assist.

I notice with or without the requery method, the combo box still can show the latest data when user click on the combo box. However, I am wondering why user have to type in something inside the combo box before VBA can fire the click events under the combo box? Anyone know the reason or any...

I am using Access 2000. I would like to fill up a combo box with values dynamically from a table when user click the combo box only (not at the form load time). I have tried the click and mouse down event, however, none of them work (my combo box still empty). Any advice ? Below is the sample...

The column count is 2, Access version 2000. I can't upgrade to Access 2003 due to limitation in license. How can I resolve this although the column count is already set as 2?

I attach here the combo box property for better illustration

I have replaced above code with following cboDefectGroup = DLookup("Description", "Defect", "DefectCode='" & rsTemp1("DefectCode") & "'") cboDefectGroup.Requery At the debug time, I can see there is a value for cboDefectGroup . However, I cannot see any value on...

Same as before. Error alert.

You have expressed exactly my problem. However, error message alert: Object required. I attach the full source code at below.

No, above is not what I am looking for. There are 2 combo box on my interface. The 1st combo box consists of 1 column and the 2nd combo box consists of 2 columns as I describe earlier. All columns have been filled up with value through the RowSource When user search back the old record, I have...

I try to invisible under the PageHeaderSection via VBA as shown in attachment, however, when I type in "." in order to look for the "invisible" property, I can't get it. Any help? Below is my code. Private Sub PageHeaderSection_Print(Cancel As Integer, PrintCount As Integer)...

As title, how can add button in SubForm as shown in attachment?

There are two columns under the combo box (name: cboDefectGroup) . When I assign a recordset to the combo box as below, no data can be displayed. Below is my VBA cboDefectGroup.Value = rsTemp2("Description")

Same as Group 1. ControlSource : =sum(OutQty) RunningSum: OverGroup You can check the attachment I have just uploaded for better illustration.

Sorry for not able to upload the DB here due to the many link tables and the large DB size. However, I attach few screen shoots n do hope it is sufficient to give a clear illustration. Let me know if you need further info.