98.7% Of all customers recommend us, we're so confident about our results we publish all reviews and stats
View Live Stats View Reviews
Forum home » Delegate support and help forum » Microsoft Access VBA Training and help » LIST BOX TO STORE VALUES
LIST BOX TO STORE VALUES
Resolved · Medium Priority · Version 2003
Fri 11 Dec 2009, 16:11Delegate Joanne said...
Joanne has attended:
Access VBA course
LIST BOX TO STORE VALUES
If I had to 2 list boxes, user selects from one box to another, is it possible to have these stored so can be used for later use? And wot would be the code?
Mon 14 Dec 2009, 15:29Trainer Stephen said...
RE: LIST BOX TO STORE VALUES
Hi Joanne
Thanks for your question
Can you clarify the following for me please.
Do you wish the values to be stored so that they can be used again during the existing procedure's lifetime, or do you wish the values to be stored up until the database is closed, or, finally do you wish the values to be stored permanently?
Thanks
Stephen
Mon 14 Dec 2009, 16:24Delegate Joanne said...
RE: LIST BOX TO STORE VALUES
Hi Stephen I would like the values to be stored permanently so that I can use them again.
My aim is to have a multi-choice list box where the user selects their choice and the selcted items will go into the opposite list box then the user can print a report BUT the values are STORED so that when the user wants to know what was chosen last time he can find out. I want to use this to book IN/OUT, so that is why I need the values to store so the user can check up on the status of the items.
Sorry that I do not explain myself very well..
Thu 17 Dec 2009, 14:43Trainer Stephen said...
RE: LIST BOX TO STORE VALUES
Hi Joanne
Thanks for the clarification
If they data is to be stored indefinitely you need to save the data in a table.
I would create a procedure that
1. Stores the conents of the combo boxes as variables
2. Opens the table as a DAO recordset
3. Adds a new record and sets field values equal to the contents of the variables
Hope this helps
Regards
Stephen
Wed 6 Jan 2010, 07:17Delegate Joanne said...
RE: LIST BOX TO STORE VALUES
Hi Stephen sorry I have not got back to you earlier been very busy. Can you give me an example?
I'm not sure your idea would work, there are loads of types that would be booked in and out (approx 200) would that mean I would need 200 differant tables?
Thanks Jo
Tue 29 Dec 2009: Automatically marked as resolved.
Training information:
|
Welcome. Please choose your application (eg. Excel) and then post your question. Our Microsoft Qualified trainers will then respond within 24 hours (working days). Frequently Asked Questions
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
Access tip:Run with the totalOften when creating reports with lists of transactions it can be useful to have a column which totals the transactions as the report progresses. |
