Search results for query: *

Ok...Looked around and haven't been able to find what I'm looking for on this, so hope you guys can help me out. I am trying to automate some of the tedious task within a report. I need to connect to a mysql server every day and create links to the newest tables in Access and then do an...

HarleyQuinn...How would I go about doing that. What would the code look like in this case?

Adding fields to the report with less columns wouldn't work cause the specs to output each table are different(line length, filler spaces, etc...). At this point I'm looking at running both tables into one line and outputing it to text, then editing the file with Notepad++ to insert a New Line...

I'm outputting it to a *.txt file to be run as a script.

Well they do not have the same columns...they are different sets of data and column headers. Also I need the Table B to be on a new line. Also this is with 6000 lines on each table. Thanks, Stump

I have an Access Database that I need to stagger the two tables on output. Both tables have the same number of records, but different data and I need to show line 1 of table A, then on a new line I need to show line 1 from table B, then on a new line line 2 from table A and then on a new line...

As an additional note...When I mark the 'Sendobject', 'edit message' to "YES" it opens the email with the attachment and allows me to send it that way...however that requires intervention I'd rather not have.

I recently ran into an DLL issue and our IT department repaired Windows, as well as reinstalled Office Premium. Before this I had several reports that would run and send on they're own. Now since the Repair of Windows and reinstall of Office I am unable to run these processes and I get the...

When I run this it comes back with this "Run-time error '3011': The Microsoft Jet database engine could not find the object 'Filename....csv1207: Make sure the object exists and that you spelled it's name and the path name correctly" So it's recognizing the file name per my format...and it's...

Yes I did...it runs fine without errors and gives me the msg box of "no files found" as I told it too if there is nothing to import. I'm still at a loss.

Here's the scoop. I am trying to link to all files on a network drive..my strfile looks like this "strFile = Dir(strPa * th & "FileName*.csv")". My problem is the individual files were modified after they were stored and now the end of the file names look like this "filename... .csv120706.csv"...

Whoohooo...that got it. Thanks a lot guys!

Still blank...just to reiterate here's my code again. Am I missing something? Public Function Import_From_TEXT() 'Macro Loops through the specified directory (strPath) 'and imports ALL Excel files to specified table in the Access 'Database. Const strPath As String =...

That didn't seem to work either. I assume I replace "table1" with "tmpLetter_Files" as below: '============================================== MySQL = "UPDATE tmpLetter_Files SET tmpLetter_Files.field20 = '" & FileName & "' WHERE (((tmpLetter_Files.field20) Is Null));" DoCmd.RunSQL MySQL...

Come on I know it's Friday and all, but I could really use the assistance. Anyone??

Just to clarify I want a column and for it to list the files that the data comes from. I'm dealing with about 300 files initially to get it started, then I'll setup a daily batch run.

Hey all. Need a little assistance here. I originally found this code online somewhere and someone here at my office helped me to modify it. However now I need another modification and the most knowledgable person here is out for the weekend. So I'm hoping you guys can help me out. The...

Well I ran across a handy Outlook Add-in tool (using Demo for first 30 days) that allows you to tell it what outlook folders to look in and it will output the attachments to a specified folder/file for you. Plus it has a built in Scheduler, so I can specify time and days or I can have it check...

Yes it's always a *.xls file. Either way I think this is going to be way over my head. I'll do some searching around and see what I can find.

Yes they are all *.xls files. I'm thinking this might be way over my head. Basically what I'm looking to do is have the DBase pull these files in daily and then build the forms and queries so that others can pull the stats from them in daily/weekly/monthly. However I'm trying to make the...