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
trying to get; add picture, done. i´m using the northwind example in my database. below is the code behind my form.
Code:Option Compare Database Option Explicit Dim path As String Private Sub cmdExit_Click() DoCmd.Close End Sub Private Sub cmdMenu_Click() DoCmd.Close DoCmd.OpenForm "frmMenu", acNormal, , , acFormReadOnly End Sub Private Sub cmdNieuweFoto_Click() getFileName End Sub Private Sub Form_RecordExit(Cancel As Integer) ' De label errormsg verbergen om te voorkomen dat het scherm ' knippert bij het navigeren naar een andere record. ErrorMsg.Visible = False End Sub Private Sub cmdFotoVerwijderen_Click() Me![ImagePath] = "" hideImageFrame ErrorMsg.Visible = True End Sub Private Sub Form_AfterUpdate() ' Query opnieuw uitvoeren op de keuzelijst met invoervak ' Superieur nadat een record is gewijzigd. Vervolgens de ' label errormsg weergeven als er geen naam voor het ' fotobestand is ingevuld of de foto weergeven als een ' geldige bestandsnaam is ingevuld. On Error Resume Next showErrorMessage showImageFrame If (IsRelative(Me!ImagePath) = True) Then Me![ImageFrame].Picture = path & Me![ImagePath] Else Me![ImageFrame].Picture = Me![ImagePath] End If End Sub Private Sub ImagePath_AfterUpdate() ' De foto van de medewerker weergeven zodra het fotobestand ' is geselecteerd. On Error Resume Next showErrorMessage showImageFrame If (IsRelative(Me!ImagePath) = True) Then Me![ImageFrame].Picture = path & Me![ImagePath] Else Me![ImageFrame].Picture = Me![ImagePath] End If End Sub Sub getFileName() ' Geeft het Office-dialoogvenster Bestand openen weer van ' waaruit een fotobestand voor de huidige medewerkersrecord ' kan worden gekozen. Het geselecteerde bestand wordt in het ' besturingselement voor afbeeldingen weergegeven. Dim fileName As String Dim result As Integer With Application.FileDialog(msoFileDialogFilePicker) .Title = "Foto van medewerker selecteren" .Filters.Add "Alle bestanden", "*.*" .Filters.Add "Gifs", "*.gif" .Filters.Add "Bitmaps", "*.bmp" .FilterIndex = 3 .AllowMultiSelect = False .InitialFileName = CurrentProject.path result = .Show If (result <> 0) Then fileName = Trim(.SelectedItems.Item(1)) Me![ImagePath].Visible = True Me![ImagePath].SetFocus Me![ImagePath].Text = fileName Me![merk].SetFocus Me![ImagePath].Visible = False End If End With End Sub Sub showErrorMessage() ' De label errormsg weergeven als het fotobestand niet ' beschikbaar is. If Not IsNull(Me![foto]) Then ErrorMsg.Visible = False Else ErrorMsg.Visible = True End If End Sub Function IsRelative(fName As String) As Boolean ' Onwaar als resultaat geven als de bestandsnaam een station ' of UNC-pad bevat IsRelative = (InStr(1, fName, ":") = 0) And (InStr(1, fName, "\") = 0) End Function Sub hideImageFrame() ' Het besturingselement voor afbeeldingen verbergen Me![ImageFrame].Visible = False End Sub Sub showImageFrame() ' Het besturingselement voor afbeeldingen weergeven Me![ImageFrame].Visible = True End Sub
the remove picture button works fine, the picture is actualy removed from the database. but the add picture buton wont work, i get an error. i have a idea wy. the northwind DB uses text in its table for the picture ( to define a path). but my database is using OLE object in the table for the pictures. i select add object » use file » and browse for the pic (and fill the checkbox to merge the pic with the DB). northwind uses "getFile" (opens a file browser) to define a path and i think it´s only text based and won´t work with OLE objects.
does annybody know the code to get the OLE Object browser (see atached pic).
to make it short: neet the code to open the OLE Object browser (if there is a code). if somebody thinks the problem is something else, tell me plz.
thanks
I want to know how to display picture in object frame in a form ?
I would like to select the data from a table ...
Hello
I am using Access 2003(11.6355.6360) SPI
When I attempt to create a new DB - by performing Blank Database I immediately get a message 'Object Library not registered'.
If I 'OK' that box and try to create a table, I can do so - create Table in design view.
When I then try to Import external data - an excel file I get the message 'ActiveX component Can't create object'.
I have looked ob various sites for help and forum information regarding these errors but have found nothing conclusive, with specidfic regard to Access 2003.
The version has been loaded on my machine about 1 year as part pf Office Professional but this is the first time I have attempted to run Access itself.
Does any forum member have any ideas as to how this problem could be resolved.
Thank You
Rgds
Paul Langham
I am currently building a database for the company I work for that is fairly similar to the Northwind Database; however it is made from scratch so hopefully some of the common problems with that database won't find their way into mine.My problem is that when I go to my Orders form, I pick a customer from the main form, which creates a record on the Orders table. When I then go to the subform to choose a product/line item, I get the error in my title ("The LinkMasterFields property setting has produced this error: 'The object doesn't contain the Automation object 'OrdersT.") as soon as a product is chosen from the drop down list.
View 1 Replies View RelatedThe error is:
The LinkMasterFields property setting has produced this error: 'The object doesn't contain the Automation object 'tblIndividual.' '
Then it also gives me the same one on another table.
I think it has something to do with the link master/child fields. I've tried all kinds of relationships with the three tables and can't figure it out.
I've tried uploading the database here but it won't. It's on my Sky Drive.
[URL] .....
I'm getting an error message (informational only):
The object doesn't contain the automation object 'ClientID.'You tried to run a visual basic procedure to set a property or method for an object. However, the component doesn't make the property or method available for Automation operations.
Check the components documentation for information on the properties and methods it makes available for automation operations.
This happens when I start entering data in the field "productname" of a subform.
So I'm assuming something in the form or in the code of the form is referring to ClientID. but I've checked it, and there is nothing referring to it anymore. Well, at least as far as I'm aware of.
This afternoon access crashed without any error, it just closed. Upon reopening the DB again, all my work of the past one and a half week was gone. Normally I always backup the data, but these past days I didn't due to christmas and still working a lot too. So I forgot.
I did some redesigning in the process this evening, deleting and adding some fields and code.
I can't get rid of this error. Can anyone help? Or point me in the right direction?
Also the DB is 3.5MB in size. While it is completely empty. And I can't imagine that some empty tables, queries, forms and a bit of code can be so much. But that's for a later time to worry about I guess, unless one of you says: this and that, maybe that works... Otherwise, I would really be very glad already if the error disappears....
I am creating an form in a database and whenever one of my procedure's run it creates this error message:
The expression ON Load you entered as the event property setting produced the following error:
Member already exists in an object module from which this object module derives.
*The expression may not result in the name of a macro, the name of a user-defined function, or [event Procedure].
*There may have been an error evaluating the function, event, or macro.
An ideas?
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 RelatedIn 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 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:)
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.