Quick Links ▼

Bookmark page

Printable version

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

Forum home » Delegate support and help forum » Microsoft Access Training and help » Sorting of drop down menus.

	98.1 % recommend us
	More live stats...

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

Training information:

Sorting of drop down menus.

Resolved · Low Priority · Version 2007

Reply Mon 20 Dec 2010, 16:39Delegate Jamie said...

Jamie has attended:
Access Introduction course
Access Intermediate course

Sorting of drop down menus.

Hi,
I have a form with a field that is linked to a table/ drop down menu of around 3000 suppliers (which I have uploaded).
New suppliers are added to the table almost every day though a different form.
How do I get the drop down menu to add the new suppliers in alphabetical order?
At the moment the list comprises of the original 3000 suppliers that I uploaded in alphabetical order, however any new ones added are only added to the bottom of the drop down box which makes it difficult to find as there are so many.
I hope that make sense?

Jamie

For upcoming training course dates see: Pricing & availability

Reply Tue 21 Dec 2010, 15:17Delegate Jamie said...

RE: Sorting of drop down menus.

Now sorted :)

Access articles

· Quick Microsoft Access Course: Creating an Inventory Control Database in 8 Simple Steps
· How To Create A Combo Control On An Access Form
· Growing A Customer Base For A New Business - With The Help Of Access
· Access 2007 Is All About Systems
· Microsoft Access Training Opens Doors

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

Access tip:

Closing form after a certain time period

To make a form close automatically after a certain time period, you need to assign the close function to a macro.

Save the macro and ope up the form in design view. open the Properties sheet.

In the TimerInterval property enter the length of time you want the form open for. This should be in milliseconds, so for instance if you want the form open for 5 seconds enter 5000, for an minute enter 60000.

You now need to attach your macro (to execute the Close action) to the OnTimer event property of the form.

View all Access hints and tips