Search results for query: *

I am trying to display the value from a "application defaults" table on an entry form to show the user the unit of measure they are working with. The default unit of measure is stored in a single-record table (tblSystem). I have a query that will return the value I want to display. I'm having...

I have a planning tool that was written in Excel. It has planned production by day for a given product. The products are in column A and the various days are in column B, C, D, ... Not every product is produced each day. I need to build an output file that lists which products are to be...

We have been given an XML format that we need to generate for submitting environmental data to the Ontario Ministry of the Environment. Below is a sample of data that was provided. I can import this into Excel but when I try to verify this for exporting, or even export with the validation...

Have a web site that is no longer working after SP2 upgrade to XP. The site has a field (graphics field I believe--input field with a browse button) that is used for designating a link to a different web page or file. Before the SP2 upgrade the user was able to paste in web links (http:...)...

After rebuilding my W2K machine the A: drive doesn't seem to be working. I used it to re-build the machine but now it won't read any of the floppies that I have. When I try to read one it says the floppy needs to be re-formatted. When I try to format the floppy (in DOS window) the message...

Within the past few months my computer (running W2000 5.00.2195 SP4 has started rebooting on a frequent basis. I get a blue screen with a message: IRQL_Not_Less_Or_Equal and a reference to the ntoskrnl.exe file. The rest of the messsage has hexadecimal values. I am running Nortan 2003 and...

I have some stored procedures that I would like to improve the maintenance efforts on. These stored procedures execute SQL statements from different databases on different servers. I would like to be able to make the stored procedures more generic so I don't have to change the server and...

I have a customer who wants to convert some SOPs in an Access database into formatted Word documents. They want to move away from a home-grown SOP program and use Word since they have had a lot of formatting and maintenance issues with the Access program. Any suggestions would be greatly...

Within the past couple days I've had some interesting things occur on a home PC. The CPU is constantly at 100% with WINHelp.exe and services.exe processes taking up the majority of the CPU. Also, in Outlook there were over 16K e-mail messages that were trying to be sent. When I tried to...

I have some worksheets that I need to upgrade but would like to have a way of comparing forumlas between the new and old versions to show any differences. These worksheets have very long formulas and it is very painful to check manually. I've been able to put together (with help from reviewing...

I'm looking for a tool to use over SQL Server that allows for interrogating the database journal to show all changes made to specific records. I have used a similar tool on DB2 (rptjrn) which is fantastic! It proved invaluable when debugging programs or tracking down production issues. Is...

We are using CR 7.0 and have been using, in some instances, Crystal Queries to help generate the reports. One thing that has been noticed is that when we change the Crystal query, the entire report needs to be re-developed. Is there anyway, using Crystal Query, go get around re-developing...

I am trying to print from a Windows client to a Datamax Prodigy thermal transfer printer. The printer requires control characters in order to generate the label (using Datamax's proprietary commands. I have been trying to use the Generic / Text printer in windows but it does not print true...

We are using an application written with Remedy to capture information concering support calls and change requests. The remedy application is written over a SQL Server database. We have developed some reports, using Access, to view and print these calls. One annoying thing about the reports...

I have a client-server application which requires a specific System DSN name for generating reports from it. I now have a few users who need to generate reports from different installations of the application. This can be done if the Server name in the System DSN is changed to the server they...

We currently are using Crystal Reports 6.5 against a SQL Server 6.5 database. The problem we get into is that the database name gets embedded into the report. As a result it makes it basically impossible to run one report against our production, developmnet and QC databases.<br> <br> Is it...

We have an application developed in COOL:PLEX 3.1 running on NT, with SQL Server 6.5 and Crystal Reports 6.0. The application is client-server developed in C++.<br> <br> We are looking for a way to easily integrate the Crystal reports with the application. The intent is to allow the reports to...

We have an application developed in COOL:PLEX 3.1 running on NT, with SQL Server 6.5 and Crystal Reports 6.0. The application is client-server developed in C++.<br> <br> We are looking for a way to easily integrate the Crystal reports with the application. The intent is to allow the reports to...

Is there a way to format a cell or header/footer in Excel97 to show the path of the file being printed? Word97 now has this capability, but have not been able to figure it out in Excel.<br> Thanks!