Search results for query: *

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

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

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

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

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

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