Search results

Many thanks, I will try your method to see what the wrong is

No never for all fields

I have some functions, but they are all return numbers

This issue appears sometimes not all times, it happens when a user deletes date from the ScndCrseFrstAsses and ScndCrseScndAsses by the delete key

Some beautiful minds work like crystal ball with accurate 100% :). The calculated filed I use is =IIf([txtRes]=5 And [txtTotal2]<50,[ScndCrseFrstAsses]+[ScndCrseScndAsses],Null) Details; txtRes is also a calculated filed based on a function and this function returns only numbers...

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

information in UNBOUND controls are not for further uses as I know. In my case, fields like average or ResFCourse later they would be used to filter the students. Example, if I want to find the top 3 students according to their averages, how could achieve this task if there is no students...

Can I DlookUP "ResFCourse" from "qryStudentsResults" into "qryStudentsMark" by "StudentRegID"?

For some reasons, I would keep the first part of your statement with no comment . Well, I am already using a form and subfrom, however, the subfrom is based on "TheResultedQuery" because all fields should be shown to the user. Again, based the subfrom on a non editable query would led to non...

Also, the field "SAFExam" would be filled by hand once "SAFirstAssest" get values

It would be hard to create/delete table each time the record is edited for thousand of records

In the "TheResultedQuery" there is a field named "SAFirstAssest". This field in calculated depending on the two joined queries. I can't find another way to find "SAFirstAssest" unless join the two queries. In the query mode or the form mode, the resulted query would be non editable

Thank you arnelgp for the replay, Unfortunately, not worked

Thank you Mike for the replay, sure ! Uploaded with regards

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

Sorry, it was my mistake, I meant right click + delete record OR select the record and delete by the keyboard delete key.

I just wanted to customize the delete confirmation message to be more readable. Because, the deleted record is marked as "cascade delete related records" so the intrinsic confirmation message would be confused to the user. BUT, even when I delete the VBA code, the intrinsic prompt firing twice.

Sorry, it was my mistake, I meant right click + delete record OR select the record and delete by the keyboard delete key.

Thank you for the replay. The deletion done by the delete button of the datasheet form, so no method used. However, I use the code below Private Sub Form_BeforeDelConfirm(Cancel As Integer, Response As Integer) Response = acDataErrContinue If MsgBox("Are you sure you want to delete"...

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 ?