Search results

  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?
  16. I

    How to query a backEnd database from a frontend database with a Sql script

    Hi To query a backEnd database from a frontend database with Sql script, proceed as follows: Private Sub Form_Load() Dim strPathDb As String, strDbName As String, strRsetTable As String, strBackEndLocation As String, strDBPSW As String strPathDb =...
  17. I

    Table Re-Linking in Runtime Giving Error

    If you want to query a back end database with a Sql script go here http://www.utteraccess.com/forum/index.php?showtopic=2037433&view=findpost&p=2601558
  18. I

    Runtime error 3265 Item not found on this collection

    Hi Davenport Considering your code Sub update_Teilnehmerliste() Dim db As DAO.Database Dim qdf As DAO.QueryDef Dim strSQL As String Set db = CurrentDb() Set qdf = db.QueryDefs("Teilnehmerliste") strSQL = "SELECT " & _ " s.Nr, s.Anrede, s.Vorname," & _...
  19. I

    Multi filter by text boxes

    Hi To wrap a string value in your Sql script, use single quote not double quote
  20. I

    Add button to create record into table based on ID

    Hi Do you use docmd.openform command to open the sub datasheet form popup? With this command, you can add criteria to filter the records displayed. For more formation go here
Back
Top Bottom