Results 1 to 2 of 2
  1. #1
    Join Date
    Dec 2014

    Unanswered: creating multiple records at once and populating records

    I have searched and searched 5-6 pages of google and nothing has come up but a lot info from this forum which has been a goldmine.
    I have been teaching myself access (MS ACCESS 2010) and was using my music collection as my first database. dbmusic



    What i want to do is from: formablum, based off a variable input; create multiple records whilst populating the track# field (starting at 1). What i have in mind was creating a subform formsong on formalbum (main form) for which using a command button a inputbox appears asking "how many tracks?" which then opens a continuous form with with only ID and track# containing values. Now this seems impossible to do using actions and can only be done using VBA which is where i am new to.

    I do have coding experience and i have watch quite a bit of videos, forums, and ms access guides but can't seem to formulate coding for what i am trying to do SPECIFICALLY, can someone walk me through? and also if this can be done without vba that would be interesting to see....

  2. #2
    Join Date
    Nov 2004
    out on a limb
    Provided Answers: 59
    use an insert query
    presumably you have got some source for the data, and Im guessing its going to be from one of the media player libraries out there. If nto it could be say from a swcan of your disk using an MP3 control that can decode the MP3 tags embedded in the file

    as a first pass, populate the parent tables (so that would be thigns like genre, artist, album and so on
    as a final pass populate the track details

    as with all these thingsa it depends on your data source, and your table design

    there's lots of schematics out there for digital media libraries. Ive dabbled in them myself, but to be honest its not really require to do a better mousetrap. if the data is available in a media library, then there is almost certainly some form of db hosted within that applciation., Even if the design of that media library db is iffy, why re-invent.
    I'd rather be riding on the Tiger 800 or the Norton

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts