Etxezarreta
Member
- Local time
- Today, 19:36
- Joined
- Apr 13, 2020
- Messages
- 175
Hello,
I am stuck with a bad result of a query sent form a VBA procedure:
here is the file: https://we.tl/t-MmO8fV1Stq
it is in the "DSP_RDV_f_ConsultGestion_HistorRdv" form : you need to select items in the 5 list boxes, then click in "Jamais visités" and send the procedure by clicking on "lancer la recherche par critères": I do not understand at all what is going on there.
It is meant to select fields from the Contacts_t_ListeContacts table according the values of the list boxes, then remove the records that have the "ID_contact" field value that matches with the field "FK_contact" in the table " DSP_RDV_CR_t_CompteRendus". and to populate a table that feeds the subform.
I have been searching for ages, thanks for your help.
Etxe.
I am stuck with a bad result of a query sent form a VBA procedure:
here is the file: https://we.tl/t-MmO8fV1Stq
it is in the "DSP_RDV_f_ConsultGestion_HistorRdv" form : you need to select items in the 5 list boxes, then click in "Jamais visités" and send the procedure by clicking on "lancer la recherche par critères": I do not understand at all what is going on there.
It is meant to select fields from the Contacts_t_ListeContacts table according the values of the list boxes, then remove the records that have the "ID_contact" field value that matches with the field "FK_contact" in the table " DSP_RDV_CR_t_CompteRendus". and to populate a table that feeds the subform.
I have been searching for ages, thanks for your help.
Etxe.