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 Wanet Telecoms Ltd 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. 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.
  16. lchase

    Start external program like notepad

    Thanks for the concise answer Omega36. very helpful Len
  17. lchase

    Start external program like notepad

    HI What is the best way to start a program from within vb6 Thanks Len
  18. lchase

    Excel import

    Hi I wish to import data from a basic excel file(list of names and addresses) to VB does anyone have an example or the url of one. Thanks Len
  19. lchase

    Create user and home dir on 2k

    Does anybody have a sample of creating a user and home directory using Iads(active directory)or script. Thanks Len
  20. lchase

    Is Visual Interdev on MSDN Universal DVD's?

    It's Part of Visual Studio Six with should be on the cd. Len

Part and Inventory Search

Back
Top