Search results

Here you go I only added two tables one for the show and second for the tracks to be played I've also updated it for genre on the tracks

I was a DJ For 10 years back in the 80's-90's My collection is some 70K Tracks collected over 30years I went from 7-12'' to CD's then finally on to my drives I store them on my onedrive account now. Creating a playlist is simple tblPlaylist tblplaylistNames tblPlayListAndName The...

I Did post an image of the recordings screen that shows a subform with artists, It has a Contribution Field which is the AsID Field as in above image This is the extention of the ERD I posted with reference to the track it is any earlier version

I'll add the drew file to my sites downloads so it can be edited

Not you @lodmark I've been trying to keep it simple as I understand your level hence the pictures What I will do is put A Basic ERD, Some of th posts we're getting close togoing over my head.

I'm going to bail out as I can see this getting far to complicated for the OP He's struggling with basics

You can see a lot of the data for one of my programs outputted to pdf files here: https://databasedreams.createaforum.com/weekly-charts-analysis/

It's they way the credit system works within the official charts as that song/album has been credited to both so I use the full credit name then each artist a lead artist gets say 100 points and a normal (Arist wothout lead ticked) Gets 50 and a Combo gets 0 that is if I'm using a credit system

Kylie Minogue & Jason Donovan is a combination artist you also need two other entries for Kylie Minogue and jason Donovan as below

The duet or a trio Relate to the Artist/Groups see picture Notice the artist/group Types list

P.S. I'll be starting to create my ERD for my music Library which I'm calling "Apollo" This will include most of the music sections in DJ 2020 So will be less confussing.

You will continue to have problems as your tables are not linked correctly and I have noticed you have 3 keys on the tbl_artists_music the ID field should only be a auto number, I only include a autonumber as it makes deleteing and working with each record simpler.

A lot of what I've been doing with this project is different to the way I used to design them, at least it seems to be responding much better even though I only have 20k tracks

Sorry Didn't think Google LOL

I'm looking for the template for recipies from the 2k version of office if you have a copy you can share I would appreciate it Thanks Mick

It is after the goto but it's about record 37 as there are 2 discs and as luck has it I have the track name first in the tab order so it is selected as above. Thats what I wanted as I can use the edit system Without having to scroll down the list. I did try the find first but it did find the...

This is what I wanted @Gasman It finds the record and then moves to that record so it's in the display section of the subform I can't think Of any other reliable way to do it?

I do have disc and track numbers and could find disc2 track 14 as long as I know how many tracks are in disc 1 plus what if they miss a track or mess up the numbering my system doesn't have to take the user into account. If I have missunderstood please put me right

Thanks @Gasman This code worked for me Dim R As DAO.Recordset Dim I As Long, T As Long On Error GoTo HandleErr I = 1 If Not IsNothing(Me.OpenArgs) Then T = Me.OpenArgs Set R = Me.Sub_ZfrmTracks.Form.RecordsetClone With R If .RecordCount > 0 Then...

OK So I need to get a record count and the location in recordset for the one I want Thanks Gasman