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

    Breadcrumbs issue

    Hi all, I'm having a weird issue with my breadcrumbs. When I use the server name on the URL e.g. http://servename/default.aspx, the breadcrumbs work fine. However, when I use the actual name of the portal e.g. http://myportal/default.aspx, my breadcrumbs only work for certain pages and don't...
  2. arbo80

    Drop Down menus work in IE 7 and Firefox but don't work in IE 6

    Hi, I'm using Javascript and CSS to create some drop down menus for a site. Everything works fine in IE7+ but it doesn't work in IE6. Some of the site's users still use IE6. Any suggestion on how to fix that issue? Below is my HTML, css and JavaScript code: HTML ---- <ul id="menu"> <li><a...
  3. arbo80

    Global Navigation

    Hi all, I’m trying to open the Navigation panel from SharePoint Designer 2007 to modify my global navigation (Site -> Navigation) but I’m getting the following error message: “the navigation view cannot be displayed for this web site” although I have owner permissions to the website. In...
  4. arbo80

    import the data across multiple sheets when more than 256 columns

    Skip, My code is working fine when the number of columns is less than 256. The problem is the limits on the number of columns in Excel 2003. I just want to be able to copy the extra columns (255+) to a new sheet. Below is where the code fails: While Not rsDesk.EOF...
  5. arbo80

    import the data across multiple sheets when more than 256 columns

    Hi Skip, Below are my answers: 1. We are importing the data from MS Access to create an Excel report for the legal team. 2. The legal group wants to see the data in a specific format which is why the columns have to be in that manner. Like I said above, everything is fine if they use Excel...
  6. arbo80

    import the data across multiple sheets when more than 256 columns

    Hi all, I have posted here before and most of the time, I have gotten the help that I needed. We have the following macro that creates a report. The macro: 1) Open a template (Excel file) and copy the same (4) columns from one sheet named “Sheet 1” to another one named “Table 1” multiple times...
  7. arbo80

    Run-time error 1004 &quot;The information cannot be pasted because the copy

    Hi Skip, I finally identified the issue. My macro is trying to return 274 columns while Excel 2003's limit is 256 Columns. To fix this issue, I must use Excel 2007. Thanks for your help. I really do appreciate the time and effort. B.
  8. arbo80

    Run-time error 1004 &quot;The information cannot be pasted because the copy

    Hi, The macro also extracts data from an Access DB and copy the data to an excel file. The problem is that there are 69 distinct records (strSQL = "SELECT DISTINCT Summit.Desk FROM Summit"); but the macro only copies 63 (instead of 69) and then it returns the error message above. Any...
  9. arbo80

    Run-time error 1004 &quot;The information cannot be pasted because the copy

    The macro is collecting feeds from some systems. The extracts are file-based and the macro reads the files, parses them and collects statistics about modifications made to trades in these systems. To summarize, it pretty much copies data and pastes it to a template. Apparently, the macro used...
  10. arbo80

    Run-time error 1004 &quot;The information cannot be pasted because the copy

    Thanks Skip! This VBA macro was actually created by someone who no longer works for my company. I have some basic knowledge but I'm not really an expert on VBA; I'm just trying to find a way to make it work.
  11. arbo80

    Run-time error 1004 &quot;The information cannot be pasted because the copy

    Hi all, I have a VBA macro which had been working fine until recently. Now I'm getting the following error message: "Run time error 1004: "The information cannot be pasted because the copy area and paste area are not the same size or shape...". Can you help me? Below is my code: Sub...
  12. arbo80

    Active directory in ASP.net

    Thanks! I will try your suggestions.
  13. arbo80

    Active directory in ASP.net

    I forgot this line at the top: string principal = this.Context.User.Identity.Name;
  14. arbo80

    Active directory in ASP.net

    Hi all, I have the following code to read user information (email address) from Active Directory in ASP.net. However, I'm getting this error message: System.Runtime.InteropServices.COMException: The server is not operational. Has anybody gotten the same error? I need your help. string filter =...
  15. arbo80

    Sending Email in ASP.NET

    Thanks for your feedback. The application that I created is a web form. Every time a user submits the form, the application will send an email to my manager. Thus, the "Mail From" should be the email address of the user.
  16. arbo80

    Sending Email in ASP.NET

    Hi all, I have the following code to send an email from a web interface and it works fine. However, I want to know if it's possible to replace the email address specified in "Mail.From" by the default client email address. If yes, how do I do that? SmtpMail.SmtpServer = "localhost"...
  17. arbo80

    Highlight a column when first row is equal to &quot;1&quot;

    Thanks! It works fine now!
  18. arbo80

    Highlight a column when first row is equal to &quot;1&quot;

    Thanks guys for your help! but how do I make sure that it highlights the entire column instead of just the cell?
  19. arbo80

    Highlight a column when first row is equal to &quot;1&quot;

    Hi all, I would like to create a macro that highlights multiple columns in Excel when the first row of the column is equal to "1". I was able to find the solution for one column but I would like to do the same for 50 or more columns and I don't want to copy and paste my code. Is there any...
  20. arbo80

    Run-time error 91 object variable or with block variable not set

    Thanks guys!!

Part and Inventory Search

Back
Top