Search results for query: *

Hi All, I need to create a new excel workbook from an existing workbook keeping the column structure intact as the existing one using a macro. i open the existing worksheet using Workbook.open command, then i save it using a different name using command workbook.saveas. but in this case the...

Hi All, I need to send a mail from Word document using a macro. The mail will contain some message and additional the document itself will have to be sent as attachment. I need to send mail to different persons seperately. Say Email1 to person A, Email2 to person2 etc.. The content of the...

Hi All, I need to send a mail from Word document using a macro. The mail will contain some message and additional the document itself will have to be sent as attachment. I need to send mail to different persons seperately. Say Email1 to person A, Email2 to person2 etc.. The content of the...

Hi All, I am using parameter field in my Report which is defined to be of String datatype.The report is created in ver 9.0 from my VB code iam pasing value which can be 4000 charc long. But the progran crashes. is there any way i can overcome this limitation. is this limitation of string...

Hi All, Iam using Crystal Reports ver 8.0, for reporting purposes. I had been using Crystal Reports Active X control in my VB form for displaying the report. But recently i have upgraded to ver 9.0. Problem is Active X control is no longer there. Has it been removed in ver 9.0. I needed...

Hi, Iam using Crystal Report Active X Control for displaying my report. Within VB iam trying to connect to a new database. But it is unable to do so giving error "Cannot Open SQL Server Error No :20599" Hope somebody can help me. Thanx Natesh Code : With crxReport...

Hi All, Iam using CrystalReportViewer to display my report. The ReportSource value is assigned during click of a button. Also iam changing the database at runtime. for the first click of the button it works properly. but for the second click it gives "Out of Memory". Its logging...

Hi, I have created a custom menu and menu item with in it to call a macro. The Custom menu appears on the top of the sheet along with File,Edit... menu options. But after i close the sheet and later open it , the custome menu is no longer there. Can anyone help me on it ? Thanx a ton Natesh

Hi All, I need to send a mail from Word document using a macro. The mail will contain some message and additional the document itself will have to be sent as attachment. Any Help ????? Thanx in advance Natesh

Hi , Iam using Access forms to display/edit and enter data. I wish to provide filter functionality ie; for displaying say the 5th record i have to use the data control to navigate thru the earlier 4 records, which is not appropriate. I would like to display the 5th record directly depending on...

Hi, Iam have got pivot tables in my excel application. The data for the pivot table is an another excel sheet in a different workbook.i have selected "Refresh on open" option. But whenever i open my workbbok it says "Cannot open xyz.xls" But if i open the second data...

Hi, I have some pivot tables in my excel sheet which is based on external Excel sheets. When the external sheets are moved iam not able to refresh my pivot tables. Is it possible to give the data source of the pivot tables at run time. Help will be greatly appreciated. Thanx and Regards...

Hi, I tried installing MDAC 2.6 on an Arabic enabled P.C running Win 95. But when i checked in references in MS Access code window i wasnt able to view the reference. The "Win 95/system" directory is named as "Win 95 A/system " Can this be the root of the problem. Thanx...

Hi , Can i launch my Access Report thru VB . Also can I pass it parameters from Vb . ie ; I have created a query using a where clause and the report is based on the query. "select * from emp where empno= par1" how do i pass value to par1 before launching the report ? Thanx in...

Hi , I need Arabic text to be printed on my Crystal Report. I tried using a text control and typing in the content. But instead of the format being right to left , it is left to right . Even alignment does not help . Hope somebody can help me out. Thanx in advance. Natesh

Hi , Iam using Crystal Reports as a reporting tool in my application. I want only 10 records appearing on a page ie; after 10 records the 11th record should be printed on a new page. Hope some of u can help me out. Thanx in advance. Natesh

Hi ! I have created a name for a range of cells in my worksheet. Is it possible for me to access an individual cell in this name ? Thanx in advance

Hi , Iam using VBA in Excel. In one of the sheets there is a formula used in a cell which is as shown below : ='C:\Natesh\Projects\CRMS\Risk\Existing\[VAR Positions.xls]58'!$IB$87 and also another cell formula which goes as ='C:\Natesh\Projects\CRMS\Risk\Existing\[VAR...

Hi , Iam using Crystal Reports 7.0 for reporting purpose in my application.There is a problem in the sense that on the client side not all P.C's will be having Crystal Reports due to licensing concern. So i will not be able to use the Crrystal Reports ocx. How do i overcome it ? Thanx in...

Hi , When do I use an ini file. what r the advantages/disadvantages of using ini files ? How is ini file different from ordinary text file ? Thanx in advance Natesh