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: *

  1. johnaregan

    How to use SqlCommand Bound Parameters

    ok thanks ca8msm
  2. johnaregan

    How to use SqlCommand Bound Parameters

    Hi I am trying to insert into Northwind using bound paramters, the command returns the SQL Server error: Line 1: Incorrect syntax near '?'. Can anybody see what it is that I am doing wrong? I have seen similar code on the web. ... comm.CommandType = CommandType.Text; comm.CommandText =...
  3. johnaregan

    Problem tabbing field focus with SmartNavigation and AutoPostBack

    This relates to a problem I came across when using the tab key to move the focus around a page of text boxes. All textboxes have AutoPostBack set to true and the page also has SmartNavigation switched on. When you change a value in a text box and tab out, the page is posted back as expected. A...
  4. johnaregan

    Bulk Insert into Datagrid

    Hi I do not know if this is at all possible but I would like to be able to copy rows from say an excel spreadsheet and insert them into a datagrid. The datagrid will then be submitted to bulk update a SQL Server table. Any pointers in the right direction would be greatly appreciated John
  5. johnaregan

    Get Contacts in mailboxes using LDAP?

    Zac thanks for link, this seems be the way to go John
  6. johnaregan

    Get Contacts in mailboxes using LDAP?

    zcolton, thanks for your reply I take it that LDAP only applies to Active Directory? ie. you cannot use it on Exchange Server to get at emails, Contacts etc. What I have is about 20 end users who keep their contact (other company's addresses, emails, telephone numbers) in their own personal...
  7. johnaregan

    Get Contacts in mailboxes using LDAP?

    zcolton We are using Windows 2000 server and Exchange 2000. John
  8. johnaregan

    Get Contacts in mailboxes using LDAP?

    Hi Can you get to the Contacts folder in end users mailboxes (stored in Exchange Server, not local PC's) using LDAP. If so can anyone give me any pointers as to how to do this. thanks in advance John
  9. johnaregan

    Export mailbox contacts to delimited file

    Hi Does anyone know how I can go through each Contacts folder in every Mailbox on the Exchange Server and export the contacts to one delimited file (I have administrator access). All of our mailboxes are stored on the Exchange server (ie. we do not use .pst files). I have read about command...
  10. johnaregan

    Open new web browser from excel hyperlink

    I've tried doing this but it does not work, it still opens the page in the same window as the excel document. John
  11. johnaregan

    Open new web browser from excel hyperlink

    Hi I am sending the output of an asp page to Excel using Response.ContentType = "application/vnd.ms-excel" so that the web page loads and displays as Excel in a browser. I have hyperlinks on the page which I want to use to open a new separate web browser. At the moment the link loads the next...
  12. johnaregan

    Deploying applications without .NET?

    Hi Do you need to have the .NET framework installed on the PC that you are deploying to? I know that apps are compiled to byte code, but it seems silly if you also need to install .NET on all machines that you may be deploying to; if you compiled a program in C (not through .NET) then you dont...
  13. johnaregan

    Extract numeric data from text/numeric column

    Hi I have a varchar column holding numeric and text data. How would I be able to just extract the numeric data from this column? Thanks in advance John
  14. johnaregan

    Find all records within current week?

    saved me some work and thinking, have another star
  15. johnaregan

    xsl inside <a> tag

    pete the xsl in the message worked perfectly and it was the solution that I wanted. I was just refering to the search in tek-tips not returning anything, once again thanks for the link
  16. johnaregan

    Test if unititiated array holds any values

    Hi I have an array declared as Dim ar() as String This is set by a return from another function: ar = ReturnArrayFunction How so I test it the ar array has been returned any values? Thanks John
  17. johnaregan

    xsl inside <a> tag

    tried that chum... but it didnt return anything, thanks for the link tho
  18. johnaregan

    xsl inside <a> tag

    Hi I'm writing a menu using xml/xsl. I have an xml like: ... <item> <itemtext>LinkTo</itemtext> <itemaction>http://somewhere</itemaction> </item> ... where itemaction is a link. I want xsl output like <a href=&quot;http://somewhere&quot;>LinkTo</a> My question is how do I write the xsl so...
  19. johnaregan

    Embed word into outlook form

    Hi How do I go about using a word document template as an Outlook form? I am designing a form for that will be used by an end user to request a change in our system. I want to be able to create a Word template that will have a standard set of questions for the user to fill in. This template...
  20. johnaregan

    Set event in another spreadsheet

    Hi I have 2 spreadsheets, one primary and another secondary. What I want to do is write VBA code in the primary spreadsheet that will set an event in the secondary one. The event will call a method in the primary spreadsheet. I have read a little about WithEvent, am I on the right track? Help...

Part and Inventory Search

Back
Top