Search results

  1. 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...
  2. 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...
  3. M

    Undo changes in sub form

    I have a main form and a subform from 2 tables. How can i remove a field from sub form without deleting from a table?
  4. M

    QUERY OR FUNCTION TO RANK TOTAL MARKS AUTOMATICALLY AS THEY ARE ENTERED

    Hello everyone. I am trying to rank the Students based on the total marks of the subjects being entered. Kindly check attached database. Somebody to help me with a function or query to rank total marks of Students. Kindly check Student Examination Details (from subform). Thanks in advance. God bless
  5. M

    Solved QUERY OR FUNCTION TO RANK

    Hello everyone. I am humbly and kindly requesting for somebody to assist me rank the subjects in the description in the attached database. The query or function should rank subjects automatically as the mark is being entered for students. E.g student A ENGLISH 60, STUDENT B ENGLISH 70, Student C...
  6. M

    QUERY OR FUNCTION TO CONVERT DATE TO AN EXPRESSION

    Hi everyone. I am requesting for somebody to help me come up with a query or a function so that if for example you enter today's date 6/10/2021 it brings TERM TWO. I tried =IIF(Format(Now(), "mmmm")=OCTOBER, "TERM TWO" But I get an error wrong number of arguments. Please help me
  7. M

    VBA CODE OR FUNCTION TO DISPLAY RECORDS FROM COMBO BOX

    Hi everyone. Kindly check the attached database and specifically look at the form. I really need help to find a code or a function to generate records of students doing a particular subject. E g if i select ENG to display students doing ENG, if i select BIO to show students doing BIO only and so...
  8. M

    PREVENT DUPLICATES

    Is there any vba code or a function which will instruct database user msgbox "SORRY YOU CANNOT USE THIS NUMBER BECAUSE IT IS BEING USED BY AND SHOW THE SAVED USER" Thanks.
  9. M

    Solved AUTOMATICALLY GENERATE REPORTS BASED ON MARKS ENTERED.

    Hi. Have a look at the attached database. Check on rptStudentsGrades. Kindly assist me to change it(rptStudentsGrades) to column.(spreadsheet) Please the user to enter marks and able to see reports horizontally not vertically. Thanks.
  10. M

    Thanks

    Pleasure to join
Top Bottom