General :: Control Source - Creating Image Based Off Drop Down Result

Feb 3, 2015

I am trying to create a image based off a drop down result. I have had no problem with setting up a image based off a static number. e.g 0456432 in the student id field will bring up students photo in the network share.

What I am having an issue with is the control source will look for a number instead of the name that the drop box displays. this is due to a separate table for the drop box.

what is the expression i need to make in order for the name to appear from the dropbox rather than the source id number?

View Replies


ADVERTISEMENT

Help With Creating A Image Based Form

Feb 21, 2006

Hi all,

Right trying to create a database that is centered around displaying images.

I already have my forms and navigation working fine but need some help with the images. what i would like, if possible, is on the forms one image is displayed but it has navigation buttons underneath to switch between images in the form. nothing fancy just that!

if anyone has done this before or has any ideas it would be greatly appreciated!!

cheers

chris

View 2 Replies View Related

Forms :: Show Image Based On Another Control Value?

Nov 5, 2014

I have a text box [txtTrafficValue] that is a calculated field of two short times. I want an image to be visible if the value is >= 0.0104 (15 minutes). I have in the after update of the field:

if me.txtTrafficValue >= 0.0104 Then
Me.imgWarning.visible = true
Else
Me.imgWarning.visible = false
End if

but when the field does the calculation and updates the image is not appearing.

View 5 Replies View Related

Forms :: Continuous Subform - Control To Display Image / Icon Based On Another Field

Jan 9, 2014

I have a continuous subform which queries a table of attachments. I'm using Access 2007 but not using the Attachment datatype; this DB will grow considerably and I don't want to waste precious space by filling it with bulky files. So instead, I have code which makes a copy of the attachment and adds the hyperlink (to the copy) to the table instead.

Now - I want to add a control to the subform to display an icon / image reflecting the file type of the attachment (Word doc, Excel s/s, PDF etc.)

But not sure how to go about it.

I was thinking I could use FileSystemObject.GetFileExtension at the point in the code where the attachment is added, and add a new field to my attachments table (i.e. translate "*.xls*" to "Excel", etc.) Then store / embed a handful of images for the core types I would expect and use an image control on the subform to display the image based on the value of that field.

But is that even possible / feasible?

Or, is there a handy API which can retrieve the icon associated with a file type based on what has been installed on the local machine (even if there is, there's still the problem of setting up the image control to display the appropriate icon specific to each record...)

Or, is there another control available which would be better suited to something like this than an Image control?

View 4 Replies View Related

General :: DLookup In Control Source

Sep 26, 2014

I have a 2 unbound text boxes.1 populates the id number from a table.I want the other to display the first name where this id occurs. I am currently putting this in the control source of the seconded textbox

This is what I have

=dlookup("[FirstName]","[tblUser]","[ID]='[Textbox1]")

View 1 Replies View Related

General :: Control Source Via Combo?

Jan 5, 2013

I have a combobox containing the "Field Names" of a table called "Main" Also, I have a report called xyz which only has one field.

All I want, whatever field name user selects in the combo, report displays the results of selected field name only.

example

Main Table has three fields (Fie1, Fie2 and Fie3) The combo box lists the names of all three fields (Fie1 to Fie3) Report has a textbox in the detailed section.

I want user to select the field name from combo click button to generate the report (lets say if user selected Fie2) and want textbox to list all the records of Fie2

i tried [Forms]![Fm1]! [cm1] but it is listing the field names not the values in the field...

View 1 Replies View Related

General :: Control Source In Property Sheet

Aug 3, 2012

My question is in Access 2010 I am currently in the property sheet at a combo list i just added to a form to be more precise with the data the user will look for. My question is I know I have to be in Control source in order for the combo box to select the data that I entered from the table. When i click the arrow the drop list is empty and then when I click the elipses (three dots) it takes me into expression builder, so i am confused on what I should do to select the field I want the combo box to focus on.

View 2 Replies View Related

General :: Using Table As Control Source For Dropdown Box?

Apr 6, 2013

Is it possible in access 2010 to create a table "Kits" with 4 columns: kit, lot, expire_date, in_use.

Then in a form use that table as a control source for dropdown box? However, if in the table in_use is "No" then that row is not a choice?

View 3 Replies View Related

General :: Creating Invoice Button - Action Query Cannot Be Used As Row Source

Nov 29, 2013

I've created a simple database, with tables, forms etc but I've got stuck when I've tried to insert a 'Button' onto the HOME page which when pressed will display an invoice and give you the option of emailing to client or printing.

I think I've gotten messed up in my relationships or the macros which I've copied from another access template.

on the home screen, I click 'new quote' then 'view quote' when the window pops up and then when it tries to generate the invoice I get the error

'an action query cannot be used as a row source'.

I've put a copy of the database in my dropbox...

View 8 Replies View Related

General :: Control Source - Set Value Of A Combo Box To Time Field

Oct 10, 2012

i have a list box with 6 columns. in column 6 there is a time field. on selecting this list box i want to set the value of a combo box to the time field.

so in the control source i put

[Forms]![frmAppointmentTreatmentItems]![comboTreatmentDuration]![Column](5)

This has no effect. I am not sure if i have done this correctly. but the combo box has manual values in it. the reason i want to have values in it is so if the treatment is 45 minutes at default. But i want to change it to 30 minutes just for a single occasion then i thought that this would be the way to do it.

View 11 Replies View Related

General :: Use Drop Down Control In Service Order To Select Customer

Mar 1, 2014

I have a client table.
I have a client product table for ski's
Each Client has 1 or more products (skis)

I have a Service Order table and form that I use a drop down control in the Service order to select the customer.In the Service Order Form a I have a continuous Subform for detailed service.

This is where I'm having the problem.In the detail subform I want to select from a drop down box the customers particular ski that I want to service. how to have only that one customers ski's to show up.

View 14 Replies View Related

General :: Cannot Find Specific Field On Control Source List

Sep 17, 2014

I am relatively new to Access and i am wondering why i cannot find a specific field from a table on the control source when i am and attached it to a check box.

I have created the field on the table, and now i want to attached it to the check box on a form however when i go down the list of control sources i cannot see it.

View 3 Replies View Related

How To Embedd Image In Image Control Using Imagelist.

Feb 6, 2005

Hi all ,
Can anyone tell me about how to embedd image in image control using imagelist.
I added the 5 images in imagelist at design time and added the following code.
image.picture=imagelist.listimages(1).picture
but iam getting error.error no :2110,cannot open the file .
thank u,
Siva

View 3 Replies View Related

Remove Record Source/Control Source

Sep 19, 2005

I have an unbound form with three tabs. On each tab there is a sub form. Each tab is a search form and each sub is a results returned. I have made everything unbound and set the sub form recordsource and its controls control souce on afterupdate of the main form search criteria. Works fine except for after some use the db decides the sub forms are not unbound and sets the record source and control sources.

I'm trying to do a

Me.PollingPlacesResults.Form.RecordSource = ""
Me!PollingPlacesResults!PollID.ControlSource = ""


but this does not seem to work in actualy removeing the record source and control source.

View 14 Replies View Related

General :: Creating Pop Up Based On Conflicting Dates

Nov 12, 2014

- I currently have a table that is labeled WorkSchedule. I then Created a query called WorkSchedule Query.

- The column labels are as follows (listed from right to left): Project, Event (something inside of the project), Employee1, Employee2, StartDate, EndDate

- I created a split form that shows each record.

- On each record I made the employee1, and employee2 as a drop down box that allows you to pick from all employees.

*MY QUESTION*

How do I make a pop up form appear when there is a conflicting date based on the employee I picked?

For example: If I had assigned Rebecca to an event that went on from 11/12/2014 - 11/14/2014. Then I tried to assign her to another event from 11/13/2104-11/15/2014. I want a pop up message saying that these dates conflict.

View 2 Replies View Related

Forms :: Invalid Control Property - Control Source

Sep 24, 2013

I added a new field to one of my tables and query, but when I try to add a control for that field into my form it is not recognising it and the field isn't appearing in the sources for the form, even though the table is sourced to the form? Or am I going to have to do the usual and redo the entire form because I made a minor adjustment?

View 1 Replies View Related

New Field Does Not Show In Control Source For Form Control

May 28, 2015

I have table that I had to add a new field to which we update with a form. I tried to add a control for the new field but the field does not show up in the list for the control source. I am trying to add a list box to the form with a blank and 5 options.

I have attached screen shots of the table design and the form. The table has the field in datasheet view and I have manually entered a few entries in it but it still will not show in the control source for the form control. The top section of the form is where we enter and select the data for the new records. The bottom section (circled in red) autofills the matching record, from separate tables, for updating with the new entries.

I have added form controls for modified fields in the past so I am confused about why this is happening.

View 2 Replies View Related

General :: Filtering Listbox Based On Tab Control

Jul 24, 2014

So I have a Tab control. Each tab is assigned to a specific user (which is controlled through another form). So If I assigned Page1 to Smith then Page1 caption reads Smith. Within each page is a list box that is filtered based on what name is in the caption. This works perfectly. My problem is I have another list box that is not within the tab control. I wan this to be filtered based on what tab is active. Both list boxes are bound to a query.

View 4 Replies View Related

General :: Creating Entries In A Table Based On Multivalue Lookup

Aug 3, 2014

I am designing a database for a quarry for maintenance of their machines. I have a table that has a full list of all the parts on the machines, and a multiple value lookup field that says what machines said parts are used on. I am trying to have these values translate to another table, so I can then insert a field to say how many of each part are used on the respective machine, to display on an information form for each machine.

I would also like this table to update if the relevant information is updated, for example if a new machine is input, then have the table update to reflect what parts are used on it (an After Update function?) I have made a query that gives me the read out I want (attached) but just cannot figure out how to get that into a table so I can add the extra information.

View 1 Replies View Related

Calculation....need To Drop The Decimals In The Result.

May 2, 2008

Here's what I have so far...and it works fine; however, some results have decimal places; i.e., 2.1666666.

I just need the result to be the whole number. I can't seem to get it to come out that way...I've used "round"...but I must not be putting it in the right part of the formula.

TEST: IIf(Year([EndTerm])>Year(Date()),0,IIf((Year(Date())-Year([EndTerm]))/[Renew]<1,1,(Year(Date())-Year([EndTerm]))/[Renew]))


Thank you for any help!
Carol

View 2 Replies View Related

Enter Result According To Drop Down List

Oct 11, 2011

I'm trying to write a DB to record lab results within a specification limit, and run a report to print the results on a certificate based on an automatically generated batch sample number.

In tables I've managed to get a drop-down list for the 'product type', and another for a list of the tests associated (multiples allowed) with that particular type fluid type. What I'd then like to do is add result/values for each of the tick boxes selected. Currently I just get a list of the tick boxes selected.

Currently I have:

Name (select from other table)
Fluid Type (select fluid 1 to 5 from another table)
Test (test 1, test 2, test 3, test 4... ...test 8) this is where I can select multiples from tick boxes

I'd then like to type a result for (e.g.) test 1, test 4, test 6 or whatever tick box was selected. Is this possible??

I realise a workaround would be to list all the possible tests as columns and just fill in the relevant column.

Better still would be to select a fluid type, and this opens another form with minimum and maximum allowed values, where I could enter the data - can I do this and keep unique IDs for each sample?

This is with access 2010....

View 3 Replies View Related

General :: Adding Count To Result Of Query Depending On Month And Result

Aug 18, 2013

I want to add a number to my results within a query depending on the month and how many results. For example I have 10 results in my query 3 from January, 5 from March and the rest from April. The 3 from January would be 1,2,3. The five in March would be 1,2,3,4,5 and so on. Is it possible to do?

I'm using access 2003.

View 4 Replies View Related

Reports :: Result Of Drop-down From Query Puts X In 1 Of 19 Boxes

Jul 15, 2014

I have a query which works perfectly fine, it's the report that I'm having issues with displaying correctly.

My report is a daily personnel accountability report that shows where everyone is for the day. Instead of having a cumbersome query like I did before, I have opted to just use the results of the selected drop-down option to move the X to the appropriate box of where so-and-so is for the day.

Using

Code:
If [marked_as] = 1 Then
Me.Morning.Value = "X"
ElseIf [marked_as] = 2 Then
Me.Afternoon.Value = "X"
ElseIf [marked_as] = 3 Then
Me.Evenings.Value = "X"
End If

I was unable to get it to work accurately outside of showing the three dummy names under the same column, even though the three dummy names were each placed in one of the three test categories.

I have this set as a private function called when the report loads, which is based on a query that filters down to the exact department or office (depending on the user's selection). Like I said, that part works fine, it's getting the code to accurately display in the correct column.

View 14 Replies View Related

General :: Any Way That Access Could Create A Drop Down Box Within A Drop Down Box?

Jul 24, 2012

Is there anyway that access could create a drop down box within a drop down box? For instance, when a selection is made in a drop down box, it opens another drop down box with choices.And is it possible to link an inserted image from a form to open in MSPaint that when it opens, the image is already there?

View 1 Replies View Related

Where Is Image Control On The Toolbox?

Dec 22, 2006

I am going crazy!!. I want to use .jpg images in my Access Form (Access 2003). All the tutorials and forums talk about using Image Control to display .jpg images. But I can't find the Image Control on the toolBox??? Where is the Image Control?? I am currently useing Unbound Image Control but that only allows me to display .bmp images.

Help!!!

View 2 Replies View Related

General :: Drop Down Box Which Effects Another Drop Down Box?

Jun 18, 2013

I have a drop box that has four selections from a table (NORTH, EAST,SOUTH or WEST) I also have a another table that has two fields which is a NAME of a person and either NORTH, EAST,SOUTH,WEST depending on the persons name. What I need to happen (within a form) is that when I select NORTH from a drop down box, I can then select names in another drop down box that correspond to NORTH only. Then only names from the South list if I select SOUTH etc

View 2 Replies View Related







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