MarkP
Last Activity: Jan 2 '11, 03:47 PM
Joined: Dec 23 '10
Location:
-
Thank you for that. You should change your hobby (database programming) to the day job. But either way I'm glad you read my message. -
Sorry about not answering your last question. I was hoping to store the string with comas like in your first example above.Leave a comment:
-
I'm trying to store multiple values in a field to reduce the amount of check boxes in a table. My present table has over 75 columns that are used to received check boxes from a form. But I need to capture each record/event from the user. So each record is unique and will be used in trending analysis. If there is another way that I can use to reduce the number of columns in a table then I will be open to that suggestion. Thank you and Happy New...Leave a comment:
-
Saving list box items as a string
Is there anyway to save multiple items selected in a list box to a string? Is it then possible to save the string to a record field in a table? Or is there another way to capture multiple items selected and stored them in a table? For example: I have a list box with the following items:
Listbox
cat
dog
rabbit
Table name = Animal_tbl
Animal Selected - this is a column heading and a text field. -
Thank you for your time. Let me briefly explain what I'm doing. I need to get an assessment of daily events that are analyzed by inspectors. These events would assist the inspectors in trending and focus their attention on problemt areas. I'm trying to capture their assessment in a database that would allow them to run reports. That said, presently, in the database I have two tables and one form. The form name is EventForm. The table that...Leave a comment:
-
Yes the table would increase daily and help in trending reports.Leave a comment:
-
I was hoping to add the contents of the form to a table as a record for each event (daily there could be 10 to 20 records) entered and to use the selections in listbox2 as a string in a column in the table that would be used for reports.Leave a comment:
-
Yes you are correct about the combo box. If the user make the same cbo selection again then I would need a msg to advise of duplicate entries.Leave a comment:
-
Correction: items selected in list2 would erase.Leave a comment:
-
The problem I was having was that I could select the items from list1 but when I changed the list of items in list1 by selecting a new item from the combo box my items selected in list2 would remain. List2 items would clear.Leave a comment:
-
Yes you are correct. I can also deselect from list2 by holding down the ctl key and double clicking on list1 item that's highlighted.Leave a comment:
-
Great idea. So, if I understand what you are saying is to have list1 populate a table on selection and have list2 display the table as it is being populate by list1. Sounds great, do you have the VBA code for this?Leave a comment:
-
Merry Xmas and a Happy New Year. Thanks for responding back, I have enclosed a copy of the procedure below for List Box(1). Note: the combo box to list box(1) works okay and I can do the same steps for list box(2), however, I would like to show all of the selections that the user pick from list box(1). Also the combo box has 15 items that the user could pick and list box(1) has anywhere from 5 to 15 items per combo box selection. (Ex. If I was...Leave a comment:
-
Hello RuralGuy, What I'm trying to resolve is an Access form that the user would use to record events. This requires information to be collected and stored. On the form I have 1 combo box that feeds off of a table and that updates a list box(1). The information from this box(1) is selected and goes to list box(2). This in turn, gets stored in a separate table as a record for that event. My problem is that each item in the combo box that brings...Leave a comment:
-
Cascading combo/list boxes
Hello, I have a combo box that feeds a list box1 which in turn feed another list box2. List box2 values need to remain in list box2 when list box1 has been change by the combo. The content of list box2 will be stored in a table. I guess this is 2 part question: Are there any examples out there on list box2 used as a collection point, and how hard would it be to store the contents of list box2 in a table? Thank you for your help.
No activity results to display
Leave a comment: