468,268 Members | 1,978 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 468,268 developers. It's quick & easy.

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
Nov 12 '05 #1
2 2295
TC
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.********@inspektor.nl> wrote in message
news:2e**************************@posting.google.c om...
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

Nov 12 '05 #2
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:<1066966987.768140@teuthos>...
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.********@inspektor.nl> wrote in message
news:2e**************************@posting.google.c om...
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

Nov 12 '05 #3

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

reply views Thread by Gabriele Bertolucci | last post: by
5 posts views Thread by Randy Harris | last post: by
reply views Thread by Phil Stanton | last post: by
1 post views Thread by Paul H | last post: by
2 posts views Thread by jessDMiller | last post: by
reply views Thread by zattat | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.