User Profile

Collapse

Profile Sidebar

Collapse
Escargot18
Escargot18
Last Activity: Mar 26 '13, 07:58 PM
Joined: Mar 25 '13
Location:
  •  
  • Time
  • Show
  • Source
Clear All
new posts
  • Escargot18
    replied to Create triggers for one table to update audit table with date and time and name
    in SQL Server
    The way I do it is to create a form and open the table in datasheet view in the form. It sill looks like the table to users, but you can add an after update event to move the data along with the data and user infor into the new table. I'm sure there are better ways to do this, but this way works.
    John
    See more | Go to post

      Leave a comment:

    • Escargot18
      replied to Commas in Scripting.FileSystemObject
      in Access
      Commas in Scripting.FileS ystemObject Solved

      Thank you for the quick response. I'll modify the code to incorperate your suggestions. Unfortunately I have relatively little control over the inport file names.
      Thanks again,
      John
      See more | Go to post

        Leave a comment:

      • Escargot18
        started a topic Commas in Scripting.FileSystemObject
        in Access

        Commas in Scripting.FileSystemObject

        Hi This code works great unless there is a comma in the filename:

        Code:
        Dim dir, folder, files
dir = "c:\ValidateFiles\"
Set fso = CreateObject("Scripting.FileSystemObject")
Set folder = fso.GetFolder(dir)
Set files = folder.files

lstFiles.RowSourceType = "Value List"
For Each file In files
If Right(file.Name, 3) = "xml" Or Right(file.Name, 3)
        ...
        See more | Go to post
        Last edited by zmbd; Mar 25 '13, 03:32 PM. Reason: [Z{Please use the [CODE/] button to format posted code/html/sql - Please read the FAQ}]
        No activity results to display
        Show More
        Working...