The UK's Number 1 for Microsoft Office Training

Sitemap

Bookmark page

Printable version

Course updates
due to adverse
weather conditions

Customer: Sign in
Delegate: Sign in
Trainer: Log in

Forum home » Delegate support and help forum » Microsoft Access VBA Training and help » LIST BOX TO STORE VALUES

	98.3 % recommend us
	More live stats...

Bookmark this page

Share this with a friend or colleague:

The UK's most regular
instructor-led training courses.

Training information:

Active questions
Advanced/consultancy questions
Today's questions
Unanswered questions

LIST BOX TO STORE VALUES

Resolved · Medium Priority · Version 2003

ReplyFri 11 Dec 2009, 16:11Delegate Joanne said...

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?

For upcoming training course dates see: Pricing & availability

ReplyMon 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

ReplyMon 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..

ReplyThu 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

ReplyWed 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.

Access articles

· Sub-reports And Sub-forms In Access 2007
· Get More Out of MS Access Courses
· How To Use A Parameter Query In Access
· How To Use The Analyze Table Tool In Access
· The Three Classes of Databases

Please browse our web site to find out more about
advanced access training and other Microsoft training courses.

Access tip:

Open A Combo Box Automatically

This is helpful if users need to enter large amounts of data. There are two ways to open ComboBoxes when they get the focus by using the tab keys.

When the ComboBox gets focus:

Press Alt + Down Arrow on the keyboard

For it to happen automatically, needs a bit of coding:

1. Add a combo box and a text box control to the form
2. Set the combo box's On Got Focus property to the following event procedure:

Private Sub ComboBoxName _GotFocus()

Me!ComboBoxName.Dropdown

End Sub

3. Open your form in Form View and use the TAB key to make sure it works.