Search results

  1. H

    Sendind a result of a query by mail

    Good Evening, I corrected the error by Set ListeEMail = CurrentDb.OpenRecordset("SELECT * FROM 2015") and still the same error Habiler
  2. H

    Sendind a result of a query by mail

    Hello, First of all my best wishes to you all and thank you for your continued relevance aid. I started the year as I left. Pb mail access In the following code, I debug a problem with the CurrentDb.OpenRecordset ' --- ' ENVOYER UN MAIL DEPUIS ACCESS ' --- ' Entrée : strEmail <- Adresse...
  3. H

    datediff into calculatedfield

    I try the calculated fields: DateDiff ("M" [beginning] [end]) and it tells me datediff is not usable.
  4. H

    Error .visible

    Hello, In my form I added the fields Parente and Nom_parent . But when Form_Current Private Sub () occurs it makes me an error message on Me.parent.visible (.visible in yellow color). Note that the field is in text format, but even removing Nz (... he always tells me the same error. Thank you...
  5. H

    Printing only filled records.

    Thank you for your patience. I read the document optimization, but I really do not see how to solve my problem. I do not know which fields I need to put in another table. I block.
  6. H

    Printing only filled records.

    Thank you for your attention. without wishing to be difficult, would it not be possible to print only this: 34 Congé parental Datenv_2 : 07/09/2014 37 Mutation (tempor) Datenv_3 : 30/09/2014 Thanks Habiler.
  7. H

    Printing only filled records.

    I do not know how to start. I'm new in reports. Maybe with if ... then .Visible. I m sorry for my english but my mothertong is French Habiler
  8. H

    Printing only filled records.

    Hello everybody, I have record in wich I would print the records whose fields A is filled but not field B or Field C is filled and not field D. See appendices. Congretulations
  9. H

    Automatic insertion of the value of a field in a form.

    In fact I have two tables ave in table A [matr], [name], [prenom] and a second table B with [matr], and to the query: nomPrenom: Trim ([nom]] & "" & [prenom ]). I would like in shape when I hit a [matr] (table B) the nomPrenom (query but from table A) appears in the form.
  10. H

    Automatic insertion of the value of a field in a form.

    Hello everyone, I have a form that when I insert a registration number I would like the value of the field "nom" the name automatically appears in the "nom" field of the form. The form uses a query.
Back
Top Bottom