Assigning Memo fields

From: NayJo (CrawNOSPAMforMEford_at_mindspring.com)
Date: 11/24/04

  • Next message: Alex Ivanov: "Re: query mdb on network into Word. Access.exe not on workstation"
    Date: Wed, 24 Nov 2004 13:39:11 -0500
    
    

    I have a memo field in an Access database that I am trying to populate in a
    VB application using ADOR.recordset. I am using a 3rd party ActiveX control
    to move data into a byte array and I want to store that data to the memo
    field.

    My naive stab at the problem yields nothing however.

    '''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''

    Dim mtmpl1() As Byte
    Dim mRowset As ADOR.Recordset

    ' And later in a subroutine...

    ReDim mtmpl1(Fpr1.TemplateSize - 1)

    nBytesCopied = Fpr1.CopyTemplate(VarPtr(mtmpl1(0)))

    ' Assertion does not trigger
    Debug.Assert ( Not FPr1.TemplateSize = 0)
    Debug.Assert ( nBytesCopied = FPr1.TemplateSize)

    mRowset("Template1") = mtmpl1

    '''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''

    Pardon my code, I am not a VB programmer but on examining the field, there
    is no data in the database. And I apologize that it is not runnable code -
    I am really trying to focus on the last assignment. Integers and strings
    are present that I set are present and contain the expected values.

    How should I assign data to the memo field?
    Many thanks.

    J


  • Next message: Alex Ivanov: "Re: query mdb on network into Word. Access.exe not on workstation"

    Relevant Pages

    • Pound sign in Access generates an error
      ... "#Error" for a memo field. ... Inserting the string "#Error" in a memo reproduces the error. ... containing the "#Error" string is inserted in the Access database via a C# ...
      (microsoft.public.access.forms)
    • very weird access/ASP error
      ... i have a memo field in an access database. ... been spending your mortgage money on things other than paying the bank. ... wife betrayed me like that I would want someone to tell me. ...
      (microsoft.public.inetserver.asp.db)
    • Changing Document / Live Document?
      ... You might say the document is alive because I envision it to change ... Access database with a memo field to be merged into a word document. ... TIA! ...
      (microsoft.public.word.docmanagement)
    • Changing Document / Live Document?
      ... Access database with a memo field to be merged into a word document. ... Regards, ... Greg Strong ...
      (microsoft.public.word.formatting.longdocs)
    • Changing Document / Live Document?
      ... Access database with a memo field to be merged into a word document. ... Regards, ... Greg Strong ...
      (microsoft.public.word.mailmerge.fields)