Re: Music Notation

Dominic Vella wrote:

Ok, I know, I know, Access is not normally the right tool for this job, but I've built a catalogue of music books, with the song in each book, and associated midi filenames, for a musician, blah blah blah.

Now, I want to up the ante a bit.

I know VB has Circle() and Line() commands, and other nice graphical commands.

I know you can do some of this in a report (supposedly) but is there any way at all I can draw lines and dots on a Form?

Maybe I can use CreateControl to make more lines, and maybe copy images of circles using CreateControl too?

Thanks


Dominic


I would probably create a hyperlink in the table, scan the song to a file, and then create the hyperlink
Dim strNotes as String
Dim strMP3 As String
strNotes = "Song1#C:\Music\Song1.Tif"
strMP3 = = "Song1 MP3#C:\MP3\Song1.MP3"
Me.HyperLinkNotes = strNotes
Me.HyperLinkMP3 = strMP3

You could then view the notes file and listen to the song.

To get the filename, consider
http://www.mvps.org/access/api/api0001.htm

To open the file, consider
http://www.mvps.org/access/api/api0018.htm

To get the filename, check out HyperlinkPart in Help.

I usually split the display text from the file name using HyperlinkPart, set the color to blue underline for the display text and use the dbl-click event to present the file.

Bright Future
http://www.youtube.com/watch?v=wvIAyxpjEuc

.

Relevant Pages

  • Re: Music Notation
    ... I also used to load images into the database but it did bloat the database ... and associated midi filenames, for a musician, blah blah blah. ... I would probably create a hyperlink in the table, scan the song to a file, ... To get the filename, ...
    (comp.databases.ms-access)
  • Re: Pop songs in ads
    ... music in commercials and ads. ... I won't do a paragraph by paragraph notation of the above article, ... out the old canard, "Well, at least the commercial is helping the song ... And this above paragraph deftly and succinctly demonstrates why you are sometimes charged with superciliousness...characterizing somebody offering a sincere opinion on the subject as "trotting out old canards", and "blah blah blah". ...
    (rec.music.beatles)
  • Re: FMA - 26
    ... Sure, it's a little on the sappy, side, but when you contrast ... >Blah blah blah. ... A sappy love song is just the thing to ... Nya! ...
    (rec.arts.anime.misc)
  • Re: Dylans 25 worst song titles
    ... (where "imagination" scores points) ... conversation (where well-written dialogue scores points, ... types of song title. ... blah blah blah... ...
    (rec.music.dylan)
  • Re: I require a very simple script
    ... I need a script or basic program which ... FILENAME IS PERFECTLY ORGANISED (FOR EXAMPLE, THE FILENAME TO ONE SONG ... THE ID3-TAG OF EACH MUSIC FILE TO ITS CORRECT INFORMATION, ...
    (microsoft.public.vb.general.discussion)