Search results

Thanks a lot. Worked like charm

Is it possible to lock a VBA project with VBA instead of doing it manually by going to the Tools menu, select <Database Name> Properties and protection tab? Best Regards

I check by replacing Access.Application but it didn't work. Still looking for a way to open password protected database in new access window (in runtime version of Access) without entering password manually.

Thanks for reply @Eugene-LS but I couldn't check it yet that's why didn't responded the reply. Thanks for reply @isladogs, I have full access installed on the PC and at the same time have runtime 2013 installed on the same PC. Default app is configured in way that accde are opened by runtime...

Hello, I was using this code by @isladogs to open external password protected database in separate window. It works fine in full Access but when gives error for those users who are using Access runtime version. The line of code that gives error is Set App = New Access.Application. How can I...

Thank you so much for your concern and guidance. I understand what you want to say. I'll implement proper method for indicating absent and on leave students. Thanks again.

I also have plan to add another table and related forms to make datesheet (dates of each subject exam) and that could also be used to link result table and attendance table.

Thanks for such detail replies @Pat Hartman and @piano_playr. I didn't know before that avg of 3,03 and 3,Null,3 will be different but yes I was worried about total marks as -1 would reduce total marks by 1. I think I will have to write function to consider only positive marks for getting totals...

Thanks for the reply and link. I have seen your demo before and after seeing that I am using tab control to emulate navigation form as you did. But tab control is working fine in my current setup but the new setup I am planning to make is easily possible with built-in navigation form (if it had...

Pardon me if there is confusion due to my comment. My goal is to show students absent or On leave (by A & L abbreviation) in the result report. That can be done that can be done either automatically based on linking attendance table and result table as suggested by you and @arnelgp or manually...

Hello, I want to create new main page of my app which I want to make like ribbon. I wanted to use custom ribbons but since my app is in Urdu/Arabic language and font supporting good readability of these language is reauired to be applied for labels etc in the ribbon. From this post, it seems...

I mean if I mark student absent by giving him -1 score then total score (SumOfObtainedMarks) will also be reduced by 1 since we entered -1 for MarksObtained to mark him absent.

First of all I'm grateful to everyone for replying. Do u mean that absent student won't have a records for specific subject's exam and I can use that info to mark absent in result report? Yes I record daily attendance of every student but my result table don't have exam date right now so...

Yes, plus only zero don't give indication of whether student was absent or on leave. Additionally, while entering marks in the result form, how to handle it there too? I mean if data type of ObtainedMarks is changed to text then user can enter A or L and same could be shown in result report but...

Hello, In a student database, result of subjects is entered as numeric data and same is the data type of ObtainedMarks field in the tblResult. Then marks of are summed up using either Sum formula or using Total row in query. What it is desired that when a student was absent in a specific paper...

While searching the internet for the last two days, I came across these two (Stakeoverflow Link and VBForums Link) resources but couldn't figure out how to make them work for me.

Thanks for link. Sorry I forgot to mention that the PC don't have internet and I knew the control panel method but that method required internet and so does the web installer. I tried finding .Net 3.5 redistributable offline installer but none worked on Windows 10.

Hello, I am getting subject-mentioned error on execution of both Set sysText = CreateObject(SYS_TEXT_UTF8) and With CreateObject(SHA512_MANAGED). This error is resolved when I install .Net FW 3.5 however there are few PCs with my users on which we are unable to install .Net FW 3.5 as those PCs...

There is one thin more, theme is updated after restarting the db. Is it possible to see the changed theme without having to restart the db?

Thanks a lot @petertheme for the db and help, @strive4peace, @isladogs, @Gasman for input. The way I implemented in my db is user select the theme from a combo (with rowsource from a table which contain path to the corresponding theme file as all theme files are stored locally in certain...