By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
425,863 Members | 879 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 425,863 IT Pros & Developers. It's quick & easy.

saving prtdevmode in table

P: n/a
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
Share this Question
Share on Google+
2 Replies


P: n/a
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

P: n/a
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.