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 bkrike on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Recent content by lchase

  1. lchase

    Office Assistant-textbox

    I am working with the office assistant. I have plenty of examples using option buttons and checkboxes but I can't seem to find any using a textbox to get info from the user. Since that's what is done when the assistant pops up after pressing F1, I thought it would be possible to do the same...
  2. lchase

    send body as html using vba

    Hi I tried item.bodyformat= olformathtml item.body = &quot;<html>(etc )<body>Table tags etc</body></html>&quot; When I check the email it just prints out verbatim. Can anyone tell me the correct way Thanks Len
  3. lchase

    Sql and User Defined functions

    Hi I tried this and got a type mismatch error. Thanks Len CREATE FUNCTION fn_MyFunction ( @Dept_no VARCHAR(10) ) RETURNS INT AS BEGIN DECLARE @v_MyResult int Select @v_MyResult = Count(*) FROM employee Where dept_no = @Dept_no RETURN...
  4. lchase

    Sql and User Defined functions

    Thanks I will give it a try. Len
  5. lchase

    Sql and User Defined functions

    Hi, Anyone have an example of using a sql server 2000 user-defined function. I can't seem to find any and am not sure it is allowed. Can anyone shine some light on this. Thanks Len
  6. lchase

    VB6 Ado stored procedure retrieve output variable

    I found the problem. If you want to use a return value parameter. It must be the first added to the parameter collection. Thanks for the assistance
  7. lchase

    VB6 Ado stored procedure retrieve output variable

    John, here is what I tried are you saying I need to name the variable &quot;Return&quot; Thanks Len Set adoparam3 = New Parameter ' adoparam3.Name = &quot;@errorNum&quot; ' adoparam3.Type = adInteger ' adoparam3.Direction = adParamReturnValue ' adoCommand.Parameters.Append adoparam3
  8. lchase

    VB6 Ado stored procedure retrieve output variable

    When I tried that I got this error #3265 Item cannot be found in the collection Is it becausse it is a return value and not a parameter. When I tried to add it as a parameter It told me I had too many. Here is the ado code: Dim strOutput As String Dim strAnswer As String Dim intRtn As Integer...
  9. lchase

    VB6 Ado stored procedure retrieve output variable

    Thanks that solved one problem for me I was executing the command like Set adoRecordset = adoCommand.Execute When I dumped the recordset that part works. How about the return value of a stored procedure. I understand it must be integer and usually contains an error value returned from sql...
  10. lchase

    VB6 Ado stored procedure retrieve output variable

    Hi all, I am looking for a code snippet demonstrating retrieving a output variable and/or return value from a stored procedure. I have code to do it with in sql query analyizer but can't find any for vb 6 and ado using an output parameter. I already have plenty using recordsets. Thanks in...
  11. lchase

    Sending an email to Outlook in a specific folder

    Thanks But I need to automate the process. I wanted to use the outbox because you can set outlook to periodically send and recieve. I was trying to avoid the security problems and having to use the serenity email package. Any other thoughts. Len
  12. lchase

    Sending an email to Outlook in a specific folder

    Hi, I am trying to do something similiar. I am looping thru a list of emails to send(20-50)and I want to put them in the outbox and let send and recieve take care of it. I can't seem to find any code in the forum to do this instead of a send. Any help is appreciated. Len
  13. lchase

    Uploading files to a Web Server using FTP

    Hi , Can I also get a copy of the code Thanks Len
  14. lchase

    Submit and hyperlink

    I have a page that I must code so that when someone mouses over an image the cursor changes to a Hand and when they click it causes document.submit() to occur. Or any method allowing me to send user and password along with request for a serverside page either get or post would me great. I seem...
  15. lchase

    Start external program like notepad

    Thanks to everyone but John. I was going to get obnoxious but I just don't think it benefits anyone. John since you are so easily irritated feel free not to answer any of my posts.
See more

Part and Inventory Search

Back
Top