Search results

OK so can anyone tell me what's wrong with this code? When I run it I get an 'invalid call or procedure' error. Dim strSong As String Dim RetVal strSong = "C:\softjuke\files\28.mp3" RetVal = Shell(strSong, 1)

Have it start off by going to a new record.

Can you be more specific? I've tried both of these ways and niether is working for me. Any ideas? Shell (strSong) Shell ("c:\softjuke\files\28.mp3")

Yes that qualifies as help! New question: I'm trying to make a button that will run an application. The button wizard isn't working as I get an 'invalid call or procedure' error. Anyone know the vba for a simple 1 line way of opening or running an application? Hyperlinking is not an as the...

wizcow- unfortunately I need to automate the exporting process. The user might want make a playlist dozens of songs long. NeilW- no that doesn't count! But with you're enthusiasm i'll add you to my list NEW info - apparently access databases have a limit of 2 gigabytes, so I'll have to...

OK just so there's no confusion this jukebox i'm referring to will be an access database, not real hardware. My project: I own almost 800 CD's. I'm writing a database, that will have these CD's embedded into the tables. Once the music is placed into the database, there will be a type of...

If the form data is tied directly into the table, you might try making a query, then tying the form to that query. This way you could set the field of your choice to be in ascending order.

I had to do something similar to this and it went kinda like this: Do the normal calculation including nights and weekends. Then, look at the time 'in' stamp. If the total time from the time 'in' stamp to the time 'out' stamp is greater than the time from the time 'in' stamp to a night or...

You should be able to move the focus using the SetFocus to the parent form, then perform the Next record operation. Maybe end it by moving the focus back to the child form.