Binary input with publisher

[Einy]

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

 

[Ed Bennett]

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.

 

[Einy]

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

 

[Ed Bennett]

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