Search results for query: *

I am experiencing very long times when exporting very large e.g.9587kb reports (in eportfolio) to .rpt format using the Active X viewer. I usually end up cancelling. Anyone else have this issue? Or is there a workaround this. Pageserver settings: 20 M before Idle Connect Closed 60 M Idle...

I need to convert a tables' julian dates to DateTime. Is there a simple way to do this? Any help is appreciated. Thanks

I have Access 97 App, that, until July, has worked fine. July 1 the subj error started appearing. Unable to de-bug - hitting blank. I've located the field which is null (ptdEnd) but unable to locate where this field is being updated. I documented the report form and discovered that the row...

I've joined several large tables into 1 table that is updated nightly. There must be bad data in the table because I received this error last night: Server: Msg 614, Level 18, State 3, Line 8 A row on page 774351 was accessed that has an illegal length of 0 in database 'THWG'. How do you...

Anyone heard of an XP patch available for Access applications to handle possible VBA scrip corruption. I have an Access97 application which will be moved to a PC running XP.

I have an OTC 850XL printer, used for invoices, that I send a Crystal Report to. I have a driver which is v3.3. I believe I may need version 2.5 or a generic windows text print driver. Anyone know where I can download drivers like these? Thanks in advance for your help

I am having difficulty adding the dateadd function to a sql script "where" clause within an application. I want to include records that have neg qty within a 20day period. The original code is: sql = "Delete * From tblSales where date_shipped >= #" & LastUpdate &...

I have a procedure that is scheduled to run hourly and accesses production tables used by our order entry application. This procedure populates a table that is used by a crystal report (report runs hourly as well). I've run into blocking problems. I've tried to make the procedure as...

I have a report that's grouped by VP, Region, Item then Customer. So Customer is at the detail level. I'd like to add line numbers to count the customers for each item. I'd appreciate any help for this basic question. Thanks!

A stored procedure fails because the contents of a field exceed the maximum size. The error is: -2147217833 "Microsoft ODBC SQL Server Driver SQL Server Column 'upc_code' of table 'THWG.DBO.X_SHIP_LINE' cannot accept 16 bytes (15 max). Is there a SQL command that give one the ability to...

I have a summary table (created from a stored procedure) that's set up with fields for each day in the month - Day1Sales, Day2Sales, Day3Sales, Day1Goal, Day2Goal, Day3Goal, Day1Var, Day2Var, Day3Var, etc. Some days, the fields will be 0 since actual process days are Tues thru Fri (except...

I have several reports that are grouped to 4 levels. I would like to add line numbers for each line of detail within a group. I'm not sure how to do this. Anyone have an idea how to do this?

We have a server that get's stuck with Dr Watson opening up window after window. Anyone know of a way that we can boot this server in safe mode (not the utility?

Hope someone can help. I'm unable to start the APS Service on my Seagate Info Server. I'm receiving Database Exception Error 26358168. Reference is made to the ODBC Microsoft Access 97 Driver. Any help is appreciated. Thanks

Whenever I schedule a report from SI Desktop I receive an error: PEOpenPrintJob(\\pathname) : File I/O error. I've tried directing the report output to 1)SI/Output on the APS Server; 2)Webserver and I still get this error. Crystal tries to process this file (a new file is opened) but it fails...