Recent content by mercystone

  1. M

    FILTERING REPORTS

    Kindly, I am requesting anyone to assist me with a sample database with OpenReport method. Thanks. Merry Christmas and Happy New year everybody.
  2. M

    FILTERING REPORTS

    How? Private Sub Report_Open(Cancel As Integer) ? ? End Sub Please help
  3. M

    FILTERING REPORTS

    In a form the filter works perfectly. I am defeated on how to use it on a report.:- Private Sub Command221_click() Form.Country.SetFocus DoCmd.RunCommand acCmdFilterMenu End Sub I now need it to apply in a report so that the user can print only certain names e.g People from New York, USA only.
  4. M

    FILTERING REPORTS

    How are you doing everyone? I have a question? How do you filter a report from a tables which the user entered the fields manually? For example: Name. City. Age John brown. New York. 35 John brown. Oxford. 40 In this case john brown is from usa...
  5. M

    Solved DYNAMIC REPORT FROM CROSSTAB QUERY

    Thank you so much.
  6. M

    Solved DYNAMIC REPORT FROM CROSSTAB QUERY

    Subjects to be 11
  7. M

    Solved DYNAMIC REPORT FROM CROSSTAB QUERY

    If there is a code to hide subjects with no marks then I believe there should be a code to delete the hidden labels with no values and show only those with values. Please help me on this
  8. M

    Solved DYNAMIC REPORT FROM CROSSTAB QUERY

    Exactly what I wanted. Is there any way I could change the subjects to be selected to be 11? Your labels has 24. I wish to be 11 but the subjects should not be deleted. To be hidden just like what you have done but those to be printed are only 11. I believe those 13 labels and there values...
  9. M

    Solved DYNAMIC REPORT FROM CROSSTAB QUERY

    I am using your approach. Thanks. Question- i want a code which will hide subjects if it has no mark. E.g if English has no marks or isnull hide it. Only subjects with marks to be shown.
  10. M

    Vba code or function for Filtering records

    Now after using the main form and subform how will i filter take for example the user has typed Washington in usa. I need a filter to select people in Washington in usa. Lets say Name- Peter Hillary City- Washington Country- USA
  11. M

    Vba code or function for Filtering records

    Assist me with a filter
  12. M

    Vba code or function for Filtering records

    It is already in two tables.
  13. M

    Vba code or function for Filtering records

    tblCountries PK- AUTONUMBER USA CANADA ENGLAND tblCities PK/FK- AUTONUMBER (Cities to be manually typed by the user of database)
  14. M

    Vba code or function for Filtering records

    Reports to be filtered
  15. M

    Vba code or function for Filtering records

    I have two tables. 1. Table for countries 2. Table for cities Out of this the main form is from table for countries and subform for table for cities. In the table for countries, the counties have been entered 1. USA 2. CANADA 3. ENGLAND. In the table for cities the user of database enters the...
Top Bottom