I have a form which has about 35 buttons on it. Each button plays a music file. At present the string I use to determine which file to play is like this....
Dim playlist As WMPLib.IWMPPlaylist
playlist = Me.AxWindowsMediaPlayer1.newPlaylist("Playlist B1", "")
Dim item As WMPLib.IWMPMedia = AxWindowsMediaPlayer1.newMedia(Form2.TextBox1.Text)
AxWindowsMediaPlayer1.currentPlaylist = playlist
As you can see it finds the file location from the text box on form2. Is there a way of getting it to read directly from the database rather than from the text box on form2?
The database itself has 1 table called Locations and it has 35 fields (1 for each button) labeled Cue 1, Cue 2, etc. etc.