LIST BOX TO STORE VALUES

Resolved · Medium Priority · Version 2003

Fri 11 Dec 2009, 16:11 Delegate 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:29 Trainer 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:24 Delegate 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:43 Trainer 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:17 Delegate 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 courses

	98.7 % recommend us
	More live stats...

Training information:

Active questions
Advanced/consultancy questions
Today's questions
Unanswered questions
Popular forum topics

Access tip:

Run with the total

Often when creating reports with lists of transactions it can be useful to have a column which totals the transactions as the report progresses.

Using the Sum function gives the total for the whole group, not a running total.

Access provides an easy method of achieving a running total.

Click on the text box containing the data you wish to contain the running total.
Select the Data tab
Click in the Running sum option
Click the down arrow to view three options

View all Access hints and tips