Recent content by Pac-Man

This is your organization account and policies are set by organization domain admin. I had used two such accounts in the past, for one account it was mandatory to register MFA with authenticator app on first login while for second, only password was sufficient.

Have you checked in account settings/security info tha MFA is not active?

I didn't check by renaming the .accde to .accdr but I used /runtime switch to check on my computer and it had showed the issue and that is how I come to know about the problematic location of the code. I cannot reproduce it as the issue seem to be resolved by rebuilding the database (perhaps...

I recreated the whole db from source code using version control and this problem seem to have resolved for now. Sorry I missed to mentioned that my FE is accde. Didn't check with accdr.

Thanks all for the reply. Yes Clients do not have full access. I tried on my pc with full Access and it worked flawlessly and then I installed runtime and it had shown the issue. I also replicate the same behaviour on other pc having full Access and it work flawlessly while not in runtime on the...

Hello, Hope you are all in good health. I am facing an unexpected issue. FE of my application is being used two locations where both locations have different encryption password for their Access BE database. I'm using following code to update password in the FE when rhe file load. First it...

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...