Combo Box /Sub Form /Picture
Dec 12, 2005
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
View Replies
ADVERTISEMENT
Dec 10, 2006
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
View 1 Replies
View Related
Mar 29, 2013
I understand that their are several ways to work with pictures and comboboxes. Working with an OLE Picture is not prefered. But I only need to add 5 little signatures. Previous attempts, like trying to connect with my SharePoint site and our server didn't work. So I have only one option left which is to work with an OLE object. Because the pictures (signatures) are just arround 15kb, I think it will not influence my database a lot.
Because I only have about 2 weeks experience working with Access, I can't enable to show the signature (Picture in jpg or bmp) when a person is selected in a combobox. I compared the code with several other posts but all do it very differently. Signature is an OLE field. In this field for each inspector I paste his Signature.
In the form I'm trying to show his Signature via a combobox. But I can't find out how I have to make the connection between the Picture field and the table were the picture is stored. And this in combination with a combobox. Here is my code were I'm struggling with:
Option Compare Database
Option Explicit
Private Sub Inspector_AfterUpdate()
Select Case Inspector.Value
Case "Inspectors_Name"
Me.Signature.Picture = Me.Inspector.Column(2)
[code]....
View 14 Replies
View Related
Dec 14, 2006
Hi all! i am wanting to display a signature (jpeg image) when a combo box is displaying "Yes" and the picture to be hidden when the combo box is either empty or set as "No". i have before managed to change colours of other fields depending on combo boxes - but my coding isnt that great, so i dunno what code is req'd!all help much appriciated!thanksDave
View 4 Replies
View Related
Aug 29, 2005
I 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
View 1 Replies
View Related
Jun 17, 2005
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
View 4 Replies
View Related
Feb 7, 2006
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?
View 3 Replies
View Related
Feb 7, 2006
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?
View 1 Replies
View Related
Aug 26, 2006
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
View 3 Replies
View Related
Sep 13, 2006
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.
View 1 Replies
View Related
Aug 14, 2004
I 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,
View 1 Replies
View Related
Dec 6, 2007
hi i am building a basic database for a friend. she collects stamps and this database is used to store some of the stamps that she wants.
i have it all setup so that she can type the name and all the info about the stamps, she can print it off and its all very user friendly.
now what i want is a button she can click to add a picture of the stamp onto the form used to put the data in.
how will i got about doing this? i ahve no idea where to start except i think i will have to make a macro???
thanks if anyone can help!!
Josh
View 3 Replies
View Related
Jun 22, 2006
Hi all,
I've a form with an image on each page which is linked (not embedded) to filenames from another table. When moving through the forms the time it takes to import the picture is relatively slow, is there any method or hack I could use to speed this up?
The code I'm using at the moment:
Private Sub Form_Current()
Dim Picture As String
On Error GoTo PictureError
Picture = Me.Clipping_UNC & Me.Clipping_File_Name
Forms!REPORT_Coverage_Clippings![Image].Picture = Picture
PictureError:
If Err.Number = 2220 Then
Forms!REPORT_Coverage_Clippings![Image].Picture = "m:setupimage.jpg"
Else
End If
End Sub
View 2 Replies
View Related
Aug 8, 2007
I have the need to put a company logo on a form based on the company selected from a combobox on the form. I have a table which has one field for company name and another field containing the picture object. The form itself is bound to a different table where I want to company selected from the combobox to be recorded. I want to make the form capable of displaying the logo (bound ole object?) based on the company selected from the combobox.
I think I am close, but I do not know the proper method for doing this.
View 4 Replies
View Related
Jul 9, 2013
Now I Making A FORM..... The detail i want is NEED INSERT PICTURE and DISPLAY picture in a box...
How to display a picture when i insert it? or other solutions to show a picture in the form after i attend / insert.
View 1 Replies
View Related
Jun 15, 2006
Hi Good-Morning (its morning here in Jamaica) (Whatever time of day it is where ever it is that you great minds are in this beautiful world we live)...
I created a form and used an image control with a filepathfield that is stored in my table,... that works well as far as displaying the correct picture for each record...
I now want to create a Continuous Form with the correct image displayed for each row or eachrecord///
The problem is all of the images are displaying the same picture, but i want them to show their correct pictures... I used an on current event which i guess is why tha is happening cause all the pictures change when different record selectors are clicked...
Please advise how i could get around this...
I looked at the Northwind database, but that database uses an OLE object, I would like to use the filePath field that i have in my database...
Any Ideas? Thanks in Advance
View 2 Replies
View Related
Apr 11, 2013
How can I lock a picture of an employee to his Employee record?
View 5 Replies
View Related
May 19, 2014
The form is specifically made to be wider than the screen, so that there is a scroll bar at the bottom. I have an embedded picture for the background which is intended to be the size of the form, meaning that the picture is also wide.
In Design view, I can see that the background picture fits the form perfectly, which is what I want to see in Form View.
In Form view, though, the picture is squished to fit the screen. The only time it doesn't do that is if I set the Picture Size Mode to Clip, but then it only shows a portion of it, and when I scroll horizontally, the background picture doesn't scroll with it.
View 4 Replies
View Related
Nov 17, 2012
In form I want to put a command where we can browse a picture and insert it...how to do ...
View 5 Replies
View Related
Jan 31, 2015
When I have a simple table, users pictures inside maps (jpeg,png...) defined as OLE object, when creating the form from that tables, don't have picture shown, only name of the picture? I tried all the options, package, copy, paste... nothing...always the same... just picture name but no picture.
View 1 Replies
View Related
Jul 30, 2013
I would like to set up a picture in the form that changes based on a combobox selection, for example if you select from combo box list "design1", a picture that have a name : design1 will appear as a background to the form ..
View 8 Replies
View Related
May 31, 2013
" Is it possible to toggle the visibility of a picture on a form's detail section for each row based on a query whether a certain condition is met? "
I have a form, which fetches data from a database and populates the content as a number of rows in the detail section.
For each row I want to test if a certain 'yes/no' condition is met on each query and the toggle the visibility on a picture that I have placed in the detail section.
I've tried seveal possible solutions now, like macros and VBA but haven't got it working.
Btw I'm using Access 2010
View 4 Replies
View Related
Mar 11, 2014
I'm creating a database for a flower shop for training purpose. I have a main form with a sub form that has the orders in it. when placing a new order for a client and selecting the product from the combo box, it would be great if the product could show up to the right in the form.
I have no clue if this is possible and how to get it working. I have included the database as an attachment, which way to follow. I remember that I could do this on a web page, but a web page is not the same as a database.
View 5 Replies
View Related
Mar 9, 2015
I am currently looking for a way to add data in a form with picture and then be able to view all entries with data.
Basically what I want to see is "product image > item number > client > description > material" with for example 500 entries, i want to be able to see a whole list of all entries. I would like to be able to make every entry as described above.
View 1 Replies
View Related
Mar 31, 2014
I have a form that currently uses a "catch all" table for listing available equipment to choose from for an equipment field. I call it tblEquipment. What I want to do is to make it so when I type a name in (1 of 35) in one field of the current record, the record source for the equipment field immediately looks at a different table that has equipment available only for that name. To do this I plan on making 35 different tables with limited data originally found in tblEquipment. I would call these tblEquipment1, tblEquipment2, etc. I do not use a sub form, nor do I want to.
So my questions are:
1) can this be done
2)If it can be done, how can I do it?
View 3 Replies
View Related
Apr 27, 2013
I have a Suppliers database which contains a form that will allow me to place orders with Suppliers.The Main form has a combo box that allows me to select the supplier. The combo box is called SupplierID with the following:
Row source: SELECT Suppliers.SupplierID, Suppliers.CompanyName FROM Suppliers ORDER BY Suppliers.CompanyName;
The subform is called Stock Subform witha combo box called ProductID with the following:
Row source: SELECT DISTINCT Products.ProductID, Products.ProductName, Suppliers.CompanyName, Products.Discontinued FROM Suppliers INNER JOIN Products ON Suppliers.SupplierID=Products.SupplierID WHERE (((Products.Discontinued)=0)) ORDER BY Products.ProductName;
Event Procedure - AfterUpdate: Private Sub ProductID_AfterUpdate()
On Error GoTo Err_ProductID_AfterUpdate
Dim strFilter As String
' Evaluate filter before it's passed to DLookup function.
strFilter = "ProductID = " & Me!ProductID
[code]..
The Link fields are done on the Purchase Order ID (PONoID).What I want to achieve is to select the supplier from the combo box (SupplierID) on the main form and then the combo box (ProductID) on the subform to filter to only show products directly supplied by the Supplier selected on the Main Form.
View 11 Replies
View Related
