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!

  • Congratulations wOOdy-Soft 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: Ankor
  • Content: Threads
  • Order by date
  1. Ankor

    Select row in datagrid and pass a value

    I would like to be able to select a row in the datagrid without having a select button. Then, when I click "Edit" button on the form, one of the values from this row should be pulled into the querystring on another page created for editing. I understand I should somehow mimic...
  2. Ankor

    Adjust space size around datagrid borders

    I have a datagrid that is bigger than screen size, so I have vertical and horizontal scroll bars. My problem that the screen "eats" right and bottom datagrid borders. Is there any easy way to solve this problem?
  3. Ankor

    Add a footer with a link to the datagrid

    I'd like to add a footer to the datagrid, span all columns in it, and then add a link that would lead to the top of the page. Is it possible to do that? Thank you.
  4. Ankor

    Add attachment to the email

    Hi, Here is my question. I am in Excel workbook that contains a list of users with their e-mail addresses. In VBA code I am looping through the list and send a slightly different e-mail to each user. I also want to be able to attach a Word file to my e-mail messages, but SendMail method does...
  5. Ankor

    Script component or script task

    I am pulling data from the database (DB1) in the following format: DepartmentID DepartmentDesc AABB Sales AAAB Marketing ABAB Customer Service ext. Another database (DB2) has a table that also has DepartmentID and DepartmentDesc columns, but not...
  6. Ankor

    How do I program a dropdown so it would change the value

    I am looking for the code that would change the dropdown value while the user is typing what he needs. The usual dropdown will accept only the first character, but I have a long list of options where the first character is the same, so I'd like to be able to type two or three characters, and...
  7. Ankor

    Delete data from the table before loading

    What transformation task should be used to delete data from the table before loading. I tried OLEDB Command, but it requires input columns. What input should I provide for the delete command? I attempted to put this command between source and destination (looks really weird), but it works in one...
  8. Ankor

    Rowspan in datagrid

    Hello, I'd like to build a datagrid that will have the first and second columns rowspaned. The quantity of rows in rowspan is fixed. There should be three of them. Could anyone point me to the source where I could get an idea how it can be done? Thank you.
  9. Ankor

    Request.ServerVariables("LOGON_USER") does not return a value

    What can be an issue when Request.ServerVariables("LOGON_USER") does not return a value? I am running this on my web page, and get an empty string.
  10. Ankor

    Clear Clipboard

    I need to clear clipboard from Excel 2003 SP1 VBA. I found couple codes that should do it, but none of them work for me. This code returns an error message "User-defined type not defined": Public Sub ClearClipboard() Dim MyDataObj As New DataObject MyDataObj.SetText ""...
  11. Ankor

    Request.Cookies does not work

    I have a logon screen and main menu stored in the separate folder on dev server. When I login, I create a cookie for the user id to use it in the entire system, and I can read this cookie from the mainmenu. As soon as I click the link that should connect me to the system with the files stored...
  12. Ankor

    How to change the content in the drop-down menu

    I have two drop-down menus: one is for the department, and another one - for the associates in this department. I populated the first one from the database. Now I want the second drop down to be populated from the database depending on the value selected in the first drop-down. To execute the...
  13. Ankor

    How to populate drop-down from the stored procedure results

    Hello. I am very new to .NET programming, so my question is probably easy to answer. Or, maybe someone can direct me to the web source where I will be able to find the solution. Anyway, I need to populate a drop-down list with the results from the stored procedure. I was able to write a...
  14. Ankor

    Change career inside the company

    Hi. Here is a question. How do you change the career inside the company? I am an analyst/programmer in a non-technical department, and I am currently trying to move to an analyst position in the technical department. It’s a real problem! I like coding more than data analysis, but I like...
  15. Ankor

    How do I resolve an error 'Invalid @ Command directive'

    Here is an error message: Active Server Pages error 'ASP 0221' Invalid @ Command directive /PlanWeb/WebForm1.aspx, line 1 The specified 'Page Language="vb" AutoEventWireup="false" Codebehind="WebForm1.aspx.vb" Inherits="PlanWeb.WebForm1"' option is unknown or invalid. I tried to change the...
  16. Ankor

    What datatype can be used instead of varchar for local variables?

    This code runs: USE pubs DECLARE @s VARCHAR(50) SET @s = 'SELECT * FROM publishers' EXEC (@s) What if @s is greater than VARCHAR(8000)? If I replace VARCHAR with TEXT, I get an error message: "The text, ntext, and image data types are invalid for local variables".
  17. Ankor

    How to edit a password protected Word document

    I can open the document and read it, but it does not let me make changes. When I go to Tools/Unprotect, it asks for the password. Is there any way to recover the password without buying any additional software?
  18. Ankor

    How to create a scheduled task?

    Hello, I need to create a scheduled task on the server that would copy a file to another server. Is it possible to do that? Thank you.
  19. Ankor

    Retrieve server time for a particular server

    I would like to retrieve server time for a particular machine. I have several web servers in different time zones, but I want them all to lock the submit button on the front-end when my database server updates the records. I know how to do it in JavaScript, but the code will require the...
  20. Ankor

    Check for a character in the column

    Is there a way to check for the particular character in the column, and then put the first part of the word (before this character) to one place, and the second part (after this character) - to another?

Part and Inventory Search

Back
Top