JPEG Prossing From SQL DB
Nov 19, 2004
Hi everyone.
I have a problem displaying jpg files in a bounded image object.
After connecting Access 03 with ODBC to a SQL Server DB (SQLSDB) I wanted to display the image content of a table (jpg files) in Access. Instead of images Access returns the image filename.
After installing Microsoft Converter Pack and Photo Edit from an old Office XP Edition I was able to display jpg in unbounded image objects and simple image objects, but still the problem with the bounded image object witch contain the jpg files remains.
Any Suggestions ???
Thanks for your time
View Replies
Aug 31, 2006
Morning everyone,
I have a really persistant problem with my database whereby whenever I click on a hyperlink (in the database) to a Jpeg file it will display an error message, "unknown file format" then open the file as normal. The access windows then crash.
Has anyone else encountered this problem? If so doe anyone have a solution or a way round it!?
Any help much appreciated, have a good day :)
Matt
View 6 Replies
View Related
Jun 1, 2005
I am working on a database with two main tables: One table that is linked in from another database, and another table contains addresses to the location of jpegs that correspond with the records in the linked table. (Every record does not have corresponding jpeg, only some of them do.) The way the forms are currently set up, there is a main form and a subform. The main form contains only a combo box where the user can choose a record. The subform shows the rest of the information pertaining to the record, including the jpeg. The problem is that all the other information changes when the user chooses a different record - except for the jpeg, it stays the same. The code to pull the jpeg into the form works when under the form load procedure, but the jpegs do not change when a different record is selected from the combo box on the form. I tried to do this a straight forward way, and then I tried using the RaiseEvent command, but nothing seems to work. I have a relationship b/t the 2 connecting fields, and I have tried all 3 join types. Any help would be greatly appreciated.
View 2 Replies
View Related
Sep 23, 2006
I have a path to a JPEG file in a variable. I want to click on a command button and open the JPEG file. Is there code which in effect double clicks on the path to open the file? Thank you.
View 1 Replies
View Related
Jul 16, 2014
I am in project to send members a birth day greeting with image.
Now I have designed report containing JPEG image. but i am not able to send report to mail as Mail body using MS outlook.
View 1 Replies
View Related
Jun 20, 2014
How I would link to jpeg files and have access render them. How to do it.
View 2 Replies
View Related
Aug 12, 2005
It may seem a really silly question but is there any restrictions as to the file types that can be stored in an Access DB.
I havent used Access in a while, but have been asked by a friend to create a simple DB holding info about cars he is selling, he only wants to hold thumbnail images of the cars so I can either link or embed the pics! However if I try to link or embed a jpeg image nothing appears in the bound object frame except for the image title i.e. bmw325i.jpg if I do exactly the same with a bitmap image the pic is displayed???
The only other difference I have noticed is that in table view of the relevant table a bitmap appears as Bitmap Image whereas a JPEG appears as Package????
Any ideas
Thanks in advance
Simon
View 1 Replies
View Related
Jul 14, 2015
I am inserting a logo in jpeg format to a report. unfortunately the logo comes in very large. the frame around the logo can be adjusted but the image does not; it remains large.
View 5 Replies
View Related
Oct 7, 2014
I am looking for a function that will allow me to encrypt/decrypt single image files as and when required. I have built my own simple one to encrypt a string that will be stored in a filename as all the ones I found created unusable filenames.
However I don't know where to start with the image file encryption.
(Any better way to encrypt a string that can be used in a file name that would be great too. My method is a bit basic).
View 2 Replies
View Related
Aug 12, 2013
I have created a database for a church cemetery. It contains the usual names, birthrates deaths, etc.... I have also created a map of the cemetery in PDF format with the lot number highlighted which is assigned to a particular record. I did the same in excel with a layout of the lot and a JPEG picture of the grave marker. In my table I created Three columns - Site Plan, Lot Plan, and Grave marker. I insert the specific site plan, lot plan, and jpeg picture using the "insert object" in the table. On my form after a search, I have created three buttons.. Site Plan, Lot Plan & Grave Marker.
I have looked and experimented trying to assign these command buttons to open these files on the form. I don't have any experience with macros or VB code.
View 4 Replies
View Related
