Recent content by egg

Ok Ill give that a whirl thanks for all your help :)

I had set a button to output the table to an xls file.... After what you have said you have sorted it for me. I can set up a query and then output the query to the xls file... Sorry for overlooking it...... :)

Interesting.... So what do you suggest instead?

The indexing allow seems to sort by one field... :(

Ah right Ill look at the indexes then.... Looking the table its already sorting by name, I just need it to sort by rank first. Thanks

Hi I have a field in a table which is set to text, diplay control=list box, row source=value list. Row source = "level1", "Level2" etc up to "level9". Now the form for new records matches this except the values allowed are limited to the list, ie they can only enter exactly one of the list...

Hi The beginner here again..... How do I set a table to sort by specific fields??? ie i have an ID field which is an autonumber, then 6 fields I want the table to autosort first by a field called [rank], and then by a field called [name] Thanks in advance Egg

I'm sure if you look into it (im only a novice at access) there will be code to deactivate the tickbox control. So Once clicked it wont work again? Or you will need to check the field to see if it already has (O/S) at the end before applying it Someone with more knowledge may be able to put...

Thanks Its all sorted !!! Just gotta finish a few things and then look into security....:eek:

Thanks, yeah update just the displayed record. I will try it as soon as i can :)

Wow this must be really hard to do?? Anyone help at all?? :(

Hi All, I'm new here as I have only just started to use access :rolleyes: I am just creating a very small and simple database (one table, five fields) for personal use. My question is this: I have a text field called [rank] which is a list of predefined texts eg "level1", "Level2" etc etc...