Search results for query: *

Hi I have a range in an excel sheet. The row is always of a single column, but multiple rows How can I get all the elements of the Range into a Collection The Range can be continous like Range("A1:A15").Select or it can be discontinous like Range("A1,A5,A10,A14,A17").Select How can I...

Hi I have an excel sheet where in the user enters SSNs in the first row of the sheet But in case the user types in some value and presses Escape button , the user jumps out of that cell and leaves that particular cell blank, but i need some mechanism by which I can still record that event...

Hi I had defined a name called "Name1 " which refers to A1 : A500 in worksheet1 This is the code I am using Dim str as string str = "Name1" Dim Range1 as Range Range1 = Worksheets("sheet1").Range(str) msgbox Range1.name I expected to get Name1 as the result Rather it is giving me a...

Hi I have an excel sheet which has monthwise expenses each month expense is in one separate row. How do I calculate the running totals of those values in the adjacent columns Please suggest thanks

Hi Could some one please suggest me a way how to connect an Excel sheet to SQL Server database I wish to fetch the rows from Employee table into excel sheet I need to connect to Employee table in "Pubs" database. user id "sa" password "" I would like to connect using the concept of ADO. Can I...

Hi I am using Excel 2000 I have a workbook which contains multiple worksheets Each worksheet has only one column ie Column A (SSN ID). This Column is to maintain all the SSNs of the employees. All the columns A in all worksheets are only for SSN Normally all SSNs are supposed to be unique...

Hi I am new to Crystal reports . I am using Crystal reports 9. I have a report report1.rpt in C:\Data folder How can I call or execute this report from Visual Basic 6? Could some one suggest me the method or code for this thanks

I am using Access 2003 I have certain forms where I need to place text boxes to handle data with baout 2000 - 3000 characters long Ideally, in a Access 2000 environment , I would be using a Rich text box to handle this issue, but in Access 2003 I cannot use a Rich text box The general text...

I have Access 2003 loaded on my machine I have an application on a different machine which is in Access 2000 I have to compulsorily load that application in Access 2000 only as many of the components inside that application are not recognized by Access 2003 I need to view that Access...

Hi I am using Access 2000 I have a rich text box in my application with name ActiveX100 This rich text box displays large data and is working fine in the Access 2000 environment Now, if I try to open this Access 2000 in the Access 2003 environment I am getting a lot of errors I get an error...

Hi I usally open a csv into Excel and start working on it. The usually I get abut 20000 - 30000 rows in the CSV file and this works fine But I get error when I have flat CSV file over 65536 rows and I get an error that the file is not loaded completely Is there a way , I can open up the flat...

Hi I am using Access 2000 I have about 8 forms in my application I would like to make an executible for my Access forms so that I can demonstrate only the executible file(instead of forms with code) to my clients Normally in Visual Basic , I would use a Make File for this purpose.. I would...

Hi I am using Access 2000 I have an option Frame with two option buttons "Male" and "Female" When the option button "Male" is clicked "Procedure A" has to be invoked and if option Button "Female" is clicked "Procedure B" has to be invoked But unlike Visual Basic Applications , I do not see...

Hi I am using Access 2000 I have an employee table with empno , deptno, empname , designation fields The designation is like manager , clerk, officer etc For any dept no .. there can be only one employee whose designation is 'MANAGER' However there can be any number of 'OFFICER' or 'CLERK' in...

Hi I am using Access 2000 I have a text box in my access form . It has a default value of " SINGLE USE". I have set the control source property of the text box to " SINGLE USE". Now, in the run time I can view the default data as " SINGLE USE". But I am not able to modify this text to any...

Hi I am using Access 2000 I am using an Option group where I have 2 option buttons opt_male and opt_female In a command_click event , I wrote the following code If opt_male is checked to true It should give a message box "You checked male option" if opt_female is checked to true it should...

Hi I am using Access 2000 I am creating an Access Form In the form , I have a text box(unbound) and an RichText Box Control(ActiveX control) . The text is display State Name and the ActiveX is to give the State description In the Form design, I gave text to the Text Box and Rich Text box...

Hi I am using MS Access 2000 I need to place innumerable number of controls on my Access form (close to 1900 Controls) My form has only dimensions of 22" (ht) X 22"(wd) Hence I am not able to place all my controls on the forms Is there way I can expand my Access 2000 Forms and make them...

Hi I am using Excel 2000. I need to send excel file as an attachment to certain users using Microsoft Outlook I am using Application.Dialogs(xlDialogSendMail).Show method to send the excel file There is an email id " R_brown@ibm.com" which has to be sent as a default email id . This is...

Hi I am using Excel 2000 and I have written some macros inside my excel sheet I do not want the end user to see my code or have any access to any of the macro VBA code that I had written How could I have security for my code This is what I have I done In the Visual Basic Editor , I clicked...