Related Topics

Selecting field value from another multivalue field

query multivalue field for records w/ >1 value
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
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
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
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
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.


Getting the sum from a multivalue combobox
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


Multivalue List
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.
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


Fields automatically filled in a new record
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.


Maintain field value when creating a new record
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


Combo Box Manipulation Tactics
MS Access 2010, Win7 x64 Enterprise, back end db is fine.

I'm presenting the user(s) a form, with a combo box that contains 2 columns, I can bind either one, but the value I want stored is numeric. -1 for "Not Known", -2 for "NotApplicable" and x for "Enter Value", where "Enter Value" is a known number > 0.
What happens is the user really doesn't care to see the -2 or -1, but they do want to know what it stands for, or they want to see the actual value they've entered into that field (when selecting "Enter Value").

I've found that the combo box does not like it when you want to display the text value of the field OR the positive numeric value of the field, but the combo box is the user-requested medium to present the field.

I tossed around the idea of a text box to store the value as well, and making it visible/enabled when selecting "Enter Value" but it doesn't seem to be viable.


Input Mask - Choice of Selection
I have a PostalCode/ZipCode field in a table which is based on the addresses for US or Canada. I would like the choice of selecting either. I have created an Input Mask for both Postal andZip Code fields and tried to bring both in with an OR in the field; however, one replaces the other.

Is it possible to have a choice created so that the user can choose without creating a separate field for each?


fields automatically filled in a new record
friends

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. But does not work with a new record. Only when I leave and go back to record again.
Someone has gone through a similar situation, you can help me.


Data Maintenance, Import/Export
Data entry consists of typing values in data fields or selecting values from bound controls. Some records happen to have the same value for a particular field, or most records hold a common value for a certain field. When designing a form, you can assign the most commonly used value to such a field so the user would not have to type it. The user would change the value only if it is different from the usual.


Two Tables, One Form
Such as selecting from a dropdown list and then saving the information to the table which it is made from. Would it bepossible to have a specific field in the form ALSO be saved to a second table with the same field?


More ways to Update a field in a table
members

Looking at the number of ways to update a field in a table; I had use the following 3 ways:

1. If there is a form opened bounded to the underlying table, I just assign a new value to the field, then on Form.Update, the change is reflected in the table.

2. I could .execute an Update query string wherein a particular record from a table is selected with a criteria and then update the target field.

3. I could .open an ODBC.recordset selecting again that particular record from a table using a criteria and then assign the !field and do .update.

The question: Is there another method to do the same, some sort of function like the Aggregate functions DSum, etc


Update Query selecting multiple values in one field
I have a table that contains a location field which is numeric that represents the county of the record. I want to update the Zone field so that different counties I,e, numbers are given different zone numbers.

Say I want to update the Zone field to 1 in the records where the infocode (which is the county code numeric) is equal to any of the following values 6,17,46,47,55 What is the easiest way to build this query?


Update Query selecting multiple values in one field
I have a table that contains a location field which is numeric that represents the county of the record. I want to update the Zone field so that different counties i,e, numbers are given different zone numbers. Say I want to update the Zone field to 1 in all the records where the infocode (which is the county code numeric) is equal to any of the following values 6,17,46,47, 55 What is the easiest way to build this query


Selecting x number of records from a table at random.
I have created a query using EmployeeID, a unique field and LastName. I have added a calculated field RandomNo: Rnd ([EmployeeID]). The query works, but I cannot sort properly on this field (I chose descending order).

The I was going to select the top 5 or whatever records, but can's do this. Isn't there a simple way to do this? Why not have a simple function inAccess? Or is there one?


Unbound text box will not accept any keyboard input
I have an unusual issue that I can't seem to resolve.

I have a table with a field named "Payee". I want the user to have a choice of free-form typing a name or selecting a name from a drop down. I initially tried to create a combobox control with LimitToList set to false, but this did not do what I thought I could do by setting this property.I was still limited to selecting from the drop down list only.

So I came up with an alternative, if unwieldy approach: