Search results

  1. I

    Combo box - dropdown not dropping down

    On selecting a certain value in a combo box, I would like to re-populate the combo box with a different set of values (different SQL record source) and make it automatically drop down. It all works fine except for droppign down again. I believe it is to do with the fact that the combo box was...
  2. I

    Can I query a DAO recordset

    Is it possible to query a DAO recordset once it has been created in VBA. Currently I create a recordset and use it for a few things, but It would be useful to be able to run a few more bits of SQL against it to check some other things. The table it is created from is large and it takes several...
  3. I

    docmd.copyobject not copying form module

    I have an application that copies forms, repots and queries from the current database to another database. I am using the code: Select Case strObjectType Case "Form" DoCmd.CopyObject strDestDbFilePath, strObjectName, acForm, strObjectName Case "Query" DoCmd.CopyObject strDestDbFilePath...
  4. I

    control to be visible with only first member of group

    I have a report which has a number of group headers. The detail is sorted on 2 fields. In the detail section section i have a number of rectangles which will form check boxes for users to tick on a paper report. I only want the boxes to be visible on the first record in each group. Does...
  5. I

    dynamic form - datasheet view as subform

    I have written some code that creates a dynamic datasheet form which is based on a crosstab query. Can anyone tell me how I would go about using this form as a subform on another form. Is it possible to 'mount' it on a form which was created in the usual way (ie manually in form design view)...
  6. I

    2 seperate sub forms on one form

    Is it possible to have 2 sepaerate sub forms, with different source objects on a single form. I thought it was, but every time I save the main overall form, the source object of the second subform changes to the source object of the first. Can anyone shed any light on this?
  7. I

    returning key and text of specific nodes in tree / treeview

    I have a treeview control with 3 nodes, at 3 different levels and with one node at each level. I am able to return the text or the key by looping through them like so. For Each Node In ctlTree.Nodes MsgBox Node.Text MsgBox Node.Key Next Is there a way to return the...
  8. I

    Select case statement and controls

    Is there a neater / simpler way to write the following, bearing ni mind that fro case 1 the control is called ....PF1 and for case 2 .....PF2? Select Case intPfNumber Case 1 Set ctlList = Forms.frmMain.lstPF1 Set ctlTree = Forms.frmMain.CtlTreePF1...
Back
Top Bottom