Results 1 to 2 of 2
  1. #1
    Shido151 is offline Novice
    Windows 7 32bit Access 2007
    Join Date
    Apr 2012
    Posts
    16

    Access "Web Database" Cascading DropBoxes..... is dead

    Hey guys



    trying my hand at designing a "Web" database in access 2010 and not having much luck, or fun.

    I've got a Table of software, it has three main fields "Developer" "Software" and "Version"

    The developer and Software have several repeats I would like not to appear in the drop down boxes, example:

    Adobe PhotoShop CS6
    Adobe PhotoShop CS5.5
    Adobe Illustrator CS5.5
    Microsoft Project 2010
    Microsoft Visio 2010
    Microsoft Visio 2007



    That's my first challenge

    Next What I would like to do is create a form that has three cascading drop down boxes based off of the three aforementioned fields (and other fields as well but I can handle those), which will then fill in another table that will keep a record of who when where and what. So when the form is filled out properly my table will read like::

    Name Location Date Developer Software Version
    John Smith; Marketing; 1-29-2013; Adobe; PhotoShop; CS6;




    But right now I'm focusing on the cascading part.

    1- I can't get it to not repeat, ie. when you click on the drop down menu I'd like Adobe and Microsoft to appear once. I cannot find the "Unique Value" property to save my life right now.

    2- the cascading portion was complicated enough in regular Access, but now that I've switched over to the web format, I feel like I'm in a straight jacket.

    3- if there is any more information I can give or word this better please let me know. At this point any comments are welcome.

  2. #2
    June7's Avatar
    June7 is offline VIP
    Windows XP Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    53,619
    RowSource for combobox:
    SELECT DISTINCT Developer FROM table;
    or
    SELECT Developer FROM table GROUP BY Developer;
    How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Replies: 2
    Last Post: 11-14-2012, 04:47 PM
  2. Replies: 4
    Last Post: 06-22-2012, 04:00 AM
  3. Replies: 2
    Last Post: 11-04-2011, 02:45 AM
  4. Replies: 5
    Last Post: 05-23-2011, 11:28 AM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums