Search results

Here's another useful piece I found... the genre list based on the ID3v1/2 standards, which means you can pull the genre from the tag & map it to the correct description by building a table from the following data *sigh* so much for getting any real work done this week... ;-) (copy and paste...

heh. found this code on the web... might work for VBA... ' Create a new code module and paste this code into it: Option Explicit Public Type ID3Tag Header As String * 3 SongTitle As String * 30 Artist As String * 30 Album As String * 30 Year As String * 4 Comment...

I didn't know about the /PLAY option, that will be really nice... I was looking at this & I might actually build my own... the possibilities are pretty neat... did either of you figure out a way to pull info from the ID2/3 tags on the files, or are you maintaining seperate databases with...

can you post the current code you are using? It should be pretty easy to tweak & get it running... Here's an example of a simple form with 2 text boxes and a button. Try creating it just to test with & go from there... text box #1 - path to winamp value = "C:\Program Files\winamp\winamp.exe"...

You can call winamp from a command line like this: "c:\program files\winamp\winamp.exe" /ADD c:\music\file1.mp3 (double quotes are required if any part of the path contains spaces) If you want to play multiple selections, you still use the /ADD command, but each subsequent filename has o be...

Is there ANY way to turn off the Outlook 2002 email warning asbout another propgram sending mail when I'm using the SendObject command from VBA??? It always worked in 2000... I use Access to run a lot of nightly stuff & this will completely ruin it... meaning I would have to sit here for 30...

http://www.bpro.com/Reports/R_list.htm

Is there a way to convert a given hex value into it's corresponding character? If you look at http://www.asciitable.com/ as a reference, what I want to do is this: If a text box has a value of 64, I want to be able to return the subsequent character, in the case of 64 it would be d. [This...

I have a text file, similar to an .ini that I want to read only from an Access form... what I would like to do is populate a list or combo box with the section headings from this file, it looks something like this: ************** [Management] Manager One Manager Two [Support Staff] Support One...

Is there a way to clear the contents of an external file through Access? I want to import the contents of a text file into a database and then without deleting the text file itself clear all of the records I just imported, i.e. truncate the source file. I was thinking of compiling a small c++...

use hyperlinks inside your DB. On whatever form or interface you are using, just add a link to the document file. Then, if you swap it out on the web end, clicking on the link jumps to the most recent copy. look at hyperlinks in Access help, they show you exactly how to set one up...

Couldn't you send the email to each recipient one time, instead of sending it to them via the same message? Most mailing lists operate in this fashion because a lot of ISP's see multiple recipient message as spam or junk mail and won't deliver them anyway. Other advantages to going this route...

The code looks fine to me... just place it in the "OnCurrent" event of your form instead of the change & it will runn every time you navigate to a new record. If I'm not mistaken, the change event only fires when a control or record is modified. OnCurrent runs when the focus moves to a new...

there is a file/folder selector Module you can create, I got this from Access Web & modified it for my own needs... it works extremely well, and you can modify the file type you are looking for within the dialog quite easily: http://www.mvps.org/access/api/api0001.htm

I run something very similar right now, and I approached it like this. My tables get swapped out every month with new data, so when I import the new information and run queries, etc. I do them based on a standard table name. This is what happens when the end user initiates the import...

OK I see what's happening then... since you're evaluating a calculated field and displaying it as a percentage... so the "% To Objection field" needs to be calculated based on the actual numeric value of the "% To Objection" field, not the percentage value (in other words, the actual value of...

if ModuleCode is a numeric field, change the DCount line to read If DCount("[ModuleCode]", "tblStaffModules", "[ModuleCode] = " & Me.CboModule) = 0 If ModuleCode is a text/alpha field, use this: If DCount("[ModuleCode]", "tblStaffModules", "[ModuleCode] = " & "'" & Me.CboModule & "'") = 0

Is the "% To Objection" field just a number, or is it an actual percentage calculation? Also, if you're doing this from VBA, it would be done differently... the code I mentioned above would be appropriate as a query expression, or as the control source on a report or form... [This message...

If the percentage stored as a number, this should work I also added an error trap at the beginning for null values... IIf(IsNull([rating]),"No Data Available",IIf([rating]<100,"D - Needs Development",IIf([rating]>99.9 And [rating]<115,"M - Meeting Standards",IIf([rating]>114.9,"E - Exceeding...

Does anyone know, or has anyone come up with a way to open a browser window from a hyperlink button and have it not display the toolbars, status bar, etc? Just curious... thanks!