Search results
-
J
query with multiple outer joins gives wrong result
multiple outer joins: problem solved! Dear Rabbie, thank you for your answer. I did not try your solution, because i have solved the problem myself. It seems to be shorter than what you suggest, and i do not need a union query. Indeed we have to break the query down into sub tasks: A query... -
J
query with multiple outer joins gives wrong result
Hello, My query references 2 related tables: one for persons (PERS) and one for telephone/fax numbers and email addresses (CONT, for Contacts). The relevant fields are: PERS pers_id (long) ---> primary key pers_forename (text) pers_surname (text) CONT cont_id (long) ---> primary key pers_id... -
J
SourceObject property of subform mysteriously reappears
Sourceobject property of subform mysteriously reappears Dear Uncle Gizmo, Thank you very much for your answer, Yes, it must be something like that, although i could not reproduce it with the scenario that you describe. I really hope it only occurs in design mode, because otherwise i have a... -
J
SourceObject property of subform mysteriously reappears
Hello, I have a main form with a subform on it. It is essential that the Onload event of the main form is triggered before the Onload event of the subforms form (because the main form creates some class instances that are referred to by different forms that can appear in this subform)... -
J
The "No Current Record" Mystery
>> I'm pretty sure that an empty RecordSet should not throw and error if you access the RecordCount property. That is a generally accepted method of determining if the RecordSet has any records. Well, still this is what made the difference: with RecordSet.RecordCount the error message appears... -
J
The "No Current Record" Mystery
"No Current Record Mystery" solved! Dear Rural Guy, thank you for your answer: although initially the error message was still there, your suggestion of using RecordsetClone instead of Recordset helped me to solve the mystery! The "On Current" trigger now has the following code If... -
J
The "No Current Record" Mystery
I have a main form containing PERSON records (frm_pers). Within it there is a subform containing their TELEPHONE numbers (frm_tele). The forms are based on the tables PERS and TELE. The primary key field of PERS is named pers_id and so is the foreign key field of TELE. So the "link child fields"...