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 strongm 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: reportingbuzz
  • Order by date
  1. reportingbuzz

    How to submit the form elements within an IFrame

    This was just one control. If there are many HTML elements within the control, form would end up having a lot of hidden elements. Thanks for the input.
  2. reportingbuzz

    How to submit the form elements within an IFrame

    Any ideas? Thanks.
  3. reportingbuzz

    How to submit the form elements within an IFrame

    Hi, I have a page with 2 IFrames and a single submit button at the main page: IFrame.asp <html> <head> <title>IFrame</title> </head> <body> <form action="formresults.asp"> <iframe name="iFrame1" id="iFrame1" src="iframe1.html"> </iframe> <iframe name="iFrame2" id="iFrame2"...
  4. reportingbuzz

    Blank screen at the web browser

    I worked with user and apparently, there were 2 reasons why he was viewing a grey blank screen. * He had an older Crystal Viewer Object in his IE(6.0). I made him delete it and re-install the Crystal Viewer Object. * Secondly, he was being prompted with the Authentication Box because in his...
  5. reportingbuzz

    Blank screen at the web browser

    Hi, I use Crystal Reports 8.5 and have integrated it with Classic ASP I call the Crystal Reports through client side VBScript. While testing it, all were able to view the reports. But one person came back saying that he saw a grey blank screen in the Crystal Viewer. I am using ActiveX viewer...
  6. reportingbuzz

    Site Map Question

    Hi, How does one go about creating a site-map for a web site that does not have one? If the site is really big - 50 to 100 pages of ASP pages, then how does one do it? Does one go through all the sites ASP pages and then add accordingly to the sitemap.asp or sitemap.html Any guidelines, any...
  7. reportingbuzz

    Multi-column List Box

    Hi, This small example uses Northwind database to show the 2 sets of data in the select box - CategoryID, CategoryName. <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 TRANSITIONAL//EN" "HTTP://W3.ORG/TR/HTML4/LOOSE.DTD"> <HTML> <HEAD> <SCRIPT> </SCRIPT> </HEAD> <TITLE>Multi-column...
  8. reportingbuzz

    How to loop through a specified range?

    Thanks for that tip. It worked.
  9. reportingbuzz

    How to loop through a specified range?

    Thanks for your responses. I got it working through a UDF. However, I noticed that if the Plan Name in the Plan_mapping sheet has an extra white space after the Plan Name, it would definitely not find a match in the PlanUIs sheet in order to get that UniqueIdentifier. So I get a blank row. So...
  10. reportingbuzz

    How to count of non-Empty cells in Excel VBA?

    Now I get the appropiate number of rows as the number of components by nesting it within 2 for loops. But any idea about doing away with the hard-coding as in the previous post? Thanks.
  11. reportingbuzz

    How to count of non-Empty cells in Excel VBA?

    In the line: If Not IsEmpty(varComponent) Then Count = Count + 1 'MsgBox (Count & ": " & varComponent) With Worksheets("Plan_PlanComponent_Link") 'Enter the values at the given row and column...
  12. reportingbuzz

    How to count of non-Empty cells in Excel VBA?

    Never mind. I added another For Loop and moved the lngRow+1 to outside of both the for loops: If Not IsEmpty(varComponent) Then Count = Count + 1 MsgBox (Count & ": " & varComponent) With Worksheets("Plan_PlanComponent_Link")...
  13. reportingbuzz

    How to count of non-Empty cells in Excel VBA?

    That was good suggestion. It showed how to use a return value within a function. However I see the following. Plan_UniqueIdentifier PlanComponent_UniqueIdentifier 3004661 46387 3004661 46387 3004661 46387 3004661 46379...
  14. reportingbuzz

    How to count of non-Empty cells in Excel VBA?

    Hi, Since I want to simultaneously insert two columns of a same row at a time, I added two insert lines within the code. Instead of assigning a variable to the value of the cell, I assigned it to a function. Function returns the value to insert into the cell whether it is for Column1(A) or...
  15. reportingbuzz

    How to count of non-Empty cells in Excel VBA?

    I call the function within this code: If Not IsEmpty(varComponent) Then Count = Count + 1 MsgBox (Count & ": " & varComponent) getPlanUI (varPlan) getPlanComponentUI (varComponent) End If This is the function that...
  16. reportingbuzz

    How to count of non-Empty cells in Excel VBA?

    Thanks for the tip. Yes. Count was placed in the wrong position. And it should start from 0. Based on this count, can we insert the 'count' number of rows into another sheet with the value 'varComponent'? Thanks.
  17. reportingbuzz

    How to count of non-Empty cells in Excel VBA?

    Hi, While looping through a column from 2 to 12, I want to see those cells which has some value, and do a count of those cells which has the value. How can I do that? Thanks. With wSht For iRow = 2 To 105 'grab the value of the 'AiRow' 'varPlan = .Cells(iRow, 1).Value...
  18. reportingbuzz

    How to loop through a specified range?

    I am really getting confused how to accomplish this: 1st sheet: Plan_Mapping A B C Plan Bookings RS Bonus AllRevenue Channel Manager Bookings RS Bonus AllRevenue Dir, Channel Sales Bookings RS Bonus AllRevenue Account Executive...
  19. reportingbuzz

    How to loop through a specified range?

    Yeah it is the column index. I got that. Thanks for the tip.
  20. reportingbuzz

    How to loop through a specified range?

    In this code: .Cells(iRow, 2) what does the 2 mean? Does it refer to a 2 dimensional array or does it refer to the 2nd column of the array? Thanks.

Part and Inventory Search

Back
Top