Linking Images To Combo-Box Selections
Aug 5, 2005
I currently have a form with a drop-down combo box that is used as a tool for selecting an employee's last name. After selecting a name, the text boxes below the combo box are updated to match up with the selected name.
However, I am trying to get the employee images to do the same thing, but it's not working. The employee photos are currently "Bound Object Frame" items. Any suggestions/help would be greatly appreciated.
Thanks in advance. :)
View Replies
ADVERTISEMENT
May 9, 2006
Hello Access heroes..
I'm using the following code to dynamically link to images in a popup form:
thisPicString = GetPath(CurrentDb.Name) & DLookup("details", "infoTbl", "Item = " & Chr(34) & "Image Folder" & Chr(34)) & ""
MsgBox thisPicString
Me.Image1.Picture = thisPicString & "DNA.gif"
Me.Image17.Picture = thisPicString & "wDNAslogo1.gif"
Me.Image18.Picture = thisPicString & "defralogo1.gif"
The thing is, it finds the images fine, but before it does this I get an error saying Access cannot open the file name xyz.
xyz is the path the picture has originally, but doesn't exist anymore.
Any ideas? I've tried this code at _Open, _Load and _Current, but all to no avail. At what point is access trying to link to these images? Can I get the code in there first?
Cheers,
View 3 Replies
View Related
Jul 12, 2005
I have a combo box in a form. The box is linked to a table called Therapy with 3 fields: TherapyID, Therapy_Type and Therapy_Cost.
The table has been populated with 5 records:
1 Physical Therapy $125
2 Occupational Therapy $125
3 Acupuncture $90
4 Swedish Massage $65
5 Raindrop Treatment $65
I have a field on the form that pops up the cost when one of these is selected in the combo box. This seems to be working but for some reason, and it's blowing my mind, the combo box refuses to let me select Occupational Therapy or Raindrop Treatment.
I have other pick lists of other things working perfectly well, allowing all selections and popping the costs into their little text fields quite happily.
Can anyone give me a hint as to why THIS one isn't working right?
View 5 Replies
View Related
Jan 27, 2005
I would like to select multiple records from my combo box not at the same time but each selection to be added to another text field in my form.
PROBLEM: When I select a record that 1st selection is populated in the other text field however when I want to select another choice to be added with the 1st choice the selection overwrites the 1st choice instead of adding to it.
View 4 Replies
View Related
Feb 14, 2006
How do I allow the user to select more than one answer in a combo box? It is a drop down menu with several choices. I'd like the user to be able to select more than one if desired and all choices would display when queried. Thank you much. :)
View 4 Replies
View Related
Oct 1, 2006
Howdy all, Ive got combo boxes, in a cascading style working well... but what id like to also have is a another dropdown list that shows the last 5 selected options (because often the data will be entered in batches and it should just save time)there is combo1 combo2 and combo3 If Sport is selected in combo1 then it displays combo2 with all the sports in it, so if golf is selected then the golf options come up in combo3 for example tiger, So id like to store Sport > Golf > Tiger Ive already got the value for Tiger being selected, so I can assign that easily enoughWhat id like to be able to do is store the name and its value in a combo box maybe showing the last 5 selections. Im just not sure what the best way to go about this would be, Should I make a table with say 5 rows? or is there a better way to go about it?Any thoughts or advice would be awesome,Cheers Ezy
View 3 Replies
View Related
Apr 9, 2015
I'm working on a database where users enter an assignment into a datasheet form. Assignments are selected from a combo box that has values stored in a table. After choosing the assignment, the user adds the date it was completed. After this is done, I would like the "Next Due" column to update. Each assignment will have a different next due date, such as one year from the completion date, six months, etc. I don't know how to add different values depending on the combo box selection.
View 5 Replies
View Related
Jan 24, 2006
Hello
I need to create a form or a subform that brings up a list of records based on criteria that a user chooses in multiple list boxes. Is this possible? I am pretty new to Access.
Thanks,
albritm
View 1 Replies
View Related
Mar 10, 2006
Hello people,
Say for example, in two fields within my dropdown for Camera Status in the Maintenance table...
FIT FOR PURPOSE - Availability Checkbox = Yes
What expression do I need in expression builder, so that Selecting UNDER REPAIR or FAULTY/DAMAGED instead makes the checkbox availability turn to unchecked automatically within a form, without the need to manually change the checkbox?
How do I do this?
Thank you.
Neil.
View 1 Replies
View Related
Apr 11, 2006
Hi all,
In my database, different Customers have different Rates.
I am trying to run a query that will pull a value dependent upon The Service Type & Customer that have been selected from combo boxes.
My database tables are as follows;
(Rate Profile Table)
RateID
ON8
ON11
SD
(Customer Profile Table)
CustomerID
CustomerName
CustAddress
RateID
(Shipments Table)
ShipmentID
WaybillNo
Date
ServiceTypeID
The ServiceTypeID is selected on the Shipments Form by making a selection from a combo box that has been populated by the RateID Table Field Names (which are the service types).
Everything works fine but I need to be able to run a query to calculate the freight charge (from the appropriate rate in the Rate Profile Table) according to which Customer & Service Type has been selected, but not having much joy.
I would be extremely grateful if someone could point me in the right condition.
Thx...
View 8 Replies
View Related
Apr 7, 2015
I currently have a combo box that filters form based on specialist (an employee using the system), and this works fine:
Private Sub FilterSpecialist_AfterUpdate()
Me.Filter = "SpecialistAssigned = '" & Me.FilterSpecialist & "'"
Me.FilterOn = True
End Sub
When Specialist Assigned name is selected, it only shows their cases (records of the form that are assigned to them).
However, now I'm trying to also filter based on only the selected Specialists Open cases. I have a combo box at the bottom of the form that saves whether the Case is Open or Closed, (creatively) called CaseOpenClosed:
Private Sub FilterSpecialist_AfterUpdate()
Me.Filter = ("SpecialistAssigned = '" & Me.FilterSpecialist & "'" And CaseOpenClosed = "Open")
Me.FilterOn = True
End Sub
I've tried this based on me searching the forum but it doesnt filter at all anymore, and no error either. I've tried other ways but get errors. What is wrong with this?
View 5 Replies
View Related
Mar 24, 2005
is there any way to get a picture into a listbox or combo box?
ie:
[image1] option1
[image2] option2
etc..
kinda the way outlook does their labeling feature. thanks
View 4 Replies
View Related
Jan 30, 2015
How to correct the issue below. I created a split form and I have 2 combo boxes that allow multiple selections. The one combo box for LOB (line of business) works perfect and does not create duplicate records in the datasheet view of the split form. The 2nd combo box with multiple selections creates duplicate records in the datasheet depending on how many selections are made.
I have checked this in the underlying table and there are no duplicate records, it is only in the split form datasheet. I have checked settings and configuration between the 2 combo boxes that are reacting differently and they appear to be identical...
View 7 Replies
View Related
Sep 12, 2012
I am trying to get a series of combo boxes to interact and record the selections made in new records within a destination table. Here is situation with respect to the tables involved:
1 table lists the names/acronyms of various research facilities and the branch to which they belong (acronym is PK)
1 table lists Financial Points of Contact for each facility (acronym is FK to relate to earlier table)
1 table lists Technical Points of Contact for each facility (acronym is FK to relate to Facility table)
1 table lists program participants and the branch they belong to (Branch in FK to relate to Facility table)
I am trying to create a form that allows me to set the participant and, from this selection, restricts the facility choices in the Facility combo box to those that fall within the branch to which the participant is assigned. I think the next step is pretty obvious too. Once the facility is selected I have combo boxes that would only display those Financial and Technical PoCs assigned to that facility.
I have watched the 4 Data Pig tutorials and I can easily make functional cascading combo boxes as long as they only refer to the look up tables. I generated perfectly functioning cascading combo boxes on a test form. How do I generate combo boxes that will then store the info selected in my destination table? Whenever I try to set a Control Source it disrupts the functioning of the queries.
View 4 Replies
View Related
Mar 14, 2007
Is it possible to link two combo boxes together e.g. i have combo box 1 with a list of products and combo box 2 with a list of each of the products corresponding product codes. basically if a select a product e.g. football from combo box 1 i want the footballs product code e.g. 001 to be displayed in combo box 2. i hope that makes sense, can any one help, thanks.
View 2 Replies
View Related
Feb 19, 2008
anyone able to help me, i need to link 2 combo boxes using the same two different tables,
View 8 Replies
View Related
Dec 20, 2007
I have created a database for tech calls that come into my office.
I have created two tables with information i need on my form
table 1 = Office Location ID and Office Location (ie Chicago and other towns)
table 2 = Employee ID, Employee, and Employee Location Code (ie Chicago = 1)
I have created a form with the fields that i need to record all the data.
What i want to do is create a Combo box for office location and place the 3 office locations via a field list. I then want to setup another combo box that would display only the employees that are part of the office location that was selected in the previous combo box.
If anyone could assist me in this it would be greatly appreciated.
View 1 Replies
View Related
Jan 12, 2005
Hi.
I have created a database for an old office filing system in work.
There are 2 tables – Files & File Contents.
Table ‘Files’ has 5 fields: ID; Number (e.g. 1/03); Title; Status (e.g. Live/Closed – created a list on the relevant form using the Lookup wizard when creating the table) and Referenced To – at some point in the future all these files will be closed and this last field will show what all future correspondence is filed on.
Table ‘File Contents’ basically lists all correspondence on every file. But, some of the files have categories exclusive to them.
In the form ‘File Contents’ if someone was inputting new correspondence I would like the category lists to show just the relevant category for that file, i.e. if File 1/03 Training is selected then the 3 Training Categories will show and if File 5/03 is selected then the 2 categories relevant to it are shown.
But I don’t know how to do that…..
Should I create new tables for each of the ‘Files’ showing the categories or would one category table do?
I would be grateful of any help/advice you can give me.
Thanks.
Philip
View 1 Replies
View Related
Mar 2, 2005
Hello!
I am working a new solution that I figured I would try, I am normally a web based data man. I have worked with a lot of SQL and server side code, but to be honest, I have never really used Access in depth. And so I am facing some problems, that I know are possible, but I am not sure on the syntax or method of doing it. Perhaps I could get some good help:D
Simple example: I have 1 combo box on a form populated with a query, I want to be able to when that cb's data has been selected to populated another list based off of what was selected. How do I accomplish this? Thanks for any help!
View 2 Replies
View Related
Mar 13, 2005
I'm creating a database to assist with the sales operations of a hat shop. I have a form for creating new orders called 'Invoice' where the order number and date is set.
Within this form is a subform called 'Invoice_Order' (Continuous layout), this form is used for assigning order items to an order number.
Within the subform there are two combo boxes which search the Stock table.
1st ComboBox- diplays hat styles (E.g- v1/v2/v3/v4...)
Problem is; different hat styles are available in different colours based on the material used. I would like the second CoboBox to display a list of colours depending on the style of hat chosen.
At present i can only get it to display a list of colours for all hat styles.
Does that make sense?
Any help would be most appreciated
View 4 Replies
View Related
Sep 13, 2004
I am creating an orders form based of a query that has joined an orders query and a customer query.
What I want is in the order form when a Customer is selected then the address & contact information is automaticly populated in
following text boxes.
Thanks
- a noob
View 2 Replies
View Related
Apr 6, 2014
I have a text box on a subform that I want to use to control a combo box on the main form - I know it's not how things should be done but I've no choice - these are my instructions. I'm using Access 2000.
The text box displays a short data in dd/mm/yyyy format and when data is entered into it, it populates a field in Table 1. The combo box displays all the months of the year which it obtains from another table which only has months in it. The combo box properties have Limit to List set to Yes. Once a Month is selected, it populates the month onto another Table, Table 2. The months have all been assigned with a numeric identifier (i.e. 1 for January and so on) but only the name of the month appears in the combo box.
What I have to do is have the combo box update the month it displays based on the short date in the text box. I've tried the After Update event on the text box to no avail. The code I tried there that didn't work was:
Quote:
Private Sub txtDate1_After Update
Me!txtDate1 = Me!cmbMonth
End Sub
I've tried similar code in the On Enter even for the combo box and this too failed. I've also tried switching off the Limit to List property of the combo box and this didn't work either.
I've also tried to set the combo box so that it links to the exact same fields as the text box and while this did work, all it did was have the date be displayed in the combo box in short date format and not as the name of the month.
I'm struggling to understand if this update is even possible. Can a combo box that has a Row Source limited to options in one table which it then updates onto a field in another table be controlled by just part of the date from a text box?
View 13 Replies
View Related
Apr 18, 2006
Hi all,
i need help regarding linking Access to various Word documents.:confused:
the task consists in choosing a particular Country, Year and Month from Combo Boxes and then view the related reports in Word.
for example : United Kingdom, 2006, January
more than one report can be related to a particular country.
is there a way this can be done? (maybe through the use of LookUp for the folder path?!)
any help will be much appreciated.
thanks.
View 1 Replies
View Related
Jan 25, 2005
I am facing a problem. i am very amateur at access. I want to design a form on which there is one combo box and one command button. If i made a selection from the combo box and clik on command button it should show all the details related to that particular selection (say Shop Order) on a report. I dont know how to link this things.
report may be like..
Shop Order Description Length Width Hight..
Ax12 xxxxxx xxx xxx xxx
Ax 12
for a particular shop order selection there may be no. of parts that should show on.
like an assembly thing. Suppose Shop order for a bag is A23 and its different parts are belt and chain...
now
SHOP Order description ......
A23 belt
A23 Chain...
i hope i described my problem..
please do help if you can..
Thank you
Hemendra
View 2 Replies
View Related
Dec 7, 2006
Hello
I need to select information from different combo boxes. Using a command button, i would then like the information transferred onto a list box.
I have so far managed to link all my combo boxes so the result comes out on a list box. if one combo box is left blank, i get no information in the list box. is there a simple way of doing this.
Thanks
Dharmesh
View 9 Replies
View Related
Jul 29, 2015
I currently have 3 tables within a database with student details of three different classes. I need to create a user form that has a dropdown box which I can select a student from one of these tables with a number of text boxes below which brings up all the students details, then once the student has been selected and the correct details are shown then I need to create a button which allows me to move that student from one table to another.
View 4 Replies
View Related
