HELP -- I have taken over a position that has the member database in Access and I need to change the "choices" in one of the drop down menus. I have very little knowledge of Access and neither does my boss --- is there a way to edit the drop down menu?
The person that set up the database is NOT accessible to ask.
2007-01-02 06:25:21 · 2 answers · asked by GP 6 in Computers & Internet ➔ Software
first becarefull. Based on my experience, before you try anything you should save a copy of your database separately. Then make your change and try the database. If your change messed something, at least you have the copy to return to.
Are you talking about drop down in the cells when you enter data or in the toolbars?
If it is about the cells, you go to the table that you are working at and you click on the design. In the design, on the first half of the page, you go to the column that you want to change. Once there, you go down in the second half of the page to the lookup tab, you will find "Row Source" and it says: In "data", "data", "data" you change or add those data that you like.
There is also an option down the lookup that says "limit to list" and you can answer by yes if you have all the data or by no if the data keep changing. Than you save it and next time you click the drop down you will find the new data saved.
Sometimes the row source indicate another table fields, you have to go to the other table and change the required information.
If you are talking about the toolbars you do that by going to view, toolbars, customize.
Just be carefull, it is easy to mess with a database. you need to have a copy before any change.
2007-01-02 06:42:42 · answer #1 · answered by mab 2 · 0⤊ 0⤋
The choices in drop down boxes you are referring to most likely refer to data types of the data. e.g. if you have salaray in the box next to it, then you have to make the data type number. Reason: salary would always be a number. Apply the same with rest of the boxes.
Take time to learn the basics:
http://www.learnaccessnow.com/
http://databases.about.com/od/tutorials/Tutorials.htm
http://msdn2.microsoft.com/en-us/office/aa905405.aspx
2007-01-02 14:31:06 · answer #2 · answered by Anonymous · 0⤊ 0⤋