Search results

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.

Hi, I want to print a payment receipt whose width is 3" (width of the paper roll in thermal printer) and height can vary from 3-6". In access I am unable define custom paper size and page size is set to A4. See the following image in which I tried to present a an A4 paper in portrait...

Thanks a lot for the help. I'm truly thankful for the help. I'm trying to replicate it in 26.3 will update here if I'm able to understand the code and adapt it. Thanks again for your precious time.

Hi, Sorry for late responding. I checked the demo light load is much faster than full load (big hand for @MajP). However there is a bit of delay when expanding a node in light load that is understandable that it load the nodes. One thing more, there are different number of child nodes on...

Thanks a lot @MajP for your time and effort you put into it. I am on Eid holidays and don't have PC to check till next Monday. I'll check it and inform you as soon as I check. If it works so much fast for 10k records then it will work for my case faster. Thanks again and God bless you.

Thanks a lot. Meanwhile I'll try myself too.