Search results
-
A
DLookup between two quries
Ah! my poor idea, was that easy. !! So no need for DlookUp and no more headache . Many Thanks -
A
DLookup between two quries
I have a query named "qryStudentMarkTable" which include student marks and some calculation fields. Another GroupBy query "qryStudentYearResults" which includes some functions to find students final result and averages. In the second query there is a calculated field named "ResFCourse" which is... -
A
Combine two combo boxes by their names not values
Works!! Many thanks -
A
Combine two combo boxes by their names not values
Hello everybody, I have two combo boxes bound to LevelID and LabelID. I set them to show the LevelName and LebelName rather than their IDs. A text box to combine the tow combo boxes names (LevelName and LebelName) is also created . The two combo boxes work fine, however, the text box is showing... -
A
Moving my database to the next acadimic year
I want the new academic year starts automatically, not by user. -
A
Moving my database to the next acadimic year
How pass a value to the whole forms once the database is launched ? -
A
Moving my database to the next acadimic year
Actually, I want to track all classes one year long. I am also thinking of your idea about using the begin and the end of the academic year, then check when database is opened if the current date is between the begin and the start of the academic year. However, how to transform this idea to... -
A
Moving my database to the next acadimic year
I don't want to select the academic year manually, I would like the database to do it automatically after the previous academic end date is passed. -
A
Moving my database to the next acadimic year
My database is roughly something as you suggested. In this case, how to move to the next record at the Academic year table ?so when user open the database, then the next year academic is shown and he/she has to fill the new year information -
A
Moving my database to the next acadimic year
I see, sorry I got it wrong. Many thanks . -
A
Moving my database to the next acadimic year
Sorry for bothering you, but I am new to this forum. may you post the link here, or just guide me to go to post #7 and your list -
A
Moving my database to the next acadimic year
How to get your list please ? -
A
Moving my database to the next acadimic year
Does your function delete the data after it been archived ? -
A
Moving my database to the next acadimic year
I got very nice ideas from your replay, just about this point Should I fill the Academic Year in advance(let say for 10 years) or I may make it dynamic increasing ? -
A
Moving my database to the next acadimic year
Something like below: I'm organizing it as follow: A main form (AcadimicYear) of subfrom1(YearLevel) of subfrom2 (YearLevelCaption) of subfrom3 (YearLevelCaptionCourseTeacher) -
A
Moving my database to the next acadimic year
Could you explain more please. An Academic year has many levels, many courses and many students. So if they are not tied to the academic year, then how organize them? they are all tied to the academic years. -
A
Moving my database to the next acadimic year
In my database, the key of the transition among the academic years is AcadimicYear table which include information about the academic unique ID, year name, start date and end date. To prepare my database to the next year, I need the AcadimicYear table move to the next year (record)... -
A
#Deleted appears in dleted field before delete confirmation
Actually, even when I delete it manually there is no problem. For some reasons, I can't remove the Cascsde Delete. Anyway, should I worry about this issue ? -
A
#Deleted appears in dleted field before delete confirmation
I am getting confused. Lets explain more. I have a from which is bound to tblAcadimicYears with two subfroms, the first one is bound to tblYearLevel and linked to the main form via YearID, and the second subfrom is bound to tblYearLevelCourseTeacher. The process of data entry in my form is ...