Search results

  1. C

    Export Data from data query in a subform

    cheers for all above. Will give it a try when back in office and come back with feedback. thank again for help
  2. C

    Export Data from data query in a subform

    Hi I have a mainform and in the header of that form their is a command button to export data to excel. Unfortunately the button does nothing as i have no clue how to execute what i am trying to achieve. WHat i have in the form is the header of the main form, then a subform within the detail...
  3. C

    Command Button Caption Issue

    Hi. Yep that seems to have helped. Just about tweaking spaces at start of caption and between the words. Cheers
  4. C

    Command Button Caption Issue

    If add a space after variety i lose the word variety again.
  5. C

    Command Button Caption Issue

    Hi Apologies for this stupid question but here it is anyhow: I have a header bar with some command buttons on it. Each command button has a picture at top and then caption below. See image 1. I then changed caption from "Add Category" to "Add Variety" and the result is image 2. I lose the...
  6. C

    Query design confusion when in a sub sub form

    Your a star. All sorted now. Many thanks for the above help. ONce followed what you stated above it worked a charm.
  7. C

    Query design confusion when in a sub sub form

    Sorry to be stupid. But which one would be the subform control (object) out of child1 and the sourceobject within it named frm_test
  8. C

    Query design confusion when in a sub sub form

    Ok. Brilliant that makes sense. Couple of questions. My main form is called "Hem Plan" The child form within it is called "Frm_Sub1" The sourceobject loaded in it is called "Frm_Main_Variety" The subchild form within Frm_Main_Variety is called "child12" The sourceobject loaded in it is called...
  9. C

    Query design confusion when in a sub sub form

    Apologies. Here it is
  10. C

    Query design confusion when in a sub sub form

    Hi. I have a main form with 8 buttons on it and a child form. When i click each of the 8 buttons a different sourceobject is loaded in the child form. One of the subforms loaded in this child form (frm_variety) contains within it a further subform (frm_varietysub). The recordsource for the...
  11. C

    how to detect if a sort has been applied using ac cmdfiltermenu

    Hi I have a continuous form that looks like datasheet. I wanted to keep the finctionality of a datasheet column filter so used the ac cmdfiltermenu function in vba. This works great and i have (with the help on here) got code that allows me to detect when a filter is applied once the drop...
  12. C

    How to use a docmd ina command box in parent form

    HI I have a form with a suform within it. I have a command button in the parent form that i want to use to remove sort from the subform. I originally had this button in subform but for look and fell i think best in parent form. Code i am using for remove sort in effect just applies the...
  13. C

    Change colour of picture icons in command button

    Hi. I have created a command button to filter data. Annoyingly person building it for wants the command button to follow a theme of dark grey. Issue is the command button filter logo by default is dark grey so cant be seen,. Is there an easy way to change the colour of an icon or would i have...
  14. C

    check if a filter is applied after ac cmdfiltermenu

    Superb. Worked a treat. Many thanks.
  15. C

    check if a filter is applied after ac cmdfiltermenu

    cheers. so what event do i put that code in?
  16. C

    check if a filter is applied after ac cmdfiltermenu

    Hi i have the following code and it it brings up a filter menu much like in a datasheet filter option. Dim Items As Integer Items = Me.RecordsetClone.RecordCount If Items = 0 Then Me.FilterOn = False Else DoCmd.GoToControl "Txt_Column1" DoCmd.GoToRecord , "", acFirst DoCmd.RunCommand...
  17. C

    acCmdfiltermenu cascading issue

    Hi. I solved the issue. The fix has left me confused but happy it works. The form was originally populated by a record source constructed within the form itself by clicking on the record source button and creating a query. I decided to create same query and save it as a query. I then used...
  18. C

    acCmdfiltermenu cascading issue

    Hi Please find attached demo data. As mentioned in previous posts. Whati want is if i double click the label for column 1 "category" it brings up a filter menu. If i filter just Clematis in the category section i want column 2 when i double click it to only show the filter options that are...
  19. C

    acCmdfiltermenu cascading issue

    Hi. Sorry not understanding your response. Could be my poor explanation. I have sorted cascading combovoxes. It is the inbuilt filter menu I am struggling to cascade in a continuous form made to look like data sheet. I will strip my database out tomorrow and upload a sample database to show...
  20. C

    acCmdfiltermenu cascading issue

    Hi I have a continuous form with made to look like datasheet. It has 3 columns. Category Genus Variety. The following code brings up a filter menu for each "column" when i double click on it. Private Sub Lbl_Column1_DblClick(Cancel As Integer) Dim Items As Integer Items =...
Back
Top Bottom