Sorting sequence

[firework]

Hi there,

Not sure whether I am in the right forum. It is Table, Form and Query.

Have a table which index to sort on 4 fields - Proj, SubProj, Team, SubTeam.

1. I used this Table on a form, the data seems to be in random sequence instead of above.

2. Then I tried to sort it in a query which showed up fine ( as required) in the actual running of the query. However when I used this query in a form, the data doesn't sort as expected.

3. With above 1 and 2, I have also tried the Order Of in the Form properties which still do not do the trick.

can anyone shed somelight on this please.

BTW, After I first created the form, I just rename the record source in form property. Don't know whether this make any differences in the above result.

 

[neileg]

Sorting a table doesn't do what you think. It only sorts the display, it doesn't change the order in the table.

Using a query is the right way to go. Make sure there's nothing in the form properties that tries to apply another sort that messes this up.

 

[RuralGuy]

Your #2 should have worked. What version of Access are you using. As a general rule, you can not sort tables except by using a query. This is not exactly accurate but close enough for this thread.

 

[firework]

Hi there,

I am using Office 2003 but on the menu bar, the file format is 2000. On Windows Xp Pro sp2

I noticed that I used to be able to achieve various basic using certain syntax but don't seems to be able to do it any more.

For example, refresh form using code created by command button or forms!formname.requery.

 

[RuralGuy]

Have you applied SP3 to Office 2003? If so then you may want to apply the HotFox that corrects many of the problems caused by SP3.
Description of the Access 2003 post-Service Pack 3 hotfix package: December 18, 2007
If you have not applied SP3 then *DON'T*.

 

[firework]

Ahhhhhhh.

I set the update automatically and yes, it was installed. I am off to install the hotfix now. I am doing it though autoupdate.

talk to u later

 

[RuralGuy]

I'm not sure AutoUpdate will install the HotFix but there is a link to the download in the link I provided. Let us know if it resolves your issue.

 

[firework]

Hi there,

You are right. The auto doesn't work. (I thought it should). Anyway before I read your latest reply, I have already install the hotfix and will try it out tomorrow.

Thanks guy, watch this space. Should update you nice guys tomorrow.

 

[firework]

Hi guy,

The hotfix must be working. Yes, the sorting seems to work and also the refresh statement as well.

Thought I was going mad.

Thank you guys for all your help.

Have a good evening

 

[RuralGuy]

Thanks for posting back with your success.