Search results for query: *

I have a Windows NT 4.0 server where the mouse stopped working. It is your basic 2 button serial mouse. It used to work fine with the 'Microsoft Serial Mouse Driver'. Then it stopped working. If i choose change on the general tab of the Mouse applet in control panel it shows Microsoft PS/2 Mouse...

I have a report that prints from a VB app through the CR8.5 Report Viewer. There are several subreports that are linked to the main report by parameter values. In all there are 36 parameters (4[ParamsPerSubreport] * 8[Subreports]). For some reason one of these parameters is always prompted for...

I have a report that prints voucher information from SQL tables. It uses several subreports for different pricing methods that require different information. All of the tables in the report and subreports have 4 fields in common; Voucher, ContractorType, ContractorName, BrandName. The Grouping...

I am using a VBA macro in Word 2002 (office XP) to format a document. One of the things i want to do is place a page break before the line "PACIFIC RIM LOG SCALING BUREAU, INC ". I only want to put a page break before it if it is NOT the first thing on the page. For example, in the...

I have created a table in my database to report on errors during an invoicing operation. I am using multiple joins and CASE statements to build a table with all the information needed to print an invoice. The resulting temp table has a column named VALUE that is set based on many different...

VB60, CR 8.5 RDC, SQL Server (ODBC), and CrystalDataObject? i am getting so tired of packaging an app taking longer than writing it. please help me, anyone? Ruairi Could your manufacturing facility benefit from real time process monitoring? Would you like your employees to be able to see up to...

I have a development database on SQL Server 6.5. The production server is running SQL 2000. I have a database creation utility but it is very out of date. I was wondering if it is possible to generate a script for all objects in the 6.5 DB and use this script to create the 2000 DB (i know how to...

I am getting ready to do the first install of a client server db program. I just got the packing list for their server and had a few questions about how to instruct the IT department to cofigure the server. Here is the important info about the server...

I am printing a Crystal Report from VB off an ADO recordset. The DB is SQL Server 6.5. This report requires information from many different tables. One of the peices of information i need to get is the camp run grade for each species. The camp run grade is defined as the lowest ranked(biggest...

I have some fairly complex reports that i am running from a VB 6 application (reporting from a SQL 2000 DB). The client wants to add the ability to view these reports from their web server. The problem is that in my vb app i am generating a sql statement based on the parameters chosen on...

I am using Wonderware Intouch to generate report by sending email ( I use the SendMail script command). The message is sent successfully at the first time, but in the WWlogger, it was reported that the command has generated unspecified error. Do you have any advice about it? Looking forward for...

I have a visual basic application that prints reports from a SQL Server 2000 DB using Crystal Reports 8.5 Viewers. All Of the reports come up in the preview window correctly but only one of them actually prints to the printer. When the built in functionality of the print button wasn't working i...

I have a report with 2 columns of data, a species name and a grade name. A species can have many related grades, like this: SPECIES GRADE ------- ----- DF 1SM DF 2SM DF 3SM DF...

I have a project written in VB6 (Active-x dll, contains crystal report designers as well as a few forms, standard modules, and a class module) that refuses to compile. Clicking on make .dll brings up the 'Compiling...' progress bar but it quickly disappears and the VB IDE stops responding. I...

I have this statement inside a stored procedure (SQL 6.5 VB6 client using ADO through ODBC) set rowcount 1 -- begin search, normal log select @tsortsrec = @logssortsrec --Added 5/30/2001 -- skip the grade-incrementing search if there is no price with this species, sort, vbd, contractor...

I have posted a few questions on this forum about a large transaction that is not committing fully. I have foun the culprit, this SP: -------------------------------------------------------------------------------------- if exists (select * from sysobjects where id =...

I asked a question in this forum a while ago about transactions where only the tail ends were commiting. I posted a lot of information because i wasn't sure what was causing it. If i watch the locks in the SQL performance monitor and also watch the performance tab of the Task Manager on the...

I don't know exactly when this started happening but i've noticed that i no longer have the 'Definition' and 'Last Position' entries from VB's context menu. I'm sure theres probably a very simple solution, anyone know what it is? Ruairi Could your manufacturing facility benefit from real time...

I originally posted this question in the SQL Server forum but as i do more testing on the problem it seems to be on the client end (an ADO application written in VB). I can't seem to make any headway tracking down this bug and am hoping someone has seen a similar situation. Below are the posts...

I am having problems with long transactions not comitting fully. I am working on an accounting system for sawmills. One of the functions of this system is to import data that is sent in the form of text files from scaling bureaus. These files contain information about loads and logs (each log...