If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Catalog Merge in Publisher 2007
Hey, Im doing an A-Level project and I have to create a catalog merge- from
Access, and I can't get it to show the pictures!! Do the pictures have to be in a particular format??? Any feedback welcome! Thanks, Sian |
#2
|
|||
|
|||
Catalog Merge in Publisher 2007
I use Excel for my catalogue merges. I create a picture field, type the name of
the image, usually .jpg but any picture format is possible. I then put all the images and the database into one single folder. That way I don't have to type the paths. I am not savvy about how Access acknowledges images. -- Mary Sauer MSFT MVP http://office.microsoft.com/ http://msauer.mvps.org/ news://msnews.microsoft.com "Sian" wrote in message ... Hey, Im doing an A-Level project and I have to create a catalog merge- from Access, and I can't get it to show the pictures!! Do the pictures have to be in a particular format??? Any feedback welcome! Thanks, Sian |
#3
|
|||
|
|||
Catalog Merge in Publisher 2007
Thank you!!!! And it does work, thanks very much!!!!
Sian "Mary Sauer" wrote: I use Excel for my catalogue merges. I create a picture field, type the name of the image, usually .jpg but any picture format is possible. I then put all the images and the database into one single folder. That way I don't have to type the paths. I am not savvy about how Access acknowledges images. -- Mary Sauer MSFT MVP http://office.microsoft.com/ http://msauer.mvps.org/ news://msnews.microsoft.com "Sian" wrote in message ... Hey, Im doing an A-Level project and I have to create a catalog merge- from Access, and I can't get it to show the pictures!! Do the pictures have to be in a particular format??? Any feedback welcome! Thanks, Sian |
#4
|
|||
|
|||
Catalog Merge in Publisher 2007
Glad to help. I'm glad it worked for you. Maybe someday you can tell me how you
setup the Access database. -- Mary Sauer MSFT MVP http://office.microsoft.com/ http://msauer.mvps.org/ news://msnews.microsoft.com "Sian" wrote in message ... Thank you!!!! And it does work, thanks very much!!!! Sian "Mary Sauer" wrote: I use Excel for my catalogue merges. I create a picture field, type the name of the image, usually .jpg but any picture format is possible. I then put all the images and the database into one single folder. That way I don't have to type the paths. I am not savvy about how Access acknowledges images. -- Mary Sauer MSFT MVP http://office.microsoft.com/ http://msauer.mvps.org/ news://msnews.microsoft.com "Sian" wrote in message ... Hey, Im doing an A-Level project and I have to create a catalog merge- from Access, and I can't get it to show the pictures!! Do the pictures have to be in a particular format??? Any feedback welcome! Thanks, Sian |
#5
|
|||
|
|||
Catalog Merge in Publisher 2007
Deffinately, I have just done an entire school year on Access! So Ill be
happy to help. Sian "Mary Sauer" wrote: Glad to help. I'm glad it worked for you. Maybe someday you can tell me how you setup the Access database. -- Mary Sauer MSFT MVP http://office.microsoft.com/ http://msauer.mvps.org/ news://msnews.microsoft.com "Sian" wrote in message ... Thank you!!!! And it does work, thanks very much!!!! Sian "Mary Sauer" wrote: I use Excel for my catalogue merges. I create a picture field, type the name of the image, usually .jpg but any picture format is possible. I then put all the images and the database into one single folder. That way I don't have to type the paths. I am not savvy about how Access acknowledges images. -- Mary Sauer MSFT MVP http://office.microsoft.com/ http://msauer.mvps.org/ news://msnews.microsoft.com "Sian" wrote in message ... Hey, Im doing an A-Level project and I have to create a catalog merge- from Access, and I can't get it to show the pictures!! Do the pictures have to be in a particular format??? Any feedback welcome! Thanks, Sian |
#6
|
|||
|
|||
Catalog Merge in Publisher 2007
Sian, I really don't want to learn Access, I know enough to create a decent
database. I just don't know how to create an image field. If you have a sample I'd love to see it. mary-sauer at columbus.rr.com -- Mary Sauer MSFT MVP http://office.microsoft.com/ http://msauer.mvps.org/ news://msnews.microsoft.com "Sian" wrote in message ... Deffinately, I have just done an entire school year on Access! So Ill be happy to help. Sian "Mary Sauer" wrote: Glad to help. I'm glad it worked for you. Maybe someday you can tell me how you setup the Access database. -- Mary Sauer MSFT MVP http://office.microsoft.com/ http://msauer.mvps.org/ news://msnews.microsoft.com "Sian" wrote in message ... Thank you!!!! And it does work, thanks very much!!!! Sian "Mary Sauer" wrote: I use Excel for my catalogue merges. I create a picture field, type the name of the image, usually .jpg but any picture format is possible. I then put all the images and the database into one single folder. That way I don't have to type the paths. I am not savvy about how Access acknowledges images. -- Mary Sauer MSFT MVP http://office.microsoft.com/ http://msauer.mvps.org/ news://msnews.microsoft.com "Sian" wrote in message ... Hey, Im doing an A-Level project and I have to create a catalog merge- from Access, and I can't get it to show the pictures!! Do the pictures have to be in a particular format??? Any feedback welcome! Thanks, Sian |
#7
|
|||
|
|||
Catalog Merge in Publisher 2007
Reading your questions was a great help to me in figuring out my problem with
Access to Publisher 2007 catalog merges. I created the table with image attachments, but could not get Pub to merge the attached images. Access apparently recognized the location of the images in subfolders (it correctly printed reports .) But Publisher seems to require that the images be in the exact same folder as the Pub file. This will be a bear with my 8,000 image project! Anyway, thanks to you and Mary Sauer. "Sian" wrote: Hey, Im doing an A-Level project and I have to create a catalog merge- from Access, and I can't get it to show the pictures!! Do the pictures have to be in a particular format??? Any feedback welcome! Thanks, Sian |
#8
|
|||
|
|||
Catalog Merge in Publisher 2007
Im glad it helped you! Thanks, Sian
"johnsgarden" wrote: Reading your questions was a great help to me in figuring out my problem with Access to Publisher 2007 catalog merges. I created the table with image attachments, but could not get Pub to merge the attached images. Access apparently recognized the location of the images in subfolders (it correctly printed reports .) But Publisher seems to require that the images be in the exact same folder as the Pub file. This will be a bear with my 8,000 image project! Anyway, thanks to you and Mary Sauer. "Sian" wrote: Hey, Im doing an A-Level project and I have to create a catalog merge- from Access, and I can't get it to show the pictures!! Do the pictures have to be in a particular format??? Any feedback welcome! Thanks, Sian |
#9
|
|||
|
|||
Catalog Merge in Publisher 2007
Mary, There are ways of storing image data, there is an Image Control for
displaying image data (Although I havn'y had much experience with this), There are OLE fields where images can be stored, and there are also Bound OLE Frames where images from an OLE Field can be displayed. I have found one site where imaging examples can be downloaded from: http://accdevel.tripod.com these may be of some help other wise I will be happy to do my own version for you. Hope this helps! Sian "Mary Sauer" wrote: Sian, I really don't want to learn Access, I know enough to create a decent database. I just don't know how to create an image field. If you have a sample I'd love to see it. mary-sauer at columbus.rr.com -- Mary Sauer MSFT MVP http://office.microsoft.com/ http://msauer.mvps.org/ news://msnews.microsoft.com "Sian" wrote in message ... Deffinately, I have just done an entire school year on Access! So Ill be happy to help. Sian "Mary Sauer" wrote: Glad to help. I'm glad it worked for you. Maybe someday you can tell me how you setup the Access database. -- Mary Sauer MSFT MVP http://office.microsoft.com/ http://msauer.mvps.org/ news://msnews.microsoft.com "Sian" wrote in message ... Thank you!!!! And it does work, thanks very much!!!! Sian "Mary Sauer" wrote: I use Excel for my catalogue merges. I create a picture field, type the name of the image, usually .jpg but any picture format is possible. I then put all the images and the database into one single folder. That way I don't have to type the paths. I am not savvy about how Access acknowledges images. -- Mary Sauer MSFT MVP http://office.microsoft.com/ http://msauer.mvps.org/ news://msnews.microsoft.com "Sian" wrote in message ... Hey, Im doing an A-Level project and I have to create a catalog merge- from Access, and I can't get it to show the pictures!! Do the pictures have to be in a particular format??? Any feedback welcome! Thanks, Sian |
#10
|
|||
|
|||
Catalog Merge in Publisher 2007
I figured out how to do it in Access 2007, quite simple actually. I will look at
your example. Thanks for all your help, Sian, it is appreciated a great deal. -- Mary Sauer MSFT MVP http://office.microsoft.com/ http://msauer.mvps.org/ news://msnews.microsoft.com "Sian" wrote in message news Mary, There are ways of storing image data, there is an Image Control for displaying image data (Although I havn'y had much experience with this), There are OLE fields where images can be stored, and there are also Bound OLE Frames where images from an OLE Field can be displayed. I have found one site where imaging examples can be downloaded from: http://accdevel.tripod.com these may be of some help other wise I will be happy to do my own version for you. Hope this helps! Sian "Mary Sauer" wrote: Sian, I really don't want to learn Access, I know enough to create a decent database. I just don't know how to create an image field. If you have a sample I'd love to see it. mary-sauer at columbus.rr.com -- Mary Sauer MSFT MVP http://office.microsoft.com/ http://msauer.mvps.org/ news://msnews.microsoft.com "Sian" wrote in message ... Deffinately, I have just done an entire school year on Access! So Ill be happy to help. Sian "Mary Sauer" wrote: Glad to help. I'm glad it worked for you. Maybe someday you can tell me how you setup the Access database. -- Mary Sauer MSFT MVP http://office.microsoft.com/ http://msauer.mvps.org/ news://msnews.microsoft.com "Sian" wrote in message ... Thank you!!!! And it does work, thanks very much!!!! Sian "Mary Sauer" wrote: I use Excel for my catalogue merges. I create a picture field, type the name of the image, usually .jpg but any picture format is possible. I then put all the images and the database into one single folder. That way I don't have to type the paths. I am not savvy about how Access acknowledges images. -- Mary Sauer MSFT MVP http://office.microsoft.com/ http://msauer.mvps.org/ news://msnews.microsoft.com "Sian" wrote in message ... Hey, Im doing an A-Level project and I have to create a catalog merge- from Access, and I can't get it to show the pictures!! Do the pictures have to be in a particular format??? Any feedback welcome! Thanks, Sian |
|
Thread Tools | |
Display Modes | |
|
|