Binary input with publisher

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Einy - 10 Apr 2005 08:03 GMT

Hi,

I am creating a catalogue merge in Publisher and in some of my fields, I
need to take binary (yes/no) input from a database and display a picture for
YES and nothing for NO... How can I do that?? I honestly don't know where to
start... Is there and If .... Else kind of a add in to do that?

Thank you.

Einy

Reply to this Message

Ed Bennett - 11 Apr 2005 16:45 GMT

Einy <Einy@discussions.microsoft.com> was very recently heard to utter:

> I am creating a catalogue merge in Publisher and in some of my
> fields, I need to take binary (yes/no) input from a database and
> display a picture for YES and nothing for NO... How can I do that?? I
> honestly don't know where to start... Is there and If .... Else kind
> of a add in to do that?

You would probably need to use a query in your database and check the value
of the field - a new field with the picture path if it is YES, a blank entry
if it is NO.

Signature

Ed Bennett - MVP Microsoft Publisher

Reply to this Message

Einy - 11 Apr 2005 17:03 GMT

Thanks Ed....

I have already done that... The picture was simply a check sign... so I used
the Wingding Font to create the same effect... But I thougt there is a way to
do it with VB in publisher... The database I am using changes daily... and
the catalogue I use is meant to create stickers... so I'd hate to have to run
the query everytime I need to print a few stickers :(

Thanks anyway... if this is the only solution I'll have to do with it:-)

If you can think of anything else, please let me know... I'll be endebted :-)

Einy

> Einy <Einy@discussions.microsoft.com> was very recently heard to utter:
> > I am creating a catalogue merge in Publisher and in some of my
[quoted text clipped - 6 lines]
> of the field - a new field with the picture path if it is YES, a blank entry
> if it is NO.

Reply to this Message

Ed Bennett - 11 Apr 2005 17:47 GMT

Einy <Einy@discussions.microsoft.com> was very recently heard to utter:

> I have already done that... The picture was simply a check sign... so
> I used the Wingding Font to create the same effect... But I thougt
> there is a way to do it with VB in publisher... The database I am
> using changes daily... and the catalogue I use is meant to create
> stickers... so I'd hate to have to run the query everytime I need to
> print a few stickers :(

You could use VB to open the database through a the data objects, execute
the query, then use the resultant table (I don't believe Publisher supports
merging directly from queries, so you need a MakeTable query) as the record
source in the merge.

I would suggest reading AJ May's articles at MSDN here:
http://msdn.microsoft.com/office/understanding/publisher/articles/default.aspx

Signature

Ed Bennett - MVP Microsoft Publisher

Reply to this Message

Rate this thread: