Search results

  1. B

    Current record on clicking unbound image

    Hello, The image control is already in het detail section. I hope that you can give me some more pointers
  2. B

    Current record on clicking unbound image

    Hello everyone, I have a continious form with a picture of a delete button. When I press the button I want to see the currentrecord ID. To test this I simply use the code msgbox(me.ID.value) When I click on the unbound image the msgbox shows the first ID no matter wich row I click...
  3. B

    [97] Sendobject Background in email

    I just cant get it to work. Somebody please help me
  4. B

    [97] Sendobject Background in email

    Thank you for the effort... But I am using outlook express 6 Could this code be adjusted for outlook express?
  5. B

    [97] Sendobject Background in email

    Could anybody please point me in the right direction?
  6. B

    [97] Sendobject Background in email

    Hello, I want to send an order via email using the following code: DoCmd.SendObject acSendNoObject, , , "info@sosol.nl", , , "Onderwerp", strMessage, False This works fine. But I want an image as background for the mail. What do i have to put in the templatefile? Just the path to the .jpg file?
  7. B

    [97] Automatically send mail

    Im so stupid. I resolved it. I forgot the option adjustmessage set to false. It works great guys.
  8. B

    [97] Automatically send mail

    Hello, I have built an application in access 97 that orders articles. now i use this code to send data to outlook express 6: Private Sub cmdMail_Click() Dim strMessage As String strMessage = "Geachte Relatie," & vbCrLf & vbCrLf & "Ik zou graag het volgende willen bestellen:" & vbCrLf &...
  9. B

    [ACCESS 97] Search multiple keywords

    See post #55 ;-) Thanks again!
  10. B

    [ACCESS 97] Search multiple keywords

    That doesnt mather at all. Not only did you solve the problem. But I learned a lot from it. Thanks again bro.
  11. B

    [ACCESS 97] Search multiple keywords

    Bro....you are a genius!!!!!! It works! Thank you very very much for all of your help man. If there is ever anything I can do for you just let me know.
  12. B

    [ACCESS 97] Search multiple keywords

    WOOOW....you absolutely didnt give poor advice. I am not sucking up to you but without you I never came this far. If I use txtOmsZ.text it works when I am typing. However when I want to find the next record I get the error (translated from dutch): You can only refer to a property or method of a...
  13. B

    [ACCESS 97] Search multiple keywords

    Well, you either search on artnr (article number) or txtomsz (describtion). Zo as you start typing something in the "txtomsZ" txtbox automatically the focus goes to the first match. I also posted the original working code at the following location: http://www.sosol.nl/access/OriginalCode.zip...
  14. B

    [ACCESS 97] Search multiple keywords

    Wel.. The guy who wrote the program doesnt support it any more and becausei know the guy who bought the program he asked me to modify the search so he could search on keywords seperated with a comma. fe: uitlaat,nsr I hope this clarifies a lot. Thanks again BTW.
  15. B

    [ACCESS 97] Search multiple keywords

    Well, when I use the original code there is no error. When i use the code adjusted by me the error message appears. I am clueless
  16. B

    [ACCESS 97] Search multiple keywords

    Also in the piece of code above the one i posted earlier: Function MeldingLog(strMelding_i As String, Optional intButtons_i As Integer = 0) As Integer MeldingLog = MeldingLogLIB("OFB", strMelding_i, intButtons_i) End Function the value of strMelding_i is also "invalid use of null"
  17. B

    [ACCESS 97] Search multiple keywords

    Dear Jal, Again thank you very much for your help so far. I finally found the line where the error is. its on: Function MeldingLogLIB(strPakket_i As String, strMelding_i As String, Optional intButtons_i As Integer = 0) As Integer 'tonen MeldingLogLIB = MsgBox(strMelding_i...
  18. B

    [ACCESS 97] Search multiple keywords

    I posted the whole application in access 97. Create a folder on your C drive and call it "ofb" (c:\ofb) and unpack the front and backend there. 1. Then open the application. 2. Go to "Artikelen" (in the menubar). 3. Go to "Zoek omschr." and type something. The message "unvalid use of null" will...
  19. B

    [ACCESS 97] Search multiple keywords

    Sorry Jal, Here is the whole codeblock: Original code (no invalid use of null error) Function InLijst(varArtNr_i As Variant, varArtOms_i As Variant, blnNext_i As Boolean, blnPrev_i As Boolean) As Boolean On Error GoTo Err_InLijst Dim qryRes As Recordset Dim strArtNr As String...
  20. B

    [ACCESS 97] Search multiple keywords

    Hello Jal, I tried the following code and still I get the error message: Invalid use of null. Dim strTest As String Const comma = "," Dim words As Variant, word As Variant words = Split(txtOmsZ, comma) For Each word In words...
Back
Top Bottom