Search results

  1. M

    Solved DYNAMIC REPORT FROM CROSSTAB QUERY

    Thank you so much.
  2. M

    Solved DYNAMIC REPORT FROM CROSSTAB QUERY

    Subjects to be 11
  3. 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
  4. 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...
  5. 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.
  6. 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
  7. M

    Vba code or function for Filtering records

    Assist me with a filter
  8. M

    Vba code or function for Filtering records

    It is already in two tables.
  9. 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)
  10. M

    Vba code or function for Filtering records

    Reports to be filtered
  11. 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...
  12. M

    Undo changes in sub form

    C I could do with the attached database. I am still new in access and I am defeated in the implementation
  13. M

    Undo changes in sub form

    Noooooooooo. I am still new in ms access but this forum has really helped me.
  14. M

    Undo changes in sub form

    Noted. Thanks
  15. M

    Undo changes in sub form

    Kindly use the attached database and assist me by updating
  16. M

    Undo changes in sub form

    To get the term i am using this ="TERM " & ((Month(Date()-1\4)+1 And to get the year i am using this =Format(Now(), "yyyy") But I am considering your approach. Any input will be highly appreciated.
  17. M

    Undo changes in sub form

    Or is there any other way to refer to last term results if: Term 1:- January, February, march and April Term 2:- May, June, July and August Term 3:- September, October, November and December. I might to refer to last term results
  18. M

    Undo changes in sub form

    Good input. Actually I was having an impression that it will be hard to refer to last term's results. I tried using: =DlookUp("[Total Marks]","qryGrades","[ID]="&[ID]-1) But it gives me minus the testdate. I think your suggestion for a fourth table will be very effective.
  19. M

    Undo changes in sub form

    Kindly assist me us Ing Kindly assist me by using the attached database on how to go about it
  20. M

    Undo changes in sub form

    Thanks. What if I had saved the subject for the Student and this Student drops a subject at some point, will the same code apply?
Back
Top Bottom