Search results for query: *

Hello, We have two identical Hp855CSE printers that do not get much use these days (on the color side). Recently when we did try printing with them, we noticed that neither prints anything with red in it. We figured it was the cartridge, so we replaced it with one in our cabinet. Same...

Hi, I am not sure (as I don't have a printer hooked up to our test box that we are testing DOS COBOL under XP with) but when I tell it to "print" a file, it seems happy enough, and says that it is printing. This is much nicer than Windows 98 and on when Print command was abandoned...

Marc Lodge hit the nails on the head. ITs mainframe code. The block 0 records means that Job Control (JCL) will dictate the size of the block, external to the program. Otherwise if you put a value in there, it would put that many records into a data block, and depending on which disk drives...

Hello. We are looking to move our Access 97 tables to SQL Server 2000 and wondered if anyone has done this successfully and if there are things we should do and not do to make this work easier for us. We want to keep our reporting functions on Access 97, pointing to the new SQL tables. Would...

Hello. We are looking to move our Access 97 tables to SQL Server 2000 and wondered if anyone has done this successfully and if there are things we should do and not do to make this work easier for us. We want to keep our reporting functions on Access 97, pointing to the new SQL tables. Would...

Ben, I had tried that already.. no luck.. I also tried the DistinctRow.. same results.... Tons of duplicate detail line entries.. Steve

Hello, I inherited a complex Access 97 report that generates a report and distributes it to the requestor via email. Its complexity lies in its many inner joins tieing over a half dozen tables together to produce the report. The requestor's id is tied to their company, and this report...

Greg, I will have to investigate that. Seems there is a lot for this old mainframer to pickup to play with these two platforms simultaneously. Thanks, Steve

Steve, Thanks for the clarification. I have never seen anyone stick a V at the end of a picture clause like that. It threw me. Take care, Steve

Crox, That would be great. I could export the tables to dbf format easily and would be interested in trying out those routines against the dbf formats. I'd appreciate if you could email them to me.. my email is Steve@miscs.biz Thanks a lot, Steve

Hey guys, maybe I am bit rusty, but wouldnt the pic 9(13) data need to be moved to a s9(13) comp-3 if he wanted it to remain the same; but packed? If he wanted two decimal places before in the receiving field, wouldn't he want it to be s9(11)v99. If he wanted a real decimal place would he...

Does anyone know how I can possibly read our Access database's tables in COBOL? I would like to be able to process them as I would COBOL to assist us in a migration we are making to a new platform. If I could output files that could be read and imported into SQL Server, all the better...

Mapman, Thanks. I will note that for the future. Steve

Essa and Garwain, Thank you. Essa, I tried to find my former thread as I was not sure where I put my original email .. but was not sure how to. I ended up searching on a keyword which brought up millions (slight exaggeration) of entries. How do I find previous threads in a given forum...

Is there an easy way to get a printable copy of all of the SQL tables in our SQL Server 2000 database system? We are looking at converting several tables from Access to SQL Server and while I found a great freeware utility for ACCESS (EzDocumentor) I have nothing for the SQL Server side. I...

Rick, But if we wrote a function like you describe, would be be able to access it in another function? Its this email building function that we are working with that is encountering the problem with the spaces embedded in the "report name" field. Would we somehow run the one...

Hi. Is there an easy way to remove spaces (or special characters) from a string? I noticed that the trim commands are geared towards only removing leading and trailing spaces. I have a file name being passed to me that contains a colon and also some spaces that acrobat does not...

We are trying to access the Values of a table we are processing in a VB script. The application is to build an access report that we can email... and where are stuck is accessing the contents of fields on the table. For example, one field on one table contains the name of the report we want...

Does anyone know an easy way or product that can print the structure for our SQL 2000 tables (that is - field names, field types, lengths of fields?). We are looking to have our present Access database system "talk with" a new package we bought that runs on SQL Server 2000 and would...

I noticed one (maybe two) odd thing(s) in the Relationship reports. In older printouts the "names" beneath "Relationships" on the Relationship Reports (from Analyze, Document)... were a series of numbers (like a registry key). Lately they are in English. Secondly, I...