Search results

As suggested above in properties select the format tab and then the format field enter ">" without the quotes that way it doesn't matter what is typed it will always be in uppercase.

What versions of access are on the PC's. I have noticed that some code works ok with access v2.0 but not access97. I have'nt fully tested access 2000. but there could be different problems.

A while ago i developed a little program that lets users remove items of stock from store.(access 2.0). Years later we upgraded to access97 the code no longer worked? Can anybody shed any light on this. I have entered the code below in full. I have since changed the code but it doesn't work as...

I think you can do this from the properties on the within the query. Try bringing up the query properties dialogue box and change the top values field from all to 10 etc. Then alpha sort z -a or vice versa to get your desired result. [This message has been edited by skollager (edited 04-21-2001).]

How can i stop access doing the following on a report or form. A1 A10 A11 A2 etc I would prefer it to do the following. A1 A2 A3 etc A10 A11 A12 etc B1 B2 B3 etc