Search results

  1. H

    Using Hylperlink

    Hello, What's the value of recordset2?
  2. H

    Using Hylperlink

    Hello, What's the value of recordset2?
  3. H

    Using Hylperlink

    HEllo, Save in db
  4. H

    Using Hylperlink

    Posts: 9 Joined: 6-August 15 Hi, Is it possible to store the value of the find file as a hyperlink in the form and the db simultanely? If found Decision in c:\X\Y\Z\X.pdf then the value of c:\X\Y\Z\X.pdf is tored into the control Me.decision? Thanks for all Habiler Hi Decision is value...
  5. H

    Using Hylperlink

    Good Monday everybody. I am blocked with the code which follows: I would want that the hyperlink link is stored in the field and does not open. Is there a way to reach there. I tried with Gohyperlink but I failed. I work in a form. Thank you in advance Yours Habiler Private Sub...
  6. H

    color of thine of the section detail

    Good evening to all, In the section detail I would wish that all the line appaers and is printed in blue(by ex) if the value of [klasse] = 1. I have already tried the CF but I crashed Excellent evening and well week end Habiler
  7. H

    create a directory/sub directory with access

    Good evening the Community, I would want to create an used directory starting again of sub-directories corresponding to the number of an employee. In brief in an used directory if the sub-directory X (number of the employee) does not exist, this one owes to be created. Thank you in advance...
  8. H

    Question Directly acces to a file in a directory

    Hello the Community, I have a field hypertext and one fields number. In my directory C:\ y\ I have a file 123.pdf which 123 corresponds to number 123 in my field X I would want that by clicking on my fields hypertext I would want that it fetches my file 123.pdf in the directory c:\y\ Yours...
  9. H

    Query for mailing

    It is about a Word document
  10. H

    Query for mailing

    Hello to all, I have a table including fields candidate, Chairman, assessor1 and assessor2. By mailing I would want to print (3X) an including document on the one the name of the Chairman, on the second the name of the Assessor 1 and on the third the name of the Assessor 2 with on three...
  11. H

    Mail lotus 8.5 via vba

    Hi, this code below says me can not find "sendNotesMail". What's happened ? KR Habiler
  12. H

    Sorting by boolean fields

    Hi all of you, That's my problem I have 3 fields Yes/No. A B C To be in order it is necessary that: A , B and C = Yes. I would want to print all differents combinations : A = no et B et C = Yes Then A: Missing Nom, prenom et adresse. ..... ..... A = Yes, B=No and C = No Then B and C...
  13. H

    First letter in uppercase

    Hello The community In a form I have fields name, first name in which I would if necessary want to put the first letter of the name and/or the first name in uppercase. I created for it a buttonUPLOW How to synchronize this action. Thanks to you all Habiler Function MiseEnMajuscule(Chaine...
  14. H

    List of mails separated with ,

    Hi, I have a field email in the table 2015. I woud create a query that sort my mails separated by a comma. E.G. 123@456.com 456@789.fr ... Sorted = 123@456.com,456@789.fr, ... Thanks Habiler
  15. H

    Mail lotus 8.5 via vba

    Hi, I finded the error but it opens lotus at the workspace and don't create a mail Habiler
  16. H

    Mail lotus 8.5 via vba

    Hi, this code says me can not find "sendNotesMail". What's happened ? KR Habiler Public Function SendNotesMail()'This public sub will send a mail and attachment if neccessary to the recipient including the body text.'Requires that notes client is installed on the system. 'Set up the...
  17. H

    Mail lotus 8.5 via vba

    Hi, this code says me can not find "sendNotesMail". What's happened ? KR Habiler Public Function SendNotesMail()'This public sub will send a mail and attachment if neccessary to the recipient including the body text.'Requires that notes client is installed on the system. 'Set up the...
  18. H

    Mail lotus via vba

    Hi the Community, I found a code which sends back to(dismisses) me the error: can't find : "C:\Users\Desktop\Classeur1.xlsx" Thanks for your help Habiler 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49...
  19. H

    Sendind a result of a query by mail

    Now i have a problem with this line . E_mail is the name of the field in table 2015. (Item not found in this collection. Run time error 3265 ListeComplete = ListeComplete & ListeEMail(e_mail) & ";" Private Sub Outlook_Click() Dim MonOutlook As New Outlook.Application Dim MonMessage As...
  20. H

    Sendind a result of a query by mail

    Hello, My problem is now : MonMessage.Attachments.Add ListeEMail(" ") (Yellow color + error run time 3265 Private Sub Outlook_Click() Dim MonOutlook As New Outlook.Application Dim MonMessage As Outlook.MailItem Dim ListeEMail As Recordset Dim ListeComplete As String '...
Back
Top Bottom