Music Notation

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

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

Re: Music Notation

Ahhh yes, that is what I currently do. I don't really like it because of
the proliferation of files.

I also used to load images into the database but it did bloat the database
somewhat, although I'm inclided to return to this soon due it it's
consolidation benefits.

Still, if I could draw (say a midi file) graphically on a form, the whole
lot would shrink by a MASSIVE 95% or better.

Any graphical drawing code would be appreciated.

"Salad" wrote in message
news:13penqjspm3dv10@corp.supernews.com...
> 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
>

Re: Music Notation

Dominic Vella wrote:
> Ahhh yes, that is what I currently do. I don't really like it because of
> the proliferation of files.
>
> I also used to load images into the database but it did bloat the database
> somewhat, although I'm inclided to return to this soon due it it's
> consolidation benefits.
>
> Still, if I could draw (say a midi file) graphically on a form, the whole
> lot would shrink by a MASSIVE 95% or better.
>
> Any graphical drawing code would be appreciated.

I suppose you could do it if you had the time. I guess I would do it on
a monitor with high res settings so you could display a few lines of the
song.

Initially I was thinking that you'd create a form with labels to show
the treble/bass lines and using graphic images for the notes and
entering like A for an A note, Shift+A for Asharp, CTRL+A for Aflat and
the graphic images would be the label's caption. But printing bridges
and rests and all the others seemed to make this a major project.

Then I wondered if there was a musical "unicode" set of symbols that
could be used. So I googled on that and that put me onto fonts so I
searched for "musical note fonts" and by gosh, there's some. For
example...http://www.icogitate.com/~ergosum/fonts/musicfonts .htm.
There's
http://www.linotype.com/156360/musical-family.html?gclid=CI2 z4bX8m5ECFSosagodA29mPg
as another example.

You'd have to devise code to determine which line a note goes to but I
think with fonts it is a doable enterprise...if you have the time. Did
this help?

Music makes the poi go round
http://www.youtube.com/watch?v=iDnzInHMa_g




>
> "Salad" wrote in message
> news:13penqjspm3dv10@corp.supernews.com...
>
>>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
>>
>
>
>

Re: Music Notation

Problem with fonts is that I'd have to install it onto client pc's
especially without "Package and Deployment" add-in (not that it laded any
fonts mind you), and that's a pain.

However, I'll have to work a way around this as I think it's still a great
idea.

My next project is to find out how to layer a text (not a text box) on top
of an image using pixel placement.

Thanks Salad


Dom

"Salad" wrote in message
news:13puplakphocv60@corp.supernews.com...
> Dominic Vella wrote:
>> Ahhh yes, that is what I currently do. I don't really like it because
>> of the proliferation of files.
>>
>> I also used to load images into the database but it did bloat the
>> database somewhat, although I'm inclided to return to this soon due it
>> it's consolidation benefits.
>>
>> Still, if I could draw (say a midi file) graphically on a form, the whole
>> lot would shrink by a MASSIVE 95% or better.
>>
>> Any graphical drawing code would be appreciated.
>
> I suppose you could do it if you had the time. I guess I would do it on a
> monitor with high res settings so you could display a few lines of the
> song.
>
> Initially I was thinking that you'd create a form with labels to show the
> treble/bass lines and using graphic images for the notes and entering like
> A for an A note, Shift+A for Asharp, CTRL+A for Aflat and the graphic
> images would be the label's caption. But printing bridges and rests and
> all the others seemed to make this a major project.
>
> Then I wondered if there was a musical "unicode" set of symbols that could
> be used. So I googled on that and that put me onto fonts so I searched
> for "musical note fonts" and by gosh, there's some. For
> example...http://www.icogitate.com/~ergosum/fonts/musicfonts .htm. There's
> http://www.linotype.com/156360/musical-family.html?gclid=CI2 z4bX8m5ECFSosagodA29mPg
> as another example.
>
> You'd have to devise code to determine which line a note goes to but I
> think with fonts it is a doable enterprise...if you have the time. Did
> this help?
>
> Music makes the poi go round
> http://www.youtube.com/watch?v=iDnzInHMa_g
>
>
>
>
>>
>> "Salad" wrote in message
>> news:13penqjspm3dv10@corp.supernews.com...
>>
>>>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
>>>
>>
>>