Search results

Hi, I have a Subform which has a Source Object as a Query. Dynamically generated report is displayed on the Subform based on certain set of selections. Is there a way I can disable the sorting option (i.e. the down arrow to the right of the column header on the subform). I do not want my...

Hi, I have a combo box (cmbDate) in my form which fetches date values from the Access tables, and the code goes like this: cmbDate.RowSource = "Select Distinct Report_Date " & _ "From Table1 " & _ "Where Report_Date between #f_dt#...

Hi CJ, How I was trying to sort this out is using the code below. The qdf is the Query Definition for my Query on which I am trying to do adjust the column size to the best fit. Dim i As Integer Dim fld As DAO.Field For i = 0 To qdf.Fields.Count - 1 Set fld = qdf.Fields(i)...

Hi, Does anyone know how to adjust the column width of the fields to best fit in a Query using vba codes? Manually it can be done by selecting the Query - Click on More dropdown of the Reports section in the ribbon - Click on Column width - and select best fit as the option. I want this to...

Yes Eugin. I checked and its helpful. But the options in that matrix talk about multiple subforms within forms. My problem is Subform in a Form inside a Form. The matrix doesn't address this.

Thanks a lot John. This is really helpful But, this still doesn't answer referring to a Subform in a Form inside another Form.

Hi, I have a Form called X which contains a subform called Y. I have placed this Form inside another form called Z. There is a CommandButton which when clicked must refer to the Subform. How do I do this? I tried using [Z]![X]!Y, Form_Z.Form_X.Y, [Z]![X].Y but it throws an error saying the...

This is solved. Pls do not reply on this thread!!

Hi Rain, @ Queries - You are right. The backend is a Table. The Query I am referring to is on the Front End. @Report - I am referring Subform as the report. The fields in this subform can be dynamic, i.e., it might have a Date column when a date selection is made & the same column must be...

Hi, I have a Form named 'Opening_Screen' which consists of various objects - Combo Boxes, RadioButtons, Check Boxes which the user can select. There is a subform called 'Report' within the 'Opening_Screen'. The source object of the subform is a query (called 'QueryX'). There is a button...