Search results

  1. A

    Problem using DOC.MailMerge

    Big problem using MailMerge. I did check some code on the internet but i must not understand it. In desparation i try this code from a book. It doesnt do it the way i would (Using the me.Recordset of a tabular form and passing each row of the recordset to word. Each row represent a tenant his...
  2. A

    Problem passing parameters to a Report using a parameter query

    Thanks MajP you nailed it. I'm gonna sleep well tonight.
  3. A

    Problem passing parameters to a Report using a parameter query

    Hi PBaldy I try what you said but it keep me asking for parameter D1, D2 and ... DateDuPaiment. Thanks for your help and suggestion
  4. A

    Problem passing parameters to a Report using a parameter query

    Sorry the code from the preceding code doesnt work at all. It doesnt show an empty report but keep asking for the parameter D1 and D2 Thanks
  5. A

    Problem passing parameters to a Report using a parameter query

    I try this but it's opening an empy Report Dim chaine as string param1 = #1/1/2018# param2 = #1/31/2018# DoCmd.OpenReport "Etat", acViewReport, , , , "D1=" & param1 & "|" & "D2=" & param2 chaine = Reports!Etat.OpenArgs Print.Debug chaine in the immediate window the result...
  6. A

    Problem passing parameters to a Report using a parameter query

    Hi i have a big problem using a Query Parameter to open and populate a report. This is the Parameter Query: PARAMETERS D1 DateTime, D2 DateTime; SELECT tblResidents.NomResident, tblResidents.PrenomResident, tblPaiements.Paiement FROM tblResidents INNER JOIN tblPaiements ON...
Top Bottom