Free Jukebox for helpers!!! -Question set #2

[GKite]

OK just so there's no confusion this jukebox i'm referring to will be an access database, not real hardware.

For those who have been helping, thanks ALOT

Now I have a couple new problems. I've never had to do tasks quite like these so I'm not really sure what direction I should go in. If you can help in either situation you'll be added to my list

1) I need to be able to write a text file based on data from a table/query. So for instance if I have 3 table entries, I need to write something like this:

Table Entries:
45
12453
332

Text file to write:
[some header info]
C:\softjuke\files\45.mp3
C:\softjuke\files\12453.mp3
C:\softjuke\files\332.mp3

2) One of the functions of the database is to allow the user to make favorites playlists. This is simple enough and works fine. However, I need to add the functionality of looking for the same name that the user is trying to save. If the name already exists, then of course the 'overwrite/cancel' option. I can handle the overwrite/cancel part I think, but not sure what type of commands or methods to use to verify the duplicate naming.

Once I get these two issues resolved, the 'functionality' part of the database will be ready for beta testing. If you want to be on the beta test list please email me at gregorykite@hotmail.com. All other helpin' folks will get a more completed copy.

Thanks!!!

 

[GKite]

OK so I've almost got the 2nd issue above resolved, except for 1 tiny problem...

I used the following code to look for a dulicate entry in a table vs a field on a form. Everything seems to work ok, BUT I'm trying to use and IF THEN statement based on the value of a variant, and it doesn't work at all! If the variant = null then the intSkip = 2. If the variant = 'something' then the intSkip = 2. Why is this???
Dim stDocName As String
Dim varDupe As Variant
Dim inSkip As Integer
stDocName = "qryPlaylist_Save"
varDupe = DLookup("[Playlist]", "tblPlayLists", "[Playlist] = [txtPlaylistname]")
If varDupe = Null Then inSkip = 1 Else inSkip = 2

 

[GKite]

Well I guess I'm all alone in here! Just wanted to make another post telling you that problem #2 is resolved!

OK Guys I'm down to just one dilema, problem #1. So close... SO close.... help please!!!