Hi There,
I am currently trying to refine a form that I have in Access 2000. I currently have a ComboBox that lists all of the terms in a field in my table. When a term is selected, other fields are populated. I have been requested to make this more dynamic, in the sense that you should be able to search by any metric.
I think the best way to do this is to have a radio button (or a set of radio buttons) that you can select one, and it will populate the ComboBox with the proper field. The problem that I am seeing is that I need it to be mutually exclusive. When you click one radio button, it should blank all of the others.
How can I go about doing this?
Another problem that I am having is that there is an AutoComplete function on the ComboBoxes, when you start typing terms, they are filtered for the letters you have typed. I like this functionality. The problem is that if you continue to type letters to a point where the list is filtered to 0 rows, it displays a runtime error. From a user experience perspective, I was wondering if it was possible to supress that error from being shown, without entering debug mode and closing functionality.
The third problem that I am looking to solve is version control and end user management. I don't want to have my users accessing the backend, as they should only be able to use the forms that are displayed on screen. So I need to block all access to anything except the forms.
When the program starts, it should pop up the form I have, which contains buttons to access the other forms that the user would need. How can I disable everything else? (bear in mind that I want the shift key option to remain, as that is how I will have the administrator open the database for modification)
Thanks for all of the help,
DaVuLf
I am currently trying to refine a form that I have in Access 2000. I currently have a ComboBox that lists all of the terms in a field in my table. When a term is selected, other fields are populated. I have been requested to make this more dynamic, in the sense that you should be able to search by any metric.
I think the best way to do this is to have a radio button (or a set of radio buttons) that you can select one, and it will populate the ComboBox with the proper field. The problem that I am seeing is that I need it to be mutually exclusive. When you click one radio button, it should blank all of the others.
How can I go about doing this?
Another problem that I am having is that there is an AutoComplete function on the ComboBoxes, when you start typing terms, they are filtered for the letters you have typed. I like this functionality. The problem is that if you continue to type letters to a point where the list is filtered to 0 rows, it displays a runtime error. From a user experience perspective, I was wondering if it was possible to supress that error from being shown, without entering debug mode and closing functionality.
The third problem that I am looking to solve is version control and end user management. I don't want to have my users accessing the backend, as they should only be able to use the forms that are displayed on screen. So I need to block all access to anything except the forms.
When the program starts, it should pop up the form I have, which contains buttons to access the other forms that the user would need. How can I disable everything else? (bear in mind that I want the shift key option to remain, as that is how I will have the administrator open the database for modification)
Thanks for all of the help,
DaVuLf