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...... :)
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...
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...