Recent content by informer

  1. I

    Need to update subform based on combobox selection in main form

    You’re right.:D
  2. I

    Need to update subform based on combobox selection in main form

    Hi, To populate a subform, you need to create dynamically a query which will be set to the subform recordset as follow qry = "SELECT Field... FROM .... WHERE 1 " If Me.ListBox1.ListIndex <> -1 then qry = qry & " AND field1 = ‘" & Me.listbox1.value & "’ " end if If Me.ListBox2.ListIndex...
  3. I

    Need help - Filter listbox on subform based on selection in main form

    Please, could you explain me why you use a textbox?
  4. I

    Need help - Filter listbox on subform based on selection in main form

    Hi mort An other solution is to set a query on change event listboxA Set Me.listboxB.Recordset = "SELECT.... WHERE id=" & Me.lisboxA.value
  5. I

    Need help - Filter listbox on subform based on selection in main form

    Hi mort A possible solution with parameter query Create a storage procedure ( for this example myQuery) with parameter which will be called for populate your listboxB PARAMETERS myParameter Long; SELECT field1, field2, field3 FROM myTable WHERE myId = myParameter On Change event listboxA...
  6. I

    Memo field is truncating at 255 characters

    Hi, For a complete explanation click on here http://allenbrowne.com/ser-63.htmll
  7. I

    Outlook.mailitem - How to assign to body a memo field with 255 characters and more

    Thanks a lot again for your help. I precise : A payer (tblPayeur) can pay for several students (tblEleve). Even if I trangress rules for modelling a db scheme, I store in an table (tblAEditer), students who have courses for a period MM/YYYY entered dynamically in a form which displays the list...
  8. I

    Outlook.mailitem - How to assign to body a memo field with 255 characters and more

    Hi Minty, Using DISTINCT SQL command in subquery doesn’t cause truncation of memo field if it is selected in the principal request. For my case, it works perfectly:)
  9. I

    Outlook.mailitem - How to assign to body a memo field with 255 characters and more

    Hi All It works great now I applied recommendations provided by Allen’s Browne : Move on first position the memo field remove DISTINCT SQL command and change my query to select only one record by using SELECT memoField,.... FROM tblX WHERE tblX.id IN ( SELECT DISTINCT tblX.id FROM....)...
  10. I

    Outlook.mailitem - How to assign to body a memo field with 255 characters and more

    Thanks a lot for your help and advices. I’ll implement your solution today.
  11. I

    Outlook.mailitem - How to assign to body a memo field with 255 characters and more

    Hi Minty In my vba code I wrote sSQL = "SELECT * FROM qryPayeurPourEdition" Set recSet = CurrentDb.OpenRecordset(sSQL)And qryPayeurPourEdition SQL is SELECT DISTINCT tblPayeur.Afficher, tblPayeur.eMailComment, tblPayeur.eMail, tblPayeur.PaiementImediat, UCase([tblPayeur].[civilite] & " " &...
  12. I

    Outlook.mailitem - How to assign to body a memo field with 255 characters and more

    Hy Minty Thanks for your help but still doesn't work and even after declaring my variable as below Dim sBody As String * 1024 I used the function below to check sBody content and same result, only 255 charaters were saved in SQL.txt Function writeInFile(sSQL As String) sPath =...
  13. I

    Outlook.mailitem - How to assign to body a memo field with 255 characters and more

    Outlook.mailitem - How to assign to body a memo field with 255 characters & more Hi In a VBA function, I assign to the body of Outlook object a memo field with more than 255 characters .Body = recSet!eMailCommentBut the memo field content is cut off after 255 characters. How to circumvent...
  14. I

    Checklist Relationship

    Hi komo Could you upload your database?
  15. I

    Need help in data entry forms that increments and should be dynamic.

    Hi redprintz Coud you upload your database?
See more
Top Bottom