Recent content by sstump

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