Recent content by Pac-Man

Thanks a lot @MajP, is working fine now. There was a bit of issue that when I open certain nodes (using certainNode.Expanded =True) after loading the tree view, only first node was visible in it. So I created a sub ExpandNode in the JKP Loader class module and in the sub I called...

Hi @MajP, Sorry for late reply. I was out of city for some time. I have check the code, light load is working but there still is one issue. When we expand a node, all children nodes are shown expanded by itself (each with one node). Normally when we expand a node, all children nodes are...

Hello @MajP, Hope you're in good health. I was unable to fix the issue and use light load with jkp treeview. I didn't updated here because I didn't want to take your more time and so started using comctl with light load. But it is a nightmare in case of compatibility. So I came here just to...

Hi, I want to make another similar query. Purpose is still same, get First Class Attended and the last class attended but difference is it should also include those students that are not yet discharged i.e. discharge date is blank. In current implementation, MaxDischargeDate is joined with...

Thanks a lot. I had been trying to do this for two days before posting here. Finally I decided to post here and my issue is resolved in two hours. Thanks again.

Thanks a lot, it is working as desired. I have applied it in my main DB and it is working there too. I do not understand the login as it seems complex to me but I applied it in actual database, use little knowledge of making queries to put other required fields and it works. Thanks a lot again.

What is difference between C1 and C2, they look same and which query do put StudentName etc from tblStudents?

Thanks for SQL, I'll apply it and then let you know.

Thanks a lot for replying and sorry for late response from my end, I was away from PC. I tried with Min and Max, there are two issues that I face, firstly it gives date whereas I need ClassName as pointed out by @June7 and secondly it will give min/max from whole table, not for specific student...

Hi, I have two tables named as tblStudents and tblStudentClass and their structure is as below: tblStudents: StudentID (PK) StudentName tblStudentClass: RecordID StudentID (FK) ClassID (FK; from another table) DateOfAdmission DischargeDate tblStudentClass can have multiple records for a single...

No, i set the page with w: 3", H: 8.3", I set height equal to A4 page's width because height of the print is not expected to go beyond A4 width. Now the printed receipt is only part 1 of the image of my initial post. Now part 2, 3, 4 are not being printed. Sometime if receipt is small in that...

Thanks for reply. I have resolved my issue. I have to define custom page size in Print Server Properties and then that page is available in the page sizes in access report page setup. Now extra space is not being printed. Thanks for the your time and effort to sort me out.

If I could define a page size that is 3" wide in page setup, I guess this might get resolved but I don't know how to do that.

I tear it to separate the receipt and the printer is connected through serial port. Printing line by line can be done but for that I have to learn the printer's programming. Secondly, I don't have the printer myself and I am doing this for someone else. Receipt is being printed okay but the next...

It could be of help to someone else (like me) if you could share how're you doing this.