In everyones opinion what is the best way to handle picture uploads in an Access database?
One picture for one employee, where should I store the pictures. I know that keeping pictures in the database eats up space and really can slow ya down. Make a new folder just for pictures??
Thanks fellas and ladies.
I'm just wondering, is it possible to put a graphics in the code? the reason I want to know is that I will put a sad face on each customer every time they call. so if they will call me 5 times i will see a 5 sad smiley face on the customer information. Can you please help me with this one. or if you know any way to do just let me know. thank you so much.
View 6 Replies View RelatedHere is my situation. I have a database with a table in which contains all of the names and members of our club. Every member in our club has a rank, the rank is held in a field called "rank". I also have a form which is used to add and edit the information into this table. The form that i have create is a bog standard form with nothing special on it. What i would like to be able to do is when the form loads and the information from the table populates it, i would like a picture box to hold a picture that represents there position like an avatar. I have tried doing this myself however my attempts just resulted in errors about not have the form focus. I use the code editor to do this. I know this is possible to do as i have seen it on some other projects.
If any one has any idea or hints about how i can do this please reply.
As an added thing i would prefer if it was done in the code editor as the machine it has to run on has macros disabled.
Hi guys.
I have been told to make my database look 'sexier' but I am a bit worried that the pictures may slow it down or increase it's size unneccesarily.
Speed is an issue because we have some offices that dial in and access it that way and as such are limited to their connection speed.
So what I want to do is created a few images, link to them, and put in code that can 'turn them on'.
The question is how?
I have created a new image object. Changed it's properties to linked.
Now I need some code that reads:
If myvalue = "Yes" then
myImage.visible = true
Else
'code to delete image
End If
I am a bit worried because that means that the images will always be there on load up, so loading the form will be just as slow because the images are there.
Or maybe I can do
If myvalue = "Yes" then
'code to create image
End If
Please help.
Edit - Part two to this question is: How do I use relative links for images? I have a folder of images and I want them to work no matter where the database sits.
Edit again - Just another question: Is it possible to have Images appear and disappear depending where the mouse is?
Have a database that stores information about jewelry. The user wants each record to have a picture of the item. No matter what I try I can’t put a picture field in my table. All help is appreciated. tillessal@yahoo.com :confused:
View 1 Replies View RelatedI have a form which brings up another form like this
Dim stDocName As String
Dim stLinkCriteria As String
stDocName = "frmImage"
stLinkCriteria = "[ProductID]=" & "'" & Me![txtProductID] & "'"
Me.Visible = False
DoCmd.OpenForm stDocName, , , , , , "SELECT ProductID, Description, Path FROM tblProducts WHERE " & stLinkCriteria & ";"
However, on the frmImage there is also an ImageControl that may or may
not have a picture. The name of the path and filename is stored in a field
in a table (not OLE).
I do not want the frmImage to open at all if no image can be found under the path and name specified. The file/picture name is exactly the same as the ProductID in the link criteria above.
Perhaps a message to say that no image was found.
At the moment the form opens up regardless.
By the way, the Me.Visible = False refers to the form that opens the
frmImage form, so will have to become True if no image found.
Thanks
I have set up a bound object frame on a form, everything works good, only problem i have is the picture doesn't display but the name of the picture does, ie...picture.jpg. if i click on this the picture is displayed in microsoft office picture manager, I think I'm close..maybe just a shove away..
Please help if you can,,
Thanks,
Jerry
I need very very urgent help in database forms. I have 2 pictures. Active and Inactive. How do I go about where when there is no record, the inactive pictures shows, but when there data is entered into the db, the active pictures appear. Can someone please help me??
View 6 Replies View Relatedi have a folder called photos and i have all the pictures named properly, and i would like to be able to creat a table with each picture in this folder and have there picture name be the fields unique Id. im not sure how to import so many pictures and how to give there name.
View 14 Replies View RelatedI have searched (not knowing what to search for), tried Access help and most importantly experimented, but alas no luck.
I have a header section and body/main section of a form.
I want the background image to fill the body/main section only, but instead it seems to cover the whole form, including the header section.
Is it possible to limit an image to the body section of a form only.
Thank you in advance
Hello.
Please help.
In form I want to see picture from another table and In form On Current i put sub:
Dim picPhotoString As Variant
Dim str1 As String
picPhotoString = Me!txtBox.value
sstr1= DLookup("[Field] ", "table", "[ID]= ' " & picPhotoString & " ' ")
Me!ObjectBoundFrame.value = str1
Me!ObjectBoundFrame.Requery
When table contain Photo, it shows, when no - I recieve error: "Invalide Use of Null".
Where is mistake?
I was unable to find a satisfactory answer to this problem in the forum plz answer asap:
How can I add different pictures as background on different pages of a tabulated form such that each tab if clicked loads a new page with a different bkgrnd pic?
i m able to do this for entire forms but not each tabulated page portion
Please reply fast
hopefully the attachment will be here
sorry did not notice a 2mg limit I had to omit all the pictures but you should get the jest of it.
Thank You again
roborro
I was wondering if anyone could let me know how to do the following:
I have a form with a subform in it. I based the subform on a combo box that gets its info from a table seperate from the form(This works fine) when an item is selected from the combo box it retrieves the correct subform accordingly. I need to know if it is possible if when a selection is made from the combo box it could select the correct picture from the tab folder i have on the form aswell as the correct subform. The picture of my form I have attached may explain better than i can.
I appreciate any feedback whatsoever.
Thank you
I have a form that is part of an auction application, and displays a picture of an item when the record is retrieved (OnCurrent event).
That works fine, but (presumably when the server is slow) I get a popup box informing me that it is "Importing Picture", often flashing too quickly to be read, let alone cancelled.
How can I turn this warning off?
If this is a duplicate posting, my apologies - my machine's playing up.
I have a form that is part of an auction application, and displays a picture of an item when the record is retrieved (OnCurrent event).
That works fine, but (presumably when the server is slow) I get a popup box informing me that it is "Importing Picture", often flashing too quickly to be read, let alone cancelled.
How can I turn this warning off?
I have created a db with a picture linked to every form as a background.
The mdb file and the jpeg file are on the server but if it is open and someone else tries to open it it will give an error and the bg won't be linked to the forms.
If the picture is embedded the db becomes sooo large (from 700 kb to 43 mb!!!!) so that's also not the solution.
Hope that someone can help.
Wendi:)
Is there a way to merge a picture or object to the background so i can put fields over it.
Here's is what I'm doing, I have a picture of a tool and need to measure it in certain spots. I have my pic, but when I try to put my fields in place they disappear to underneath the pic. I need an suggestions
Hey to all. I have this form in which I need according to a user selection to assign a picture and display it on the same form. Is this possible? How do I do this? Or can I display the picture to another form or a report based on the first form?
Thanks in advance.
Hi, I have finally managed to create a button wich add a photo with the code below, what I need now is to create a button DELETE wich will remove the photo I have loaded !
Private Sub cmdBrowse_Click()
On Error GoTo err_cmdBrowse
Me![txtPicture] = GetOpenFile_CLT("C:Documents and SettingsMarcoDocumentiB MedCrew SchedulerPhotos", "Select the File")
Me![txtPicture] = LCase(Me![txtPicture])
Me!Picture.Picture = Me!txtPicture
exit_cmdBrowse:
Exit Sub
err_cmdBrowse:
MsgBox Error$
Resume exit_cmdBrowse
End Sub
Hi all,
I've got a little problem when users move through records on a form that has an image embedded the source of which changes for each record linked using a filename field and path in the database. The pictures are served across the network from another computer. Some of them are relatively large and take a second or so to load.
The problem comes when a user tries to browse too quickly through the records, when the pictures are importing a box appears advising the user, if the user clicks through too fast the box sticks and remains visible in the foreground right in the middle of the screen, it even remains when Access is exited. You have to end the process in Windows Task Manager in order to get it to disappear. I'm using Office XP with service pack 3, does anyone know of a fix for this bug
or if there's no fix
is there a way I could maybe delay each record by about 1 second to allow a picture to load as the user browses through using the record selectors at the bottom of the form?
Many thanks for any advise given.
:confused: I have a particular Windows XP Home edition machine that is giving me a headache...
On the DB - users can access a form that displays pictures in a Picture control (via file path) with no problem at all. The problematic machine displays 'Access does not recognise the file format and so can't load the picture....' or something of that ilk....
Yet the file format is JPG and if I use the qualified path (on this same machine), eg. \SERVERFolderPicsPICTURE.JPG from the XP Start/Run menu - XP Image viewer opens and displays the JPG with no problem at all!
Why is this happening only on this XP machine and not on the others..???
Any ideas would be greatly appreciated - thanks in advance.
Regards
Guido
I'm having a problem with my sub forms and the sample linking image code.
Top subform is in data view and the bottom in form. Sync'd with a textbox.
notes show individual data per record as you click on them, and the picture updates the location the same.
Problem I am having is that the picture does not display even though the path is there.
Wise one,
I have looked at several examples within this forum but can't seem to implement any suggestions. My plight is this: I want to introduce a progress status to my database. I would like to do this by depicting a traffic light (green, amber or red). The user needs to be able to pick one of the 3 through a combo box. If the user picks “Red” then the bmp picture will be displayed representing a red traffic light. I created a table with the 3 pictures embedded – tbtProgressStatus. I have a main table called tblClientData where I have a field in which I’m trying to apply a lookup value looking at tbtProgressStatus. However, the embedded objects are not showing in the wizard. Does this mean that this is not possible?
Yours truly
I have a player information form where a player picture is stored. When I first wrote the program I was able to upload a picture no problem from my computer, I had a crash and now when I try to load a picture it takes three times as long and all that shows in the picture window is the picture name. Did I lose a setting or a program during the crash? Hope this makes enough sense.
View 4 Replies View RelatedI am using MS XP Prof and MS Access 2003. I have built a database for my model car collection. I have tried to creat a form that I can insert a picture of each model per record( similar to the Employees form in the Northwind sample database. I have all the catagory fields and labels and character boxes working fine but I need to know what sort of catagory or box to enter in the design so that it will accept a picture from the files in Jasc Paint Shop Photo Album. I keep getting an "OLE server" error If I need to I do not know how to open and install the OLEserver or register it necessary.
I'm totally frustrated.
Thank you,