Search results

  1. A

    #Type! in calculated fields of a form

    I have a subform of some calculated fields that calculate date from other fields. I am getting "#Type!" error at the calculated fields. I did some searches and found that happens when trying to calculate different data types together, however, my fields to be calculated are all "NUMBER" data...
  2. A

    How to make joined queries editable

    Hello everyone, I have a query "qryStudentMarks" which include students marks for the whole academic year, and a group-by query "StudentsResults" that hold some calculation fields such as student semester result (Pass and Fail) and averages. I want to combine the both quires but want the...
  3. A

    Delete confirmation message firing twice

    Hello everybody, what cause of delete confirmation message to appear twice? I'm trying to delete a record from subform of nested forms, but I got Cascade deletion to appear two times when I cancel the deletion, however, it appears once if I confirm the deletion process. Any help please ?
  4. 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...
  5. 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...
  6. 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)...
  7. A

    #Deleted appears in dleted field before delete confirmation

    Hello everyone, in my database below I got "#deleted"appears in credit field (subform) when I try to delete levelID from tblYearLevel. However, it seems that the delete process done properly, so should I worry about it? if yes, then how to fix. Many thanks.
  8. A

    Students Database structure for high school help

    Hello everybody! I need help to move on on my database. It is a secondary school (as it called in my country) database which include 6 levels. A student join the school, and must to pass the 6 level (one level per year), so the student will stay at least 6 years. Then, at each year there are...
  9. A

    Dsum for the current month sales

    Hi Everybody, I'm using the following expression to find the sum of the current month sales. =DSum("[Price]*[Quantity]","QueryCurrentMonth Sales","[ORDDate]=Month (now())") However, it returns no result. Can anyone help please. Thank you. Note: the above expression is located on the control...
  10. A

    Craete query to filter customers when it is the time of their monthly patments

    Hi everybody, I'm not very to Access. I'm trying to make a query to filter or show only those customers when it is the time for their monthly payment . The query I have consists of four fields which are 1- Order ID 2- Payment 3- Date (Default value set to Date ()) 4- Date for next time...
Top Bottom