"Edit List Items" on runtime?

[Joel Parker]

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

 

[Andrew Revelle]

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
combo box control, a little button shows up at the bottom that says "Edi
List Items." When I click this, it opens up the form behind the combo bo
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 alternativ
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/tutorial...1a-8ee78899a61c/aspnet-dropdown-menu-ser.aspx

 

[Arvin Meyer [MVP]]

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