Advertisement
If you have a new account but are having problems posting or verifying your account, please email us on hello@boards.ie for help. Thanks :)
Hello all! Please ensure that you are posting a new thread or question in the appropriate forum. The Feedback forum is overwhelmed with questions that are having to be moved elsewhere. If you need help to verify your account contact hello@boards.ie
Hi there,
There is an issue with role permissions that is being worked on at the moment.
If you are having trouble with access or permissions on regional forums please post here to get access: https://www.boards.ie/discussion/2058365403/you-do-not-have-permission-for-that#latest

Need help with excel(database)

  • 17-07-2006 1:40am
    #1
    CyberGhost
    Registered Users, Registered Users 2 Posts: 5,558 ✭✭✭


    Hi,

    I want to create a little database of my movie collection... but I don't know how to do the following...

    basically, I want to have a drop down list and when I choose an actor, I want "movie title, status, quality and comment" columns to update with data on that actor, is it possible to do?

    snag0000vg2.th.jpg

    What I want...
    snag0001bk4.th.jpg


    Uploaded with ShellUploader.


Comments

  • #2
    TomCo
    Registered Users, Registered Users 2 Posts: 2,528 ✭✭✭TomCo


    You use the filters in one of the drop down menus, can't really elaborate as I don't have excel on this machine.

    I'm pretty sure that would work though.


  • #3
    masterK
    Registered Users, Registered Users 2 Posts: 2,757 ✭✭✭masterK


    It would be a hell of a lot easier with Access.


  • #4
    BaZmO*
    Registered Users, Registered Users 2 Posts: 18,625 ✭✭✭✭BaZmO*


    If you are using a filter you will have to make sure that you put the actor's name in the left hand column of every film title because once you choose the actor from the drop down menu it will only display the actors name and that row.

    It is doable but it seems like an overly complicated way of doing it. What if you want to have more actors per film?


  • #5
    trout
    Registered Users, Registered Users 2 Posts: 9,957 ✭✭✭trout


    smells like Access is required here ... Excel filters would be quite clunky, especially if you want to search on multiple terms.

    if you have MS Access - run the wizard - it should be straightforward and you might like it

    if you don't have MS Access - or you don't want to be a database developer ... try a freebie db like this one ... "http://www.movieorganizer.com/"

    i'm sure there are many freebie db's out there ...


  • #6
    TomCo
    Registered Users, Registered Users 2 Posts: 2,528 ✭✭✭TomCo


    I hate access' query system, took me ages to cut through the crap and find the damn SQL window.


  • Advertisement
  • #7
    CyberGhost
    Registered Users, Registered Users 2 Posts: 5,558 ✭✭✭CyberGhost


    yea I'm no good with access either...

    BaZmO, no there will be one actor per movie(usually a leading one).

    Trout, thanks for the link

    Thanks for the advices guys!


  • #8
    BaZmO*
    Registered Users, Registered Users 2 Posts: 18,625 ✭✭✭✭BaZmO*


    Well then in that case what you need to do is highlight cell A2 across to E2 or however far across you need to go and then highlight all the way down the page. Go further than you need to so that you will allow spaces for new entries.

    Go to "Data" -> "Filter" -> "Autofilter" and then select.

    A filter will appear across the top where you have "Actor/Actress" "Movie Title" etc.

    Then you click the drop down menu in each filter and pick the Actor that you want. That's why you need the Actor to preceed every film title in the "A" column.


Advertisement