Topics Search

Selecting field value from another multivalue field

Selecting field value from another multivalue field
Views: 0
In my database I have a table [tblEvents] that has a list of running events and some events have 2 or 3 possible distances. The [tblEvents] table has the following fields: evtID, evtDate, evtName, evtDistance. The evtDistance field is populated from a value list with multiple values.

A second table [tblResults] records runners times for the event and has the following fields: resID, memID, evtID, resDistance, resTime.

I set the [resDistance] field as a combobox fetching the values from the [evtDistance] field but I just get a single line option with the values separated by commas (5,10,21,42) instead of separate lines for each value.

Is it possible to populate the resDistance field from the distances selected in the [tblEvents].[evtDistance] field? How?
Sponsored Links:

More topics

 

query multivalue field for records w/ >1 value

Preview
In Access 2010, I have a table that contains a multivalue field. This field can hold from 1 to 7 values. I would like to create a query that would return only those records in which this field holds more than one value.

On a related note, I would like to create a calculated field that returns the number of values each record holds in the multivalue field
 

Creating UpDate Rules for Multivalue fields

Preview
I have two multivalue fields. One field indicates who should be trained on a particular document/procedure. The second indicates who has not yet been trained on the document/procedure.

So I've successfully created several "variable" queries which will show individualized reports (based on employee selection via combobox/form) showing Individual Training Plan (which shows all documents regardless of training status), Training Overdue, and Training Required (but not overdue).

So with these queries/reports I can track IF an employee has been trained, but not when. I've tried creating before and after update rules which will "audit" the changes made to these two multivalue fields, compare the data before the change and after.

Then depending on the comparison, assign a date when an employee has been unchecked in the "Untrained" field. I will also need the ability to store and display this date for each document/employee in the reports. I keep getting errors saying that multivalue fields cannot be read.!
 

Missing Check Boxes In Multivalued Fields

Preview
I'm sure its something simple, however I have spent 2hrs so far so thought I would post my question.

I have created a multivalue field which allows me to select many names which form s a circulation list for a report. The multivalue drop down works ox in table view, however when I am inform view the dro down is missing the check boxes.
 

Criteria query

Preview
I have designed a data base with the help of MS access, in this DB I have made a form which contains four fields, person name, status, priority and date. now I want to design a query with the help of which I want to select a criteria for generating a report for example if I want a report to be generated by only selecting person then it should generate the report, but the problem im facing is that I have to select all the field to generate the report and if I dun select any one field even it gives a blank report.
I want to design such query with gives a report by selecting any field and the field which is not selected is automatically skipped
 

Getting the sum from a multivalue combobox

Preview
In my reservations form I have a multivalue combobox(based on a lookup column) which displays the entertainment description(first column) and the entertainment price (second column). The user can select more than one options, how can I show the total of the entertainment price in a text box
 

Getting the sum from a multivalue combobox

Preview
In my reservations form I have a multivalue combobox(based on a lookup column) which displays the entertainment description(first column) and the entertainment price (second column). Theuser can select more than one options, how can I show the total of the entertainment price in a text box.
 

Multivalue List

Preview
I created a multivalue list in my table. It contains a list of names and a checkbox. I designed the form based on this and am able to check off multiple names. When I go back to look at the table, it stores in each name separated by a comma. So far so good.

When I create a report to display the data, it displays it as 1,2,3.etc., instead of the names separated by a comma.

What do I need to do to display the names
 

Selecting a corresponding table field based on text field.

Preview
For some reason cant quite wrap my brain around what should be a relatively simple problem.

Scenario:
User enters their login name in a field on a form. The form name is Login and the field is Text1. User clicks on a button, called Command1. Based on Text1, the form looks at the matching Associate field (ie, user enters michael and the record where Associate field is michael is selected) and its corresponding Pref1 field both which are in Table2. The Pref1 field holds a variable that determines which form opens up.

I presume the above is done with VBA for the Onclick event for Command1. What would the code look like? I realize a combo box would be easier than a text field but Im trying to make the db a little more secure by not displaying everyones login name
 

Maintain field value when creating a new record

Preview
I have a field on a form that I would like to keep the value when selecting new record.

The user entering data enters all the invoices for a given supplier, instead of having to go find the supplier in the list every time he would like for the field value not to be reset to blank when creating a new record.

Can this be done
 

Fields automatically filled in a new record

Preview
I'm trying to use a function to add a value to a subform field by selecting a value from a list box in another field. Only when I leave and go back to record again.