saving prtdevmode in table

Collapse
This topic is closed.
X
X
Collapse
 
  • Page of 1
  • Time
  • Show
Clear All
new posts
Previous template Next
  • Esmee
    #1

    saving prtdevmode in table

    Hi there,
    I want to be able to save the PrtDevmode en Prtdevnames properties of
    several reports into a table. So I open a report in Design mode, get
    the prtdevmode en prtdevname from the report, tuern it into a string
    and save them to Memo fields in a table. So far so good.

    But then I want to get the prtdevmode and prtdevname out of the table
    and save it into the report again. Then it goes wrong. When I look in
    the table at first I only see part of the string, until I select the
    whole field, and then I can see the whole string. There are squares in
    the string. When extracting the prtdevmode and prtdevname I get only
    the part of the string until the first square. Everything after that
    doesn't come out of the table.
    I'm pretty sure that's where the crux of the problem lies.
    Does anyone have any suggestions how I can get the whole string out of
    the table again?

    It's getting to be very frustrating.
    Thanks
    Esmee
    Tags: None
    • TC
      #2
      Re: saving prtdevmode in table

      The PrtDev* structures contain binary data - not ordinary string data. They
      will inevitable look strange if you store them into a text column. The ideal
      column type would be BINARY. But I don't have Access here to check, so I'm
      not sure whether you can define a binary column directly from the user
      interface.

      As a matter of interest, *why* do you want to store the PrtDev* values?

      HTH,
      TC


      "Esmee" <g.e.waller@ins pektor.nl> wrote in message
      news:2e91aa76.0 310230141.1fef9 5b5@posting.goo gle.com...[color=blue]
      > Hi there,
      > I want to be able to save the PrtDevmode en Prtdevnames properties of
      > several reports into a table. So I open a report in Design mode, get
      > the prtdevmode en prtdevname from the report, tuern it into a string
      > and save them to Memo fields in a table. So far so good.
      >
      > But then I want to get the prtdevmode and prtdevname out of the table
      > and save it into the report again. Then it goes wrong. When I look in
      > the table at first I only see part of the string, until I select the
      > whole field, and then I can see the whole string. There are squares in
      > the string. When extracting the prtdevmode and prtdevname I get only
      > the part of the string until the first square. Everything after that
      > doesn't come out of the table.
      > I'm pretty sure that's where the crux of the problem lies.
      > Does anyone have any suggestions how I can get the whole string out of
      > the table again?
      >
      > It's getting to be very frustrating.
      > Thanks
      > Esmee[/color]


        Comment

        • Esmee
          #3
          Re: saving prtdevmode in table

          Thanks TC, you put me on the right track.
          The reason I want to be able to store PrtDev* values is so that my
          clients don't have to change the printer settings of reports every
          time I send them a new version of my db.
          Bye
          Esmee

          "TC" <a@b.c.d> wrote in message news:<106696698 7.768140@teutho s>...[color=blue]
          > The PrtDev* structures contain binary data - not ordinary string data. They
          > will inevitable look strange if you store them into a text column. The ideal
          > column type would be BINARY. But I don't have Access here to check, so I'm
          > not sure whether you can define a binary column directly from the user
          > interface.
          >
          > As a matter of interest, *why* do you want to store the PrtDev* values?
          >
          > HTH,
          > TC
          >
          >
          > "Esmee" <g.e.waller@ins pektor.nl> wrote in message
          > news:2e91aa76.0 310230141.1fef9 5b5@posting.goo gle.com...[color=green]
          > > Hi there,
          > > I want to be able to save the PrtDevmode en Prtdevnames properties of
          > > several reports into a table. So I open a report in Design mode, get
          > > the prtdevmode en prtdevname from the report, tuern it into a string
          > > and save them to Memo fields in a table. So far so good.
          > >
          > > But then I want to get the prtdevmode and prtdevname out of the table
          > > and save it into the report again. Then it goes wrong. When I look in
          > > the table at first I only see part of the string, until I select the
          > > whole field, and then I can see the whole string. There are squares in
          > > the string. When extracting the prtdevmode and prtdevname I get only
          > > the part of the string until the first square. Everything after that
          > > doesn't come out of the table.
          > > I'm pretty sure that's where the crux of the problem lies.
          > > Does anyone have any suggestions how I can get the whole string out of
          > > the table again?
          > >
          > > It's getting to be very frustrating.
          > > Thanks
          > > Esmee[/color][/color]

            Comment

            Previous template Next
            Working...