Search results for query: *

The Query name is "SongFind" and the field I need data from is "SongFile". Some of the code are remnants of a previous version of this that cycled through hyperlinks of the SongFile fields and activated each one as it went. The DoCmd.GoToRecord was part of the loop. That code worked fine for...

I think I have solved the loading of the field value. Here is the whole code with my fix: [code] Public Function NewPlay() Dim rsTable1 As Recordset Set rsTable1 = CurrentDb.OpenRecordset("SongFind") Do Until rsTable1.EOF 'DoCmd.GoToControl "SongFile" Shell...

I have my music database in Access. My SongFind Query has a field SongFile that lists the full file path name of each song. I have written code to open winamp and cycle through the SongFile column, but I can't figure out how to get that song file data into the shell code. The troublesome line...

Let me refine my problem. I have a field of hyperlinks in a query. I have written a macro that runs through each hyperlink in the field and activates them. It was working fine for the longest time. Now each link gives me a warning, "Some files contain viruses . . . be certain this file...

I have a field of hyperlinks in a query. I have written a macro that runs through each hyperlink in the field and activates them. It was working fine until I installed a new version of the software that runs when the hyperlink is activated. Now each link gives me a warning, "Some files...

When I disable ZoneAlarm the same thing happens. It makes no difference. I can configure ZoneAlarm not to start at Windows start-up, and then when I tell ASaP to manually Update Now, I still get the "Unable to Connect to Update Server" message. For what it's worth, when it is...

I have ASaP on my Win98 machine. I am able to go to the download site and download new versions with no problem, but once loaded, ASaP will not go out by itself and update itself like it is supposed to do. When I manually right click on the tray icon and tell it to Update Now, I get a message...

In Access 2000 I run a query that returns a different number of records each time. I want to run a macro on those records, but I need an expression that allows the macro to repeat itself only the number of times equal to the number of records returned by the query. I am running a macro within...

Guys - Thanks for the quick responses. The Winamp files have been properly associated all along, i.e. when I double click on an mp3 file, Winamp opens and plays the file. With Terry's suggestion I created the following module: Function Terry() stAppName = "C:\Program...

I have an Access 2000 db of my favorite songs from hundreds of albums. I have also begun recording those songs in mp3 format and storing them on my hard drive. One of my queries returns the full path name of each song file as the field [SongFile]. I can query the db to get a list of songs I...