Search results for query: *

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

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.

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

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

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?

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

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

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

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

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

yes very much so thank you

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.

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

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

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

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

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!

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

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

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