Pictures : Store And Display

Dec 17, 2005

Lets say an employee form withs the name, the position, the birthdate, ... and a picture of the person.

There are several ways to store pictures in a database, each having pros and cons.

Experienced developpers in dealing with pictures would be kind to tell me the way they recommend to store the picture, and the best way to simply display it on the form.

Thanks,

View Replies


ADVERTISEMENT

Best Way To Add/display/handle Pictures

Dec 3, 2006

Hi guys,

I've noticed a few posts on the subject of images but there's lots of different scenarios and I'm hoping someone with far more knowledge can give me some basic pointers for my specific case so I can research it more fully.

Basically part of my database is storing properties, then there's a separate table for property photos as each property can have between 0 and infinity photos (theoretically, the max. is likely to be between 5 or 10).

From my understanding so far it will be best to store a path to each picture as a text field in the database as we're looking at 100+ photos easily from the start which I understand would cause a huge database using OLE linking.

I've got a couple of articles on how to take the path and display it as a picture on the form, not tried it yet but had a read through and it all seems fine.

What I need to ask is the best way to do a couple of things...

When viewing a property via a form is it easy-ish/possible to display thumbnails and captions for all the associated images? Could it then be set up so you could click each image to view it full size?

I need a slightly more user friendly way of adding the photos than just typing in file paths. What I imagine the cleanest way would be blank boxes which you'd click, get a Browse... window to pick the image then once you'd picked one it would place a thumbnail in the box, or something similar. However I'm not sure how well that would scale to a non-specific number of images (ie 0 - 10).

I have no fixed specifications for displaying/adding these images so if you have other ideas/ways of doing it then please suggest - the above is just what I imagine would be 'nice' - if it involves way too much coding then it's not worth it at this stage.

Any help / pointers would be most appreciated :) Let me know if you need more info.

Chris :)

View 1 Replies View Related

How Do I Programmatically Store And DISPLAY A Value Into A New Record?

Jan 10, 2006

Using Access 2000, I have an BeforeInsert event to set a value in a field by referencing the form/subform/fieldname. When the user enters a new record simpy by arrowing down the subform, this value IS entered but NOT displayed until the record is saved.

How do I get the programmatically stored value to display on the proper field box WHILE the user is entering the other fields?

I assume the NEW record is a buffer (not in the database yet), so perhaps I need to reference the new record buffer so it displays on screen. How do I reference that?

View 1 Replies View Related

Forms :: Display Absolute Value But Store Negative Value

Nov 18, 2014

I have a subform displayed in Datasheet form and I would like to store in a field negative integers. But, for UI and usability purposes, I don't want the user to have to write the "-" for the negative value to be stored. is it possible that the user will write the number i.e. 1 and in the table -1 will be stored?

View 7 Replies View Related

How To Store Equations On Fields Display And Edit Them In A Form

Apr 23, 2014

I would like to store equations on certain fields and display and edit them in a form.

I can't find a Microsoft Equation Editor control in the list of ActiveX controls. Is it stored as a .ocx file? How is it named?

In case Equation Editor can't be used within Access, is there another third party addin that provides a control with that functionality? It would be great if there were an application that accepted markup code like LaTeX as input so it were easier to implement a code to manipulate equations.

View 1 Replies View Related

Need: Inserting Pictures. Need To Understand Or Need Better Way Of Adding Pictures

Jan 31, 2005

I am using Access 2003 in a simple database and want to add digital pictures of each item in my database.

Before trying to enhance the database with pictures; the various fields are filled with either descriptive text or numbers. The size of the mdb database file is 464k.

I recently wanted to add a picture of each database entry. After adding a picture that is only 300k in size the mdb file increase to 18MD. Then after adding another picture also of 300k bytes my database grew to 25MB.

In the drop down menus Under Tools - Database Utilities - I ran the Compact & Repair Database. This did not reduce the size.

In the database Form I am using a Bound Object Frame to hold the picture and yes I am not linking the picture I am including it in the database. But, would only expect it to increase the database size by slightly more than the picture size.

I should also point out that the only way I have found to get the picture to be visible (not just an icon of the type of picture file) is to right click on the Bound Object Frame scroll down and choose Insert Object. Click on Create New and select Adobe Photoshop Image. This open adobe photoshop I make sure the picture properties are creating a picture of 300k.

So my question(s) is again. Why is my database increasing in size so rapidly? Is there a better to insert picture into a database?

Regards, Roy (HerlocherR@aol.com)

View 2 Replies View Related

Reports :: Output Access Reports As JPG To Display In Pictures Screen Saver

Sep 2, 2013

I have been tasked with creating a database to log employee suggestions and then automatically present reports around the site. I have developed the database and it works OK and can output *.PDF reports, but I'm having problems with how to display these reports. My idea was to output the reports automatically as *.TIFF or *.JPG files and have them stored in a folder that the My Pictures screensaver uses. The reports (in fact, any site report stored in this folder) can then be shown on any screen dotted around the site when it goes into screensaver mode. However I can't find any way to output/convert to a picture file.

The other option is to create a webpage that rotates through the saved PDFs, but this isn't ideal as the PC users will have to load the webpage to display the reports.

View 4 Replies View Related

Pictures..

Oct 20, 2007

I like to make a small code in access to take pictures with any camera, then store with file name, date and time? please I need help.. if someone can give me an idea I appreciate this. thanks again..

View 3 Replies View Related

Pictures In Comboboxes

Apr 19, 2006

OK, I asked this question a day or so ago and got some feed back. What I would really like is a difinative answer. Basically Yes or No. Is it possible to add small picture, (icon size) to a comobox. I realise its not good practice to have pictures embeded in the DB but on this occasion its what I need to do. Ive found software on the web that allows you to do it, which leads me to belive that it can be done, any ideas!

View 6 Replies View Related

Animated Pictures

Nov 12, 2006

:confused: Could someone please help me. is it possible to add an animated microsoft GIF to an Access 2003 database splash screen. the picture works but the animation doesnt. If someone could please help i would be very grateful as it is needed for an assignment very soon. Thanks in anticipation.

View 2 Replies View Related

Pictures In Access

Jun 18, 2007

I have Access 2003 and have trying for some time to insert pictures. I have followed the instructions step by step as outlined in the BIBLE and nothing. I recently acquired a new computer and the problems still persists. Can anyone help.

View 8 Replies View Related

Insert Pictures

Jun 27, 2007

I need to do something in excel but I have never used excel before. I need to make a form with a box. When you click on the box it shhould promt you to add a picture to the box. It should also format the picture so that it is the same size as the box. So far we have the box, but we still need to figure out what code to input so that it prompts you to add an image and then resizes it to fit the box. This is the code we have so far:


With Application.FileDialog(msoFileDialogFilePicker)
.Title = "Seleccione la imagen"
.Filters.Add "All Files", "*.*"
.Filters.Add "JPEGs", "*.jpg"
.Filters.Add "Bitmaps", "*.bmp"
.FilterIndex = 3
.AllowMultiSelect = False
.InitialFileName = Application.Path
result = .Show
If (result <> 0) Then
fileName = Trim(.SelectedItems.Item(1))
Image1.Picture = LoadPicture(fileName)


End If
End With


I am not sure if this can be done in excel or if I have to use another application to do this. I need to figure this out within the next couple of days, so if you have ANY idea of how to do this please post a response.

View 2 Replies View Related

Problem With Pictures

Apr 19, 2005

I have trouble adding pictures to my forms.
On the form when I add a picture, it just shows me the link and when I double click on it, it displays the .gif file. ( I did define it as an OLE object in the table)
I am not sure if there is something specific I need to do in order to display the picture right there on the form.

View 4 Replies View Related

Refreshing Pictures

Mar 24, 2006

Hello all,

I have search the forum for two days and can not find anything about this promble so any help would be good.

I am using a linked picture i have then browser setup and works ok but my issue is that i can not get the picture to refresh its self, with out going into design view and then back to my form, i would hope that there is a solution to this.

Any links would be good or general help would be great as i am starting to loss sleep over this now.

Thanks in advance

Alastair

View 1 Replies View Related

Upload Pictures

Sep 27, 2006

Hi There,

Can someone help me please. I have designed a product management database for a friend. He would like to be able to upload pictures of his products onto his database to be viewd later. So on the products form, I'd like two command buttons (I guess), one to define the file path and another to open that file path.

ANy help would be appreciated.

Kerry.

View 2 Replies View Related

Combo Box And Pictures

Nov 11, 2005

Any help on how to approach this would be very much appreciated!

I have two tables: one with data about compounds, the second with data about graphs of these compounds. (There may be many graphs for each compound).

I need a form that displays data about each compound, and in this same form, I'd like to show what graphs are associated with this compound and display a picture of each graph as it is selected.

I've tried both subforms and comboboxes and have not been successful.

Thanks so much!

View 2 Replies View Related

Pictures In Forms

Jun 21, 2007

I know if you use pictures in forms it makes the database file size very big, if you have a products database and want to show a picture of each product, therefore each picture is different, is there a way of doing this and keeping the database size reasonable?

View 9 Replies View Related

Attaching Pictures To Records

Aug 14, 2005

I've built a database to attach pictures of people to their records. In the table it's designed as an "OLE Object". When you goto the form you can click on the box, tell it to insert object, find the file, and the picture can be displayed to the record.

I've since learned that this process inflates the database and with the recent update changes from Microsoft (removing Photo Editor) I'm trying to learn to create databases to insert pictures having the same result but won't inflat the database.

I've learned of a view method to insert pictures that are a little more complicated to create using coding. My problem with this method is you would have to type in the file location manually to get the picture to attach. I'm working in a location that needs this process to be simpler then that. I need to find a way to browse for that picture instead of having to type in the file location manually.

HELP!

View 1 Replies View Related

Linked Pictures In Database

Sep 7, 2005

What is wrong with this linked pictures in my database?
I have made OLE field in a table and I want to insert pictures in that
field with option "linked". But pictures are not exactly linked. First, they take
a lot of space in a database, almost as inserted pictures (If inserted picture takes 30Mb than linked picture takes 20Mb). I thought it is only going to save a link (target location) to a file. Also, when I insert link to a picture ina OLE field and delete this picture in windows - I can still see this picture on a form in my application. So, is it linked or inserted (only difference is that I can't edit linked picture if it's deleted in windows but I can see picture in a form).
How can I insert only link to a picture in my database so I can see pictures in forms and reports and pictures stays only in windows and takes a minimum space in my database (only for a target informations)???
Thanks!

View 1 Replies View Related

How To Create Path For Pictures

Apr 3, 2006

Hi all.

I have ADP Project in my computer and MS SQL 2005 Express in second computer.

In ADP Project I need to write Path for Pictures:

Dim Path As String
Path = ????? ' Her I need D:Pictures

Thank You in advance.

View 3 Replies View Related

Pictures And Continuous Form

Apr 19, 2007

Thanks for reading another one...

I am building an application for my marketing dept. that will track their mailouts. So far I can handle it; however, they want a thumbnail displayed of each piece of creative. I can do this if they only wanted to see one record at a time, but they want all records w/in a certain date range and the pic that goes with it. I am currently storing the path to the image so not to gorge my db to explosion.

pic campaign_name start end mail_out #_pieces
pic campaign_name start end mail_out #_pieces
pic campaign_name start end mail_out #_pieces
pic campaign_name start end mail_out #_pieces

where pic is the thumbnail. I have built it with a continuous form so I can display all the records but I am up to change if needed.
I have read other posts and they all deal with single forms and the onCurrent event is not really working for me.

Any and all help is greatly appreciated!

View 10 Replies View Related

Pictures/PHotos In MS Acces

Jun 25, 2007

I'm not brilliant at using MS Access - can't use the VBA codes or anything like that.

basically, I want to set up a database of photogrpahs where you store thephotograph in Access, and then run a query to search for specific photos, which brings up a form showing the picture.

I seem to be OK at doing all of this so far except I can't get the photo to appear in the form - it just displays a link which you double click on to get to the photo.

I've tried to look up how to sort this on the web but don't understand the way people speak about access :confused:

can anyone help???

View 12 Replies View Related

Assigning Pictures To Records

Jul 9, 2007

I notice that this topic has been done to death.....I have a database that is embedding the pictures and the predictable problems has manifested...the database is swelling up....

I'm learning to adapt the database to include the file location in the form and have the picture box refer to the file location, rather then embedding the picture into it....the problem that I have is that although I know how to do it because I get it.....this database will be run by a number of people, many of which don't have much experience and it must be simple to input the file location. Is there a way to simplify putting the file location in the text box aside from typing it in manually (a search window; like the one that appears when trying to open a file or insert an object, perhaps)....

View 1 Replies View Related

Help: Displaying Pictures In A Form

Nov 28, 2007

To display images on a form (Access 2003) I used the same code of the Northwind database sample (Form Emplyees).

when changing the Picture's location it returns a bug in the code (Couldn' open ...the file), or the ErrorMessage Label should have the value: "File not Found".

Here is the code:

Private Sub Form_Current()
Dim res As Boolean
Dim fName As String
Path = CurrentProject.Path
On Error Resume Next
ErrorMsg.Visible = False
If Not IsNull(Me![ProductPicture]) Then
res = IsRelative(Me![ProductPicture])
fName = Me![ImagePath]
If (res = True) Then
fName = Path & "" & fName
End If
Debug.Print "fName: " & fName
Me![ImageFrame].Picture = fName
showImageFrame
Me.PaintPalette = Me![ImageFrame].ObjectPalette
If (Me![ImageFrame].Picture <> fName) Then
hideImageFrame
ErrorMsg.Caption = "File not Found"
ErrorMsg.Visible = True
End If
Else
hideImageFrame
ErrorMsg.Caption = "Click on Add/Edit to add the Product Picture"
ErrorMsg.Visible = True
End If

End Sub

Function IsRelative(fName As String) As Boolean
IsRelative = (InStr(1, fName, ":") = 0) And (InStr(1, fName, "") = 0)
End Function
#

View 2 Replies View Related

New Pictures Not Displaying In Split DB

Jul 28, 2005

Greetings All.
I have a problem that just began occurring with the pictures on my forms.
I have the forms linked to pictures in a folder called “Pics”. In the information table, the field for the pictures reads “\B2r101t3Pics00-00-0000.jpg” where “B2r101t3” is the computer name, “Pics” is the directory (Separate from the directory in which the DB’s Back-End lies), and “000-00-0000.jpg” is the name of the image file.
The above worked fine till about a week ago when all new pictures added did not display on any satellite computers. They do, however, display properly on the computer on which the Back-End lies. So I now have a situation where some pictures are displayed and others not. I have not made any changes to the DB or Pictures, and everything else works just fine.
Does anyone have any insights as to why this may be happening? I would, as always, appreciate any pointers.
Thanks,
Bonie.

View 2 Replies View Related

Pictures Not Linking At All. Need Big Time Help

Aug 20, 2005

the attached zip file has a mockdown version of my database it should allow you to see my problem. The premise is to link a picture(s) to a serial number. There are the possiblities of having more then one picture per serial number. I am getting an error stating "Microsoft Office Access can't fine the form 'frmPicExample' referred to in a macro expression or Visual Basic code."

Can someone help to link the example pictures to the correct serial number. And the serial numbers that do not have a picture to read no picture for the serial number.

Thank You

roborro

View 1 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved