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

    How do you use stored procs to filter data?

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

    How do you use stored procs to filter data?

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

    "Server has not yet been opened" error when exporting to PDF using VB

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

    "Server has not yet been opened" error when exporting to PDF using VB

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

    Is it possible to display the contents of a TextFile inside a TextBox?

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

    Is it possible to display the contents of a TextFile inside a TextBox?

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

    Process Automation

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

    How do you remove blank lines from a text file using VB and/or macros?

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

    How do you remove blank lines from a text file using VB and/or macros?

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

    How do you remove blank lines from a text file using VB and/or macros?

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

    How do you remove blank lines from a text file using VB and/or macros?

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

    How come nobody helps anyone with an ODBC question?

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

    How come nobody helps anyone with an ODBC question?

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

    ODBC connection to 'dbaseName' failed. "my current Access dilemma"

    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)...
  15. MPBCHM

    How can I get a command button to perform two seperate functions?

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

    How can I get a command button to perform two seperate functions?

    Now this I understand!!! One more question... I don't believe I mentioned this prior... I have several command buttons on my form. How do I incorporate them into the "Forms Code Module Window" The example is only for one Command Button. At the moment I have ten buttons, and...
  17. MPBCHM

    How can I get a command button to perform two seperate functions?

    My first question is: How do you get the "Append Query" to update [tblLog]? What its doing now is when I click the command button I get a message saying "Your about to append data..." after I click "ok" the next popup tells me that I am about to append "0&quot...
  18. MPBCHM

    How can I get a command button to perform two seperate functions?

    I need a command button to perform two functions: 1. Follow a HyperLink 2. Populate a textbox with todays date and time. The hyperlink Command buttons are on a form called frmSend_Log. So once I click the command button the hyperlink runs a batch file. Next,when the batch file has...
  19. MPBCHM

    How can I use a form to create a string & populate a field in a table?

    Thanks for the quick reply... What I need to do is create a (string) that takes portions of data from other fields on the same form and combine them. The data for this string will come from users entering data into textboxs on a form. Then, I want to populate a table based on these fields...
  20. MPBCHM

    How can I use a form to create a string & populate a field in a table?

    I need to create a field that will generate a string using the first 4 letters of one field and the last 4 letters of another. I want the string to populate a field in a table. Currently, I am using the ControlSource of a Textbox on a form to generate this string but it doesn't update my table...

Part and Inventory Search

Back
Top