Recent content by iampaul

  1. I

    Combo box - dropdown not dropping down

    Thanks Switching the focus did not work for some reason, but the send keys statement does. For anyone else reading this, the syntax I used is: SendKeys "{F4}"
  2. 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...
  3. 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...
  4. 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...
  5. I

    control to be visible with only first member of group

    Problem solved. Have added a invisible text box with a running sum across the group. Have then made boxes visible if value in text box = 1.
  6. 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...
  7. 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)...
  8. I

    2 seperate sub forms on one form

    Not sure that would work as I need to be able to see both forms at the same time.
  9. 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?
  10. I

    returning key and text of specific nodes in tree / treeview

    It is indeed. Thanks alot.
  11. 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...
  12. I

    Select case statement and controls

    Thanks SJ. Exactly what I was after.
  13. I

    Select case statement and controls

    It is, but I may move it to a class module. That is why it currently reads: forms!frmMain. ... rather than me. ... I just wondered, seeing as the only difference in control names is the 1 or 2 at the end, if there was a simpler way to write it. Seemed I was decalring alot of control...
  14. 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...
See more
Back
Top Bottom