Search results for query: *

Hi, I'm tring to just get a file name from a file path I have this C:\Windows\folders\file.txt,want to Get this File.txt I think this is posible but not sure how to do any suggestions would be great, thanks Timmeh

Here is the SQL I use, it looks for a the path to a mp3 file that corresponds to what they click in the datagrid. SELECT TrackList.TrackFilePath FROM TrackList WHERE TrackList.Album_ID = ( SELECT Album.Album_ID FROM Album WHERE Album.Album_ID = lblAlbumID.Caption) and TrackList.Track_Num =...

CCLINT Yes I do have functions in query,but I don't really understand the Code you showed me or how I can use it to solve my problem.

Hello, My problem is when my VB 6.0 application queries my Access database (set up through Visual Data Manager). My SQL statement work fine, it find the record when it should and returns with nothing when it doesn't find a match. The problem I'm having happens when it's should return no records...

I'm trying to find out if the recordset can back empty so that if it does I can perform certain tasks like the follow If adorecordset.BOF or adoRecordset.EOF Then msgBox "No matching records where found" Else msgbox "A matching record was found" End If It never gets...

Thank you for the help johnwm you have been a big help.

Johnwm, I was more looking for it properties so I could figure out how to use it in code like: MediaPlayer.open = "C:\filename.mp3" MediaPlayer.command = "play" I was trying to get more information on how to use it in code, guess I'll have to play with it till I get it...

I'm trying to use Window Media player in vb to Play MP3/Wav files. I've been to MSDN an looked for info on it but I could not seem to find any. Any info to other site or resources would be great help Thanx Timmeh

I don't know what a UDT array variable is nor how to use one, guess I have a little research to do. Thank you Zemp

Hello, Here is my problem (well not really) I am write an application that I want to store Data from a relational DB in to variable so I can use them else where in my program(Send the values into functions). I'm connecting to the DB through code not through a data control. I tried connecting it...

I'm new to VB and I've run into a problem with adding new records into a relational database. Basically the application I'm writing is for my CD collection. It has the artist name, album, year, producers, songs, bandmembers, etc. In the database I have a table,Artist with just the Artist_ID Name...