Recent content by MPBCHM

Thanks for the quick reply... What I want to do is Create a table, insert data, and based on filter criteria, tag each record line with code... Code Name Filter: AFLU Adult Flu Report claim_details.proccode = '90724' DENT Dental Report...

I need to create over 40 different reports that pulls data from the same 4 tables. What I have done so far is to create a view for each report that filters the data accordingly. This has left me with 40 Views (SQLSERVER) and 40 reports(Crystal). I know theres an easier way to do this and so...

I am trying to automatically export a report to PDF from a function/macro in Access 2000. When I run the following code I get this error message: "Server has not yet been opened." When I click "Debug" the program hi-lights the last line of my code: rep.Export False...

I am trying to automatically export a report to PDF from a function/macro in Access 2000. When I run the following code I get this error message: "Server has not yet been opened." When I click "Debug" the program hi-lights the last line of my code: rep.Export False...

Thanks for the response... The word wrap part of it I could live without but its the import part thats got me. Any suggestions on how I can get the text file to open up in a textbox. I had thought about creating BMP images of each document and then using the OLE object box to dislay the...

I have a FORM, with a TEXTBOX and a LISTBOX Senario: My listbox has the names of textfiles found on my hard drive. When I double click on a selected textfile, I would like to view the contents of that textfile in my textbox. Also, if possible, I would like to make changes to that textfile and...

First, what are you using to perform this "Manual Release"?? A query, macro, code??? Next, how are you sending the email? Is this automated? Now when you say "DBA" you mean a person, not a program, correct? Are you doing the email manually as well? If so, this process...

Thanks for all the help you guys gave me. I meant to close this thread out weeks ago. The code to remove blank lines from text files worked out great. Thanks again. Mark

Hi Sandy, I got an error when I tried to run the code below... Option Compare Database Option Explicit Private Sub Command0_Click() With Application.FileSearch .LookIn = "C:\RptDbase\Encdata\Outfile\" .SearchSubFolders = False .FileName = "*.txt&quot...

Hey ETID, Thanks for the help. Your code worked out great. But... I need to do this for about 100 text files. Is there an easier way to process this many files without having to write out the code for every file in my list. i.e. Open ("C:\MyFilePath\MyTextFile.txt") For Input As...

I have a ReportWriter program that exports data into a "fixed-width" text file. During the export, the ReportWriter inserts a blank line at every page break. "This is a bug in the program." "I need to remove these blank lines." I have been using a blankline...

Hey Kevin, My ODBC's are setup as a "User" in the Machine Data Source" tab. No other users are connecting to the database I am using. We are currently running two databases. A "Production Database" and a "Report Server Database" All users are connect...

I have been thru the FAQ's and Keyword Search and noticed almost all of the ODBC questions asked had no responses and the ones that do are vague. Is there something wrong with asking an ODBC question? Is that a taboo subject in Tek-Tips? Why doesn't anyone like to answer these questions...

I created a linked table using the "Create Table Wizard". If I close the database and later reopen it and then try to open one of the linked tables I receive the following error message: ODBC connection to 'ezcap Angeles1' failed (after clicking "OK" the next message is)...

Hey Rod Thanks for the help... Worked like a charm. One thing, I had to enter the entire file path for the hyperlink to work. I tried your way >>>> "..\PhoneProgramming.doc" and that didn't work for me. I used "\\rptdbase\encdata\batch\filename.bat" and that worked...