Search results

  1. M

    Query to promote students

    Thanks for your input. Relationships should be as follows One to many. 1. One year to have 3 terms. 2. One Grade to have many Streams. Grade in this case Grade is Class. How do I represent those relationships in referential integrity? Thanks in advance.
  2. M

    Query to promote students

    Noted. I am still new in Ms Access. Thanks for your input.
  3. M

    Query to promote students

    Hello everyone. Kindly I am really requesting for assistance on how to promote the students every January every year. Kindly look at the attached database. Please I am defeated. I have tried Append Query. Please kindly assist me.
  4. M

    Query to promote students

    Thanks so much for your input
  5. M

    Query to promote students

    There are so many tables tblStudents included. I might have overlooked but I thought those are the only tables needed for promotion of students
  6. M

    Query to promote students

    Thanks for your input
  7. M

    Query to promote students

    It is one Grade to Many Streams e.g GEADE 1 NORTH GRADE 1 SOUTH GRADE 1 GREEN GRADE 1 NORTH GRADE 2 SOUTH GRADE 2 GREEN AND SO ON. Also a year has 3 TERMS E.G 2023 TERM 1 2023 TERM 2 2023 TERM 3 There is no way a a term is related to Streams.. Also I have a feeling that it is Update Query...
  8. M

    Query to promote students

    Hi all. I am requesting for assistance on a query to promote students on January every year. Kindly look at the attached database. Thanks in advance.
  9. M

    Solved If single then Null otherwise keep selecting value

    Thanks. This also works🙏🙏🙏🙏🙏🙏🙏🙏
  10. M

    Solved If single then Null otherwise keep selecting value

    Fantastic. You are genius. Thanks so much.
  11. M

    Solved If single then Null otherwise keep selecting value

    Funny 🤣🤣🤣🤣🤣🤣🤣🤣. No harm intended🤣🤣🤣🤣🤣🤣🤣
  12. M

    Solved If single then Null otherwise keep selecting value

    If I don't put the value it gives error because the two tables are related. This is what I get "YOU MUST ENTER A VALUE IN IN THE TABLE "tblStream.StreamID" field. That is why I use "SINGLE" implying "SINGLE STREAM" or "ONE GRADE". In a Report there is no need to show "SINGLE" because it is ONE...
  13. M

    Solved If single then Null otherwise keep selecting value

    Only value "SINGLE" should not be displayed because the school has grades which are only one streamed so there is no need to say GRADE 4 SINGLE, it should only show GRADE 4 in the Report
  14. M

    Solved If single then Null otherwise keep selecting value

    I get #Type!
  15. M

    Solved If single then Null otherwise keep selecting value

    Hi everyone. I have two related tables:- 1. tblGrades. 2. tblStreams. The two tables must have values. By default tblStreams should have "SINGLE" implying single stream. My question is HOW WILL I MAKE IT IN REPORT "SINGLE" not to be seen. In the same tblStreams other values are NORTH SOUTH...
  16. M

    Solved VPA to change from 64 bit to 32 bit

    SOLVED. THANKS EVERYONE.
  17. M

    Solved VPA to change from 64 bit to 32 bit

    I found this code somewhere. I hope it will work. 👇👇👇👇👇👇 Private Declare PtrSafe Function FunctionName () as long If VBA7 Then Private Declare PtrSafe Function GetKeyState Lib "user32" ( ByVal nVirtKey As Long) As Integer #Else Private Declare Function GetKeyState Lib "user32" ( ByVal nVirtKey...
  18. M

    Solved VPA to change from 64 bit to 32 bit

    Kindly assist me with that example code. Thanks in advance.
  19. M

    Solved VPA to change from 64 bit to 32 bit

    Hi everyone. I created a database using 64 bit. When I use in 32 bit, it can't work. Is there a VBA code to change from 64 bit to 32 bit. If so, I am really begging you to assist me. Thanks in advance. God bless you all.
  20. M

    Solved Print selected invoice

    Thanks @arnelgp Your code works perfectly. The problem was PaymentID and not StudentID. Thanks so much @arnelgp God bless you so much.
Back
Top Bottom