• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1300
  • Last Modified:

Access 2007 Edit List Items icon not displaying below dropdown list when 'running' accde

I have a form in Access 2007 which has several combo box controls.
I have set the properties to allow list edits etc and when I view the form in Form mode I can see the little Edit List Items icon which if you click will open up either the form specified in the List Items Edit Form or the standard Edit List Items Dialogue Box.
But when I open the accde version  I no longer get the Edit List Items icon appearingwhen I click on the drop downs. What I do see is a tiny strange little circle where the icon should be.
Can anyone tell me what Iis happening?
I am running Access 2007 and Windows XP
0
stillers1994
Asked:
stillers1994
  • 5
  • 3
  • 2
1 Solution
 
Scott McDaniel (Microsoft Access MVP - EE MVE )Infotrakker SoftwareCommented:
I don't think you can do this in an accde file; Access would consider this a Design change, which you cannot do in accde formated files. MVFs are not universally accepted either; see this link:
http://allenbrowne.com/ser-27.html
0
 
Jeffrey CoachmanMIS LiasonCommented:
Here is one example of how this was done in the "Old Days", before Access 2007.

;-)

JeffCoachman
Access--Basic--Simple-ComboBoxNo.mdb
0
 
stillers1994Author Commented:
Many thanks - that is a great bit of information in the link you sent. Many thanks. Nice quick reply. I do know how to program the alternatives but I just assumed the new feature would be of some use.
0
The new generation of project management tools

With monday.com’s project management tool, you can see what everyone on your team is working in a single glance. Its intuitive dashboards are customizable, so you can create systems that work for you.

 
Jeffrey CoachmanMIS LiasonCommented:
<I do know how to program the alternatives >
Unless you plan on staying in the "kiddie Pool" forever, you may want to pick up a "Bible" style book on MS Access.
;-)

ex:
http://www.amazon.com/Access-2007-Bible-Michael-Groh/dp/0470046732/ref=sr_1_1/181-8982386-2433504?ie=UTF8&s=books&qid=1242840184&sr=8-1

Almost all of them will contain and introduction to Access programming/VBA.

Pretty must anything above the "Basic" level in Access will involve coding in one way or another.
;-)

Jeff
0
 
stillers1994Author Commented:
Sorry I did type that I DO know how to program the alternatives I was just  trying to use the latest developments that Access 2007 had to offer

Rather a patronising comment to receive!

But ahh well still received a useful link I suppose
Many thanks
0
 
Jeffrey CoachmanMIS LiasonCommented:
The comment was meant to be more "Comical" than patronizing.
(didn't you notice the smiley faces?)

;-)

Jeff
0
 
stillers1994Author Commented:
Oh dear obviously my sense of humour had taken a short break there!
Sorry Jeff
0
 
Scott McDaniel (Microsoft Access MVP - EE MVE )Infotrakker SoftwareCommented:
Sometimes the latest developments need a bit of maturation time, which IMO is where the items like MVFs and such are at right now. I think they will become a viable UI consideration at some point, but at this time IMO they just aren't ready for prime time.
0
 
Jeffrey CoachmanMIS LiasonCommented:
stillers1994,

LOL.

I was in th kiddie pool for a long time, till the Experts here pulled me out.
;-)

Jeff
0
 
Jeffrey CoachmanMIS LiasonCommented:
Yeah,

I'm not one of thoes people who say the MS is "dumbing down" Access.

I am just concerned that it is billed as a way to put multiple values in one field,
without a real explanation as to how/why it works.

So my concern is if it is easy to "undo" if the design requires more coplexity.

Jeff
0

Featured Post

[Webinar] Improve your customer journey

A positive customer journey is important in attracting and retaining business. To improve this experience, you can use Google Maps APIs to increase checkout conversions, boost user engagement, and optimize order fulfillment. Learn how in this webinar presented by Dito.

  • 5
  • 3
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now