Search results for query: *

Hi With reference to the same problem this is the code what I have written I am randomly selecting the items( in the same column) and naming them as a range ( Range_1) The items are the ones that I had selected ( ie Selection.address ) I need to place the row numbers of all the cells that...

Hi PHV Thanks for the reply Now my Range in real world runs into some 8000 - 9000 rows So I am not in a position to write a code like For Each c in Range("A1,A5,A10,A14,A17") Debug.Print c.Row Next Could you kindly suggest a modified method Thanks in advance

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...

anotherhiggins thanks a lot for your reply it works

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...

synapsevampire Thanks a lot for your valuable post

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...

Thanks How can I upgrade this activeX control? I am using a Rich text box as the ActiveX control

Herman What do you suggest would be the remedy to this? Thanks

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...