Help with a-z format and dates please

[evilcowstare]

Hi im using Access 2002, please note im not an expert on this so please keep
answers straight forward thank you

There are two things I'm a little stuck on....

1. I have a form with a drop-down box and would like the information in that
box to come up automatically in a-z format. It gets its information from a
table, one column has the id number the other the line of info. I have made
the info line A-Z in the table but in the form it picks up on the ID number
order and not the words, any idea of a way round this?

2. On a form I have several boxes that require a date to be entered, how can
I set it up so that a person just has to enter for example 071206 and then it
will automatically change it to 07/12/06. I have tried setting the short date
on the table but in the form it keeps wanting me to add the / myself.

Thank You for any help, its really appreciated.
Its been a while since I used Access and my brain is trying to catch up

 

[MikeJohnB]

Not really sure what your doing with your first question, a list box will
record the data you set up in the formation of the list box? More details?

With item 2, right click the controls (Boxes as you put it) with the form in
design mode and select properties. In the list that popsup on the all tab or
the data tab, type 00/00/00;0; in the row labelled Input mask. This will
allow the user to input 010296 without the ##/##/#### for 01/02/1996 to be
recorded and dispalyed without the need to include the seperators. This
assumes that you have set the table field as short date when you set it up.
--
An Engineers Prayer:
At the very end of the day,
when all else fails,
you have tried all,
you have shouted at and blamed the innocent,
and asked everyone you know,

READ THE INSTRUCTION MANUAL.

 

[Douglas J. Steele]

For point 1, create a query that returns the data in the correct order, and
use the query as the RowSource for the listbox.

 

[evilcowstare]

Thanks for the date thing, works fab !

Not really sure what your doing with your first question, a list box will
record the data you set up in the formation of the list box? More details?

With item 2, right click the controls (Boxes as you put it) with the form in
design mode and select properties. In the list that popsup on the all tab or
the data tab, type 00/00/00;0; in the row labelled Input mask. This will
allow the user to input 010296 without the ##/##/#### for 01/02/1996 to be
recorded and dispalyed without the need to include the seperators. This
assumes that you have set the table field as short date when you set it up.

Hi im using Access 2002, please note im not an expert on this so please keep
answers straight forward thank you

[quoted text clipped - 14 lines]

Thank You for any help, its really appreciated.
Its been a while since I used Access and my brain is trying to catch up

 

[evilcowstare]

Ok sorry stupid Q now, How do I make a query so that it shows everything in A-
Z?

If it Helps it is set up like this for example...

Table
ID Type
3 Building
4 Carpentery
1 Flooring
5 Glazing
2 Roofing

FORM

Drop-Down Box feeds from "type" above but although I have listed it as A-Z in
the table on the form it is listing them by ID number, I want it to bring
them up using the letter of the "type"

Sorry for asking for specific instructions, just a bit slow today

Thank you for your time

For point 1, create a query that returns the data in the correct order, and
use the query as the RowSource for the listbox.

Hi im using Access 2002, please note im not an expert on this so please
keep

[quoted text clipped - 22 lines]

Its been a while since I used Access and my brain is trying to catch up

 

[Albert D. Kallal]

Just open the form in design mode....
delete the combo box...and then re-add the combo box using the wizard...it
will give you the option to sort....

You could also simply open up the form in design mode..and select the combo
box..and then click on the
data tab of the properties sheet. Select "row source" setting and then click
on the [..] button that appears.

it ask you if you want to create a query...you can then set the sort order
of the query...

both of the above will result in you having the order set....

 

[evilcowstare]

Awesome, thank you !!

Really appreciate the help, sorry for the hassle