Welcome to SPN

Register and Join the most happening forum of Sikh community & intellectuals from around the world.

Sign Up Now!

database for cd collection

Discussion in 'Information Technology' started by aj, Jul 28, 2006.

  1. aj

    aj
    Expand Collapse
    Guest

    i need a database that when i asign a id# to an artist then later when i add
    cds' to my collection i only have to put the id# in and it will insert the
    artist name automaticly.
     
  2. Loading...


  3. strive4peace

    strive4peace
    Expand Collapse
    Guest

    Hi AJ,

    instead of manually assigning an ID to the artist, try this:

    make a table

    *Artists*
    ArtistID, autonumber
    Lastname, text
    Firstname, text

    Your CD table will store ArtistID, long integer

    then, on the combobox for artist in your CD form ...

    '~~~~~
    Name --> ArtistID
    ControlSource --> ArtistID
    RowSource -->
    SELECT ArtistID
    firstname & " " & lastname as Artist
    FROM Artists
    ORDER BY firstname, lastname

    BoundColumn --> 1
    ColumnCount --> 2

    columnWidths --> 0;2
    (etc for however many columns you have
    -- the ID column will be hidden since its width is zero)

    ArtistID--> 2
    (should add up to the sum of the column widths)

    ArtistIDwill be stored in the form RecordSource while
    showing you information from another table...


    put a command button to the right of the list to add records

    Caption --> +
    Name --> cmdAddArtist
    Onclick -->
    DoCmd.OpenForm "Artists", , , , , acDialog
    me.Artist_combo_controlname.requery

    where Artists is the name of the form to use for entering
    another record in the Artists table
    '~~~~~

    once you have the Artist form and command button set up,
    post back and we can help you with entering the new ID in
    automatically...



    Warm Regards,
    Crystal
    Microsoft Access MVP 2006

    *
    Have an awesome day ;)

    remote programming and training
    strive4peace2006 at yahoo.com

    *

    aj wrote:
    > i need a database that when i asign a id# to an artist then later when i add
    > cds' to my collection i only have to put the id# in and it will insert the
    > artist name automaticly.
     
  4. Leanin' Cedar

    Leanin' Cedar
    Expand Collapse
    Guest

    Not what you are asking for, but I have over 600 cd's and use this program,
    and two Sony 300 disc changers.

    http://www.synapsa.com/

    Bob


    "aj" <aj@discussions.microsoft.com> wrote in message
    news:14988AD5-2A50-455F-A69B-1BB8B198E158@microsoft.com...
    >i need a database that when i asign a id# to an artist then later when i
    >add
    > cds' to my collection i only have to put the id# in and it will insert the
    > artist name automaticly.
     
  5. Joseph Meehan

    Joseph Meehan
    Expand Collapse
    Guest

    aj wrote:
    > i need a database that when i asign a id# to an artist then later
    > when i add cds' to my collection i only have to put the id# in and it
    > will insert the artist name automaticly.


    Are you now using Access database? If so what is your current table(s)
    structure?

    Are you looking for a CD template for Access?

    --
    Joseph Meehan

    Dia duit
     

Share This Page