Recent content by Dutt

Thanks Man...works like a charm!

I'm trying to find out which tables in my DB don't have an index. Is there a select statment I can run that will give me a list of tables without indexes? Cheers

I get the error when I try both examples: Arithmetic overflow error converting numeric to data type numeric. The statement has been terminated. Is there a way to do it in a Update Statement? Cheers, Justin

I have a table called table1. It has a column called column1 and the datatype is numberic. Each record in that column has a trailing ".00000". I'm trying to build an update statment that will trim off the .00000. Any help would be great! Justin

Hello, In CR 8.5 I compiled a report to make a .exe and .crf file. The report itself is landscape, so when I execute the exe and print to a windows the report doesn't show up in landscape. Is there a setting that controls this? Thanks

Thanks Jeff I'll give it a try!

Hello, I'm having some trouble trying to get a Word 2000 mail merge to automatically insert the data from it's data source(TAB-Text file)when the file is opened. I know you can do it in VBA, but I was wondering if there is a way to do it in the mail merge wizard that I missed. Thanks for the...

I am trying to set up a mail merge document that when I open the word doc it will automatically do the mail merge in that particular file not open another. The merge would get the data from an outside ODBC text file. Anyone know how to set this up? Thanks Dutt

I'm trying to find the sum of a formula I have created in CR 8.5. I'm getting an Error message: The summary/running total field could not be created. code: sum(@formulaName) @formulaName = abs(@Def) @Def = field - field If you can help it would be greatly appreciated! Thanks

Hello, I'm starting the documentation part of my program at the present time and am having a little bit of trouble trying to Print screen the form. How do you Print screen JUST the form and not the whole desktop??? Thanks

Try this you might need to modify it a bit Dim xlApp As Object ' Declare variable to hold the reference. Dim xlbk As Workbook 'Declare Excel Workbook and worksheet Dim xlsht As Worksheet Dim mydb As Database Dim myrec As Recordset Dim x As Integer Dim MySQL As String...

Thanks a bunch! I didn't see it at all. Now that you point it out it makes perfect sense. I have only been programming for less then 6 months, thanks for taking the time to help!!!!!

For some reason when I execute the code and the Date is 20 Aug 00 and 30 Aug 00 its goes into the loop but if its 20 Aug 01 and 30 Aug 01 its doesn't. Can you see anything wrong with my code, I've been looking and can't spot anything. Can you see anything? Dim xlApp As Object ' Declare...

For some reason when I execute the code and the Date is 20 Aug 00 and 30 Aug 00 its goes into the loop but if its 20 Aug 01 and 30 Aug 01 its doesn't. Can you see anything wrong with my code, I've been looking and can't spot anything. Can you see anything? Dim xlApp As Object ' Declare...

Thank you very much for the help!! Everything worked out great! Dutt