If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
"Edit List Items" on runtime?
I have some database forms in Access 2007 set up so that when I use a
combo box control, a little button shows up at the bottom that says "Edit List Items." When I click this, it opens up the form behind the combo box and lets me add a new item. When I give this form to my coworker using the Access 2007 Runtime though, these Edit List Items buttons don't show up. Is there a way I can make them visible on the runtime? Or an alternative to let them add a new list item? Thanks, Joel |
#2
|
|||
|
|||
Edit List Items on Runtime
I think I have the same issue... when I type the new data into a combobox in the form view, if its not in the list already a box pops up and states "the text you entered isn't a item in the list" "Do you want to edit the items in the list?" Yes or No etc... If I say yes, it does let me add the item to the list and even set it as the default, This is in the full version of access, however in Runtime Version, it goes over the same as above and lets me enter item in the list but the next time I open the database it isn't retained in the list.
Is this what you are getting ? I found some thinks on the microsoft forum but they really never pointed anyone in a direction. Have you made any progress? thanks Joel Parker wrote: "Edit List Items" on runtime? 07-Aug-07 I have some database forms in Access 2007 set up so that when I use a combo box control, a little button shows up at the bottom that says "Edit List Items." When I click this, it opens up the form behind the combo box and lets me add a new item. When I give this form to my coworker using the Access 2007 Runtime though, these Edit List Items buttons don't show up. Is there a way I can make them visible on the runtime? Or an alternative to let them add a new list item? Thanks, Joel EggHeadCafe - Software Developer Portal of Choice ASP.NET DropDown Menu Server Control http://www.eggheadcafe.com/tutorials...-menu-ser.aspx |
#3
|
|||
|
|||
Edit List Items on Runtime
You can solve that problem, generically with this code:
http://www.datastrat.com/Code/NotInListCode.txt and I have a demo for using it at: http://www.accessmvp.com/Arvin/NotInListDemo.zip -- Arvin Meyer, MCP, MVP http://www.datastrat.com http://www.mvps.org/access http://www.accessmvp.com Andrew Revelle wrote in message ... I think I have the same issue... when I type the new data into a combobox in the form view, if its not in the list already a box pops up and states "the text you entered isn't a item in the list" "Do you want to edit the items in the list?" Yes or No etc... If I say yes, it does let me add the item to the list and even set it as the default, This is in the full version of access, however in Runtime Version, it goes over the same as above and lets me enter item in the list but the next time I open the database it isn't retained in the list. Is this what you are getting ? I found some thinks on the microsoft forum but they really never pointed anyone in a direction. Have you made any progress? thanks Joel Parker wrote: "Edit List Items" on runtime? 07-Aug-07 I have some database forms in Access 2007 set up so that when I use a combo box control, a little button shows up at the bottom that says "Edit List Items." When I click this, it opens up the form behind the combo box and lets me add a new item. When I give this form to my coworker using the Access 2007 Runtime though, these Edit List Items buttons don't show up. Is there a way I can make them visible on the runtime? Or an alternative to let them add a new list item? Thanks, Joel EggHeadCafe - Software Developer Portal of Choice ASP.NET DropDown Menu Server Control http://www.eggheadcafe.com/tutorials...-menu-ser.aspx |
Thread Tools | |
Display Modes | |
|
|