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 derfloh 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. LucasH

    running VBA through task scheduler

    Hi guys, I am stumped on this one. Windows Server 2008, Office 2010 I have some vba code that exports a table to an Excel spreadsheet and then does some formatting (basically running Excel macro statements stored in an Access vba module). It normally runs fine but we are trying to automate...
  2. LucasH

    best way to scan directories

    Im using 2003 for this implementation thank god. Whenever I connect to a client and they have 2007, I cringe. Makes things so much harder. Anyway, I will test out the FileSearch, we'll see if it's any better.
  3. LucasH

    best way to scan directories

    Thanks Gruuu I will look into it. Just trying to speed this slow process up. Not sure if it was possible but thought maybe. I will update this thread with my results
  4. LucasH

    best way to scan directories

    Yeah that's what I have now, but I was hoping to avoid having to go through each file independently as I imagine that's goig to eat up performance. Ideally, I'd like to produce an array or collection of all files with a create date > 4/1/10 for example and dump the entire thing into a table...
  5. LucasH

    best way to scan directories

    one more question... in my for each statement For Each fil In fld2.Files is there syntax that i can say something like this? For Each fil In fld2.Files where fil.Datecreate > #4/1/2010# or something along those lines?
  6. LucasH

    best way to scan directories

    This is what I have so far to include subfolders Function MyDates() Dim fso As Scripting.FileSystemObject Dim fld As Scripting.Folder Dim fil As Scripting.File Dim fsub As Scripting.Folder Dim fld2 As Scripting.Folder Dim fsubs Dim masterfolder As String Dim fsubfil WarningsOff sql...
  7. LucasH

    best way to scan directories

    Yes, thank you, I got that. Im going to check into this, but do you know a quick way to include subfolders under c:\zzz\Test\test2
  8. LucasH

    best way to scan directories

    Yes dir in vba... This looks promising I will check it out...thanks!
  9. LucasH

    best way to scan directories

    Thanks for your message... To elaborate Currently, I use dir to provide a list of files in a directory and then add the files that meet a certain date condition to an access table. I use it recursively to go into subfolders as well. once the files are in a table, i loop through each one and...
  10. LucasH

    best way to scan directories

    Hi, Im wondering what the recommended method is to scan through a directory structure is? Currently Im using the Dir command and then looping through the results but that is taking a long time. Granted there are a lot of files. But Im wondering if I could use some of windows/dos...
  11. LucasH

    vba delete query

    yes very much so thank you
  12. LucasH

    vba delete query

    Hi again, I changed my code to programmatically update a passthrough query's sql statement and it is night and day faster! Must have been Access getting in the way.
  13. LucasH

    vba delete query

    I have just one index on the table and it contains 4 columns UnitID Version FileDate FileCompany Is that what you mean by a single index? I didn't see any triggers on the table, but I was looking in the Management Console under that table and there is nothing in the Triggers folder. Could...
  14. LucasH

    vba delete query

    Hi all, I have an application built through MS Access 2003 with linked tables to a SQL Server 2005 db. My question revolves around a delete query that is taking a very long time to process. The table in question has about 5.6 million rows. I use a vba docmd.runsql statement which goes...
  15. LucasH

    display message while processing

    Hi guys, Quick question. How do I display a form/messagebox while some calculations and functions are being done by the database? I would then close it when the calulations are completed. I know how to open and close a form, and I have set the first step of my autoexec function to open a...
  16. LucasH

    text export hash symbol

    can't....stupid ADP. I ended up just inserting a row into the table before export with the column headers, that works fine. thanks
  17. LucasH

    text export hash symbol

    Hi all, Im exporting a query with a column named "FILE #" and upon export, "FILE #" becomes "FILE .". Any idea why? Is there a way around this (i tried using the "'s around text but same thing happend) besides editing the text file after export? I can't change the column header name. Thanks!
  18. LucasH

    auot tab and input mask

    That was my first thought as well, and I am not sure that is possible or not. I could try that route, but I want to see if I can do it on the form as well. Might just use a timer or something
  19. LucasH

    auot tab and input mask

    Hi all, I have create a form that will receive input from a scanner. i want the form to auto tab to the next control after a scan. I have read about using the auto-tab property along with the input mask, but my problem is that the data being entered is not necessarily uniform. Is there a way...
  20. LucasH

    terms and conditions

    Now I am starting to go insane. I have 4 GroupFooter sections (a,b,c,d). The first 3 all are set to print at bottom of page. If I select group d to have new page before, a,b,c no longer print at bottom of page, they just print right after details. if I don't set d to force a new page before...

Part and Inventory Search

Back
Top