Search results

It provides print preview for a different student

Error 3075: Invalid use of vertical bars in query expression 'StudentID IN (11|)'.

I thought it is common sense Command48 is PRINT SELECTED INVOICE as the title and the image attached?????

Kindly assist me note those errors that is why I came to this forum for assistance

Enthusiastic amateur I like your name but you have not assisted in anyway.

Hello everyone. I have a slight problem. The following code does not fire to print selected records in invoice. It is supposed to filter the selected records and the studentID Private Sub Command48_Click() Dim sFilter As String On Error Resume NextDoCmd.CLOSE acReport, "INVOICE" sFilter =...

Very true. Thanks.

Hahahahhahaaaaaaaaa. It is very true. Thanks. I like this forum.

Hello everyone how do I use dlookup in a report to refer to a numerical field in a query. When I used the following it gives me the date value 31 December 1899 =DlookUp("classrank","qryRanking","STUDENTID=" & [StudentID]) Kindly assist me. It gives me a date 31 December 1899

Hello everyone. I am humbly requesting on how to create dynamic search from a form to populate records in subforms. The records should be shown as you type or when you click search. I have the following subforms from different tables. 1. Tblstudents 2. Tblyears 3. Tblgrades 4. Tblterms 5...

🤣🤣🤣🤣🤣🤣🤣 Okay.🙏🙏🙏🙏🙏🙏🙏🙏 Thanks

This database works very fine. However, I want to create a main form from tblstudents and subforms being 1. frmStreamStudentssubform. 2. frmTermStreamssubform. 3. frmTermSubjectssubform. 4. frmSubjectExamWeekssubform. Thanks in advance 🙏🙏🙏🙏🙏

Thanks @Pat Hartman

I am using your improved database @mike60smart as advised by @Pat Hartman

True. There is a problem with tblTeachers it says "related record in tbl teachers." Just seeking advice. What if I create a junction between tblTeachers and tbltermsubjects and also another junction between tblstudents and tblTeachers and tblDormitories. Please advise. Thanks in advance.

Thanks so much. I appreciate. I had also modified and it is working fine. Thanks @mike60smart and @Pat Hartman I really really really appreciate 🙏🙏🙏🙏🙏🙏🙏

@Pat Hartman I apologize from the heart. I am really sorry for my previous comments. I am very very very very very very sorry. I hope I am forgiven. I have realized that you had no ill intentions. Thanks @Pat Hartman for going an extra mile assisting me with a sample database. I really really...

Thanks @mike60smart I appreciate

@Pat Hartman I used @mike60smart database by slightly changing his idea by creating the main form- from tblstudents. With that I have several subforms:- 1. tbltermstreams. 2. tblyearterms. 3. tbltermsubjects. In tbltermsubjects I am able to use teacherID to show a certain teacher teaches a...

Thank God we have @mike60smart and @arnelgp in this forum. They are doing good work and many people appreciate their efforts. If you really wanted to help me you would have screenshot your schema.!!!!