Recent content by mulligh

Nevermind. I'm withdrawing the question.

Thanks. I know about FSO, but I was just wondering whether anyone has seen a script that does this. I've found scripts that work in Excel but not Access.

Hello all I want to get a listing of files in a particular directory and turn that into a table in MS Access. I also want to get the lastmodified date of the file and also the filesize. Since the contents of the directory change, I'll need to refresh the table either automatically when the...

Hi- I need to remove all spaces and punctuation from a string. What function do I need to use? For example: Trees. Blue Spruce Trees, Large. Redwood Output: TreesBlueSpruce TreesLargeRedwood Thanks for your assistance!

After fixing this stupid mistake, the query ran great (of course). Thank you so much for your time and help, I REALLY appreciate it. :)

OK, stupid me, I had the wrong field name in SELECT, should have been "Names" instead of "Name".

Thanks for your continuing assistance... SELECT ID, [Description of image], Concatenate("SELECT Name FROM tbl_names WHERE ID=" & [ID],Chr(13) & Chr(10)) AS combined_names FROM Main; Note that [Description of Image] is the fullname of the field "Description" that I gave in my example.

And I forgot to add that when I debug the error, it opens VB and highlights this line: Set rs = db.OpenRecordset(pstrSQL)

Thanks for your help...I'm getting closer... When I run the query, I get an error 3061 "Too few parameters. Expected 1" Here's the module I'm using (comments removed) Function Concatenate(pstrSQL As String, _ Optional pstrDelim As String = ", ") _ As String Dim db As...

Thanks for the tip...I have already seen this but am unclear how to construct the SQL statement for my database. I was also wondering whether I could just use the INSERT INTO SQL statement instead?

I have been reading the FAQ's and don't know the best and easiest way to approach this. Plus, I don't have a lot of experience writing SQL statements, so would appreciate some help. I have a table "Main" that has a one-to-many relationship with table "tbl_names". They are linked on field...

I have a combo box with a number of options. When the option changes to "Catalog" I want to run some code but only if the current option was set to "Review". Which event properties do I use to check the value of the current option vs. the changed option? Thanks for your help.

Thanks. This was enough info to narrow the search and I found this script: http://www.xefteri.com/articles/show.cfm?id=22

Is anyone aware of a completely free Microsoft Word to HTML batch conversion tool (EXE, VBScript, JScript, etc.)? I've looked at the popular download sites like CNET and haven't found anything. Thanks. Mully

I have a series of numbers in a field like this: 6.10 7.12 8.100 8.101 8.102 9.10 9.11 10.10 10.20 This was originally set as a text field, but it wouldn't sort the numbers correctly, so I changed it to a currency field. Now, however, if the decimal place is set to "auto", the third digit...