Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: barnard89
  • Order by date
  1. barnard89

    Get the total items in a Range

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

    Get the total items in a Range

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

    Get the total items in a Range

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

    Capture Excel cell change event

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

    How Do I get the name of a NameRange

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

    Calculate running totals in an Excel sheet

    anotherhiggins thanks a lot for your reply it works
  7. barnard89

    Calculate running totals in an Excel sheet

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

    Connect Excel sheet to Database

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

    Compare two Worksheets

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

    Call a Crystal report from Visual Basic 6

    synapsevampire Thanks a lot for your valuable post
  11. barnard89

    Call a Crystal report from Visual Basic 6

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

    Handling large text in MS Access 2003

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

    Can Access 2003 and Access 2000 be loaded on the same machine?

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

    Migration problems with Access 2003

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

    Migration problems with Access 2003

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

    Migration problems with Access 2003

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

    Open a flat file with more than 65536 rows in Excel

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

    Create Executible for MS Access Application

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

    Option button click even

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

    Table should not be edited

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

Part and Inventory Search

Back
Top