Search results for query: *

I know this is a bit old, but in case anyone else has the same problem there is a suggestion here:- http://www.coolsolutions.com/viewtopic.php?t=7082 I can't vouch for this myself, and I can't imagine Novell will support it in any way, but it might be worth a try. Personally I'd recommend...

Hi hilfy, thanks for the reply. I tried connecting to the database using an ADO connection, but unfortunatly I got the same result. Any other advice from anyone? Cheers James

Hi All, I'm reposting this in here, because I don't think I put it in the right place to begin with. Db - SQL 2005 Crystal XI (11.0.0.1282) Developer edition Connecting via an ODBC connection using the SQL native driver. I have a BLOB field in my database containing a bmp image. When I try...

Hi All, Db - SQL 2005 Crystal XI (11.0.0.1282) Developer edition Connecting via an ODBC connection using the SQL native driver. I have a BLOB field in my database containing a bmp image. When I try to insert this into a crystal report it shows as a blank field (i.e. does not show the image)...

Hi HMallett, Thanks for the response. Yes the tapes are 200/400 LTO2 tapes. When I look at the media properties in backup exec it shows the current capacity as 200GB. Regards James

Hi all, I'm having a problem with an Ultrium tape drive. I'm running Backup Exec for Netware, version 9.20. Our Ultrium tapes are supposed to have a native capacity of 200GB, but when our nightly backups are running once the tape gets to 145 - 150GB full it stops the job and ejects the tape...

Thanks Synapse. I've actually solved the problem using the Val() function, which I wasn't previously aware of. This converts a string to a number removing any non numeric characters. I then convert it back to text and add the 0 back on (it's removed on conversion to a number). This section...

I'm trying to pick up a mobile number from a database, but the data is rather messy. A lot of the number's have hash characters (#) at the end, and a lot also have a description of the number. I have worked around the first bit, but the text is causing me problems. This is my formula:-...

Thank you all for your help. The Worksheets.Select suggestion from Loomah is perfect, so I'll be using that. Thanks again to everyone! James.

Hi all. Thanks for all the help. I'm using a macro to format reports for clients. All the reports are exported and burst from crystal using Visual Cut. The sheets in the workbook are title with client codes that are a unique list of up to 9 codes for each client. I need the macro to...

Hi all, I am trying to find a way to select multiple sheets within a workbook as part of a macro. The sheet names and the number of sheets are variable. I can do it like this:- Sheets(Array("Sheet3", "Sheet2", "Sheet1")).Select except that the sheets could have different names each time I...

Hi there, One of my users is having real trouble with outlook. Our network went down this morning causing all the PC's to crash. This one user had outlook open and when he restarted it won't open his .pst file. The .pst is stored on a shared drive on the server, and when he opens outlook he...

CR 10 is not compatible with windows 9x at all. We are just about to upgrade, but stil have some PCs on Windows 98. We are getting version 9, which is still available from the BO website, at the same price as Version 10.

Hi all, I have now solved this problem using a running total. Firstly I've added a group for the reference number. The running total resets at the start of each month (in the month group header), adds the Max value for the balance for each unique reference, and then prints the total in the...

Hi, Here is the sample data. This is what I'm getting:- payments received on accounts loaded in month 07 of 2002. (Section - Page header) Year New Cases No. New Cases Balance Payment (Section - Group 1 Year header) 2002 (Section - Group 2 Month header) 07 2 500.00...

I am using Crystal Reports version 4.6 (I know.) and connecting to an SQL database via ODBC. I am looking to group accounts into the month they where loaded and total the number and balance. I have an outer left join to a payments table so that if an account has received multiple payments in...