Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Rhinorhino on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. mulligh

    Directory listing to table with file attributes size and date

    Nevermind. I'm withdrawing the question.
  2. mulligh

    Directory listing to table with file attributes size and date

    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.
  3. mulligh

    Directory listing to table with file attributes size and date

    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...
  4. mulligh

    Remove punctuation, spaces from string

    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!
  5. mulligh

    Combine fields from two tables into a single field

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

    Combine fields from two tables into a single field

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

    Combine fields from two tables into a single field

    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.
  8. mulligh

    Combine fields from two tables into a single field

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

    Combine fields from two tables into a single field

    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...
  10. mulligh

    Combine fields from two tables into a single field

    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?
  11. mulligh

    Combine fields from two tables into a single field

    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...
  12. mulligh

    Which event(s) do I use to check current status before executing code

    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.
  13. mulligh

    Batch DOC to HTML converter

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

    Batch DOC to HTML converter

    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
  15. mulligh

    Decimal point filter

    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...
  16. mulligh

    Set value of database generated form

    Thanks. This is exactly what I needed.
  17. mulligh

    Set value of database generated form

    I need to change the value attribute on an <input> element created by a database form. The form is created by a database program, so I don't have control over how that form is created. I only want to change the value of one of the <input> elements after the page loads. The form looks like...
  18. mulligh

    XSL - White Space

    You don't need to declare it. Just use the built in entity of & #xa0 ; (remove space after & and before ; as usual)
  19. mulligh

    Combo box lists file names in specific directory

    Doug, thanks so much. This is exactly what I needed. And thanks for taking the time to write the comments throughout the code. Appreciate you taking your time to help me.
  20. mulligh

    Combo box lists file names in specific directory

    I want to have a combo box that lists the filenames that are in a specific directory. Only files that have a &quot;txt&quot; or &quot;doc&quot; extension will show up in the list. Users will be able to select one of these files from the list and it will be stored in a table field so that the...

Part and Inventory Search

Back
Top