List Box Control With Multiple Values Allowed

Jun 8, 2014

I have a Table with a short text field, field size: 20. The row source has been set up ie "Item 1", "Item 2", "Item 3", etc. Allow multiple values IS allowed.Once I drop a control on a form (list box) to represent the aforementioned field, I realize I can put a checkmark in many items. Why? I add up the total length of the items text at 40-50 characters, yet the field size is only 20. To check my sanity, I open the Table in Datasheet view and lo, I can see all the Items spelled out, in clear violation of field size constraints

View Replies


ADVERTISEMENT

Store Multiple Values From List Box

Jan 11, 2006

Hi all,

I was thinking/hoping of using a list box on my form to store multiple values, I haven't been able to find a way of storing any value so far so not sure how easy it will be?

How can this be achieved or is it just easier to use several check boxes (approx 8)

Thanks

View 3 Replies View Related

Use List Box To Assign Multiple Values To Records?

Jan 12, 2005

I hope the title actually conveys what I'd like to do.

I want to assign records on a subform to a group header on a form. For example, I have groups A, B, C, and D and I want the records on a subform to be assigned to groups A, B, and D. (The number of groups and their names will change so I can't simply use an "A," "B," "C" option box.) My idea is to have a Multi-Select List Box on the main form and choose all the groups to which the records on the subform need to belong. So I'd select the groups, enter the records on the subform, then create a another record on the master form and assign records to another group.

Is it possible to make this happen without a lot of programming?

View 2 Replies View Related

Modules & VBA :: Selecting Multiple Values From List In A Form

Dec 29, 2013

I am trying to use a list-control on a form to let the user select multiple values. I have understood that this requires some VBA-code to step through the selections in the list, since the "multivalue-selection" is set to "Extended".

When I try to execute the code I have (found and have tried to adjust), then I get the error message "Object required". The "ListCount"-paramater always only results in a ZERO-value, when i step through the code:

Function cmdOpenQuery_Click()
On Error GoTo Err_cmdOpenQuery_Click
Dim MyDB As DAO.Database
Dim qdef As DAO.QueryDef
Dim i As Integer
Dim strSQL As String

[code]....

View 9 Replies View Related

General :: Form Control To Combine Multiple Field Values Into A Single Text Box?

May 10, 2013

I'm trying to set the control source for a control on my report that describes the number of portions that goes into a box. Sometimes there is a specific number of portions per box and sometimes it's a range. When the number of units is specific, then it is entered into the MasterCaseMinUnits Field. If there is a range of units possible than the min is entered into MasterCaseMinUnits and the max is entered into the MasterCaseMaxUnits.

I want my report to look at the mastercasemaxunits, if it is blank it will only display what is in the MasterCaseMinUnits field. If there is a value in the masterCasemaxUnits field, then it will display the masterCaseMinUnits & " - " & MasterCaseMaxUnits. this is the code I'm Using:

Code:

=IIf(Nz([MasterCasemaxUnits],[MasterCaseMinUnits])=[MasterCaseMinUnits],[MasterCaseMinUnits],[MasterCaseMinUnits] & " - " & [MasterCaseMaxUnits])

When I run my report, the control displays: #Type!

View 2 Replies View Related

Forms :: Single Column Combobox To List Values From Multiple Fields

Apr 8, 2013

I have a data base with names, email IDs, phone numbers of 5 types(example quality, security, IT,finance etc) of person from ten different project teams. I created a basic form for the end user to enter values and created fields for each of the person's name, email ID etc based on the personal type( liek quality, IT, finance etc) on each team. The background table contains records of almost 200 people now.

All of these people will be trained for one task and some will be trained for multiple tasks. I know how to make the combo box allow multiple values/selections but, i cannot list out all 200 personal names in the combobox's rowsource/value list. Is it possible to combine all different name fields and list out all personal(of one team), so that the end user can just select multiple names for that team who have been trained and so on. i need to set the rowsource of the combobox to the values of all personal from one team so the team leader can just go select who has been trained and who has not.

View 1 Replies View Related

Query To List Multiple Records In A List From Multiple Queries

Jul 11, 2013

I have a DB where you there's 5 tables all linked together by one project ID

tables below

Project , Staff, Asset, allowances, travel, mark up

What I can do is create a new project, then add records to each of the other tables on what different items I require,

i.e. I create a new project - called project one, in the project table I create a record stating, name, time scale, client and location, then I add different records to each of the other tables on what I require all linked to the same project ID. (probably not explained that too well)

Now I want to create a query that lists all the requirements one after the other this will make it easier to create reports and to calculate costing's.

At the moment I have made 5 different queries listing all the data, then have one report containing 5 sub reports to display the data, no this does work.

View 7 Replies View Related

How To Transfer Multiple Select Item In List Box To Another List Box

Jun 2, 2012

How To Transfer MultipleSelect Item In Listbox to another Listbox ?

View 7 Replies View Related

Optimizing 'List Control'

Sep 11, 2006

Hi,

Does anyone know if it's possible to make the column heads, column count, column width properties of a list box fit automatically according to the text they hold?

Any help will be very much appreciated.
B

View 2 Replies View Related

Update Automatically A List Control

Jan 5, 2005

hello all
i have a problem, i have a form bounded to a query
that displays the books infos, in this form i have a list control
that displays the list of authos based on the code of the book
the problem is when i have more than one record in the opened
form ie more than one book and i move to the second record
the list doesnt change and displays the authors of the first book
when the form first opened
anyone has an idea how can the list be updated automatically when
i move between records
thanks a lot

View 6 Replies View Related

How To Get Header Of A List Box Show Value Of Another Control

Aug 23, 2013

Is it possible to have the header of a list box show the value of another control?

View 2 Replies View Related

How To List Multiple Files In Multiple Subfolders

Nov 14, 2005

Does anyone out there know how I might do the following:

I have a main folder which contains many sub-folders. In turen, each subfolder contains several files. I am interested in creating a text file that within each sub-folder will list certain files in that sub-folder. Example:

"Main Folder"
"Sub-folder 1"
FileA
FileB
FileZ
"Sub-folder 2"
FileA
FileB
"Sub-folder 3"
FileA
FileB
FileZ

Pseudo-code:

Read Main Folder
Do While Sub-folders exist
Do while selected sub-folder contains files
If selected sub-folder contians FileZ then
Write selected sub-folder name to text file
Write time/date stamp to text file
else
loop to next ub-folder
end if
end do while
end do while
Close input and output

Any help offered is greatly welcome. Thank you!!

View 7 Replies View Related

Forms :: Checkbox To Control List View Using VBA

Sep 21, 2014

I have a form (frmHourEnter) with a combo box (Staff_ID) that lists staff members from a table (tblStaff). The table form (frmStaff) has a checkbox (ckEmploy) which indicates if a staff member is still employed. If the checkbox is checked how do I exclude that staff member from the combo box Staff_ID in the form frmHourEnter?

View 8 Replies View Related

Forms :: Combobox Value List As Control Source

Oct 20, 2014

I have a combobox with a value list as the control source. I have a user who clicks the drop-down, but there are no options. Every other user is able to view these options, and this user has no problem with any other combobox with a value list.

View 3 Replies View Related

Right Aligning Text For Fields In List Box Control

Feb 23, 2014

I would like to right align my text for some fields in my list box control. Is there a better list box control out there than the standard one ? how to align the text. The default left alignment doesn't work for all my fields.I tried to search but came up empty.I did try a function "Justify String" I found on the internet This is what I tried .. Call JustifyString("frmExercise","List16",ExerciseTime, 2,True,False)

Here is info from the actual function.

Function JustifyString(myform As String, myctl As String, myfield As Variant, _col As Integer, RightOrCenter As Integer, Optional Sform As String = "") As Variant

View 10 Replies View Related

How Many Fields Are Allowed

Jan 12, 2005

I have a cvs excel file with 8000 lines, I would like to try to input these fields into 1 table is this possible?

View 2 Replies View Related

Values In Source Control Not Updating

Aug 5, 2013

I'm not very familiar with Access but I need to modify an existing DB. I have added new values to it and they should appear into the source control drop down menu but only the original values appear. How or where those values can be added or updated??? I'm attaching some pictures ....

View 5 Replies View Related

Control Treeview Is Missing Form ActiveX List?

Jun 21, 2014

I use Access 2010 on Windows 7 64b to create a form with a Treeview control. However, this control is missing from the list of controls activix. How can I add?

View 4 Replies View Related

Problem With Passing Values From Calendar Control 10.0

Aug 23, 2007

Hi All,

I'm in the process of creating a database that allows users to enter details into a form which includes a date range as start and end dates.

I have used the inbuilt Calendar Control 10.0 control to allow users to select the date. It is linked to two combo boxes [cmbStartDate] and [cmbEndDate] using the following code (this code is repeated for each combo box):

Code:

Private Sub cmbStartDate_MouseDown(Button As Integer, Shift As Integer, X As Single, Y As Single)

Set cmbOriginator = cmbStartDate

ocxCalendar.Visible = True

ocxCalendar.SetFocus

If Not IsNull(cmbStartDate) Then

ocxCalendar.Value = cmbStartDate.Value

Else

ocxCalendar.Value = Date

End If
End Sub



And..

Private Sub ocxCalendar_Click()

''Update the ComboBox with the value entered into the ComboBox
''Put the value back into the relevant ComboBox
cmbOriginator.Value = ocxCalendar.Value

''Hide the calendar
cmbOriginator.SetFocus
ocxCalendar.Visible = False

''Clear the variable
Set cmbOriginator = Nothing

End Sub

This all seems to work fine- however, when I try to write the selected dates to a table or use them in a query they are not recognised (the form obviously needs to be open whilst the query runs), but if I manually type dates into these combo boxes these dates are picked up fine.

This is beginning to drive me mad so any help would be greatly appreciated.

Mark

View 7 Replies View Related

Unbound Report - Setting Control Values

Oct 25, 2005

I have a very simple report - just one field.

I have a Form - "Cases". The button to open the report is on that form as are the values I want in the report.

I want to pull the value of Case Name and Case Number from the current form view and put them together in the single field on my report.

I can "almost" do it. Then VBA gives me a warning - it says that you can't assign a value to the control on my report.

Can anyone give me any ideas?

by the way:
I chose to make this an unbound report because I'm using SQL server as my back-end and my Access is an .adp file. SQL (so I was told by the programmers at work) can't pull in variable criteria from a form like Access Queries can. So this all has to be put in VBA.

View 5 Replies View Related

Help With Button Click And Copying Control Values

Aug 21, 2007

Hello everyone, hopefully you can help before I go crazy. i have been working on this problem now for 3-4 days.

I have two forms (ID-Injury Choice) and (Treatments). In both forms I have the control (InjuryID). What I am trying to do is when I click a button on the ID-Injury Choice form, the InjuryID control value is automatically transferred to the Treatments form.

For the life of me I can figure out this simple act. Any help would be appreciated.

View 3 Replies View Related

Forms :: Control With Values From A Query OR A Table

Jan 27, 2015

I have an option group which should display a value from a table if txtWords is null, but the result of a query if txtWords is not null. But though it shows the right results when I load the form, updating txtWords gives me all sorts of errors.

txtWords is in the main form, while the option group optLengthCat is in a subform (but inline).

Form_OnCurrent() event:

Code:
'Enable or disable the option group
If Len(Me.txtWords.Value & vbNullString) = 0 Then
Me.fsubLengthCat.Form!optLengthCat.Enabled = True
Else
Me.fsubLengthCat.Form!optLengthCat.Enabled = False

[Code] .....

When I put this into txtWords_AfterUpdate() it starts throwing up errors. Specifically, when I delete a subform record using SQL I get 'record was already deleted by another user'; I think I might have fixed the problem with Me.Requery, but it feels really inefficient.

Should I be using an unbound control? If yes, how do I make an unbound control that can edit or add new records?

View 6 Replies View Related

Forms :: Count Distinct Values In A Control?

Nov 22, 2014

I would like to count distinct values on a control in the footer of a search form. How to accomplish it.

View 2 Replies View Related

Max No Fields Allowed In A Table

Dec 14, 2006

using access 2000+
anyone know if there is a limit to the number of fields that
are allowed in a table
I have currently got up to 150 but may need to go up to 300+
Most of these are number fields

View 5 Replies View Related

Query Criteria Is Not Allowed

Jul 18, 2006

Thanks for reading....

I have a query that returns a description value depending on the system code provided. One of my codes is '?M' and the ? is crapping out the whole query with Invalid Syntax.
How can I get around this and still have the '?M' as criteria? Please advise.:)

Thanks for any guidance, suggestions, and/or answers.

View 3 Replies View Related

Subform Controls Not Allowed?!?!?!?!

Jan 24, 2005

Hello,
my problem looks so stupid, but I'm not able to solve it..
I've a form with two subforms in it and one of them is behaving in a strange way.
I open the form and type something in a text box in the form. Now I can type something else in a text box in the first subform but I'm not able to write anything in a textbox in subform n°2. It's textboxes (and also other controls like combo,...) look like they are not enabled (but they are enabled!!).
This subform has also got a Button, and it works (It deletes current record).

If I close the form and reopen it and I go straight to subform n°2, now I'm able to insert text in it's controls, but I'm not able to edit the controls in the main form and in subform n°1.

I hope my problem is clear
Please help!!

View 1 Replies View Related







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