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. uberskunk

    EventInterop.MailMsg Alter Header

    Hi, I have a problem and I'm hoping someone can help. I'm trying to alter the subject field on emails by hooking onto the Exchange transport events. I need to do it this way as it seems to be the only way to do it Asynchronously. I need to handle the subject field on incoming and outgoing...
  2. uberskunk

    Custom Sinks Not Running

    and I've just run 'cscript smtpreg.vbs /enum' and my event sink is in the list. Looks good to me. Thanks
  3. uberskunk

    Custom Sinks Not Running

    Hi all, I have a problem in that I have written an event sink script in vbs which I have registered using the smtpreg.vbs file. Code I took from the msdn site, I have copied the exact code from msdn's samples, so I don't think my problem lies there. I've done a fair bit of research now, and...
  4. uberskunk

    View/Edit Every Users Appointments using ADO

    Hi, I'm trying to make an internet based calendar management app that can access any users calendar on exchange. I've got exchange 5.5 and outlook 2000. I'm trying to find any code that can be run server side to get the calendar contents of any user using ADO. Language of the code isn't an...
  5. uberskunk

    Remove orphaned roles from database

    Hi, Just wanted to say thanks to SQLBill, I restored a backup of a DB to a new server and left all the users and roles in. And your SP_REVOKEDBACCESS worked a treat to remove the old ones. FYI, I transfered the DB from the states and it took 5 hours, so this was an excellent time saver...
  6. uberskunk

    Preventing simultanaeous execution

    ...Lib "kernel32" ( _ ByVal hHandle As Long, _ ByVal dwMilliseconds As Long _ ) As Long ******************** And now the code for the execution of the command Private Function RunShellAsProcess(strShellCmd As String) As Integer...
  7. uberskunk

    Help!!!!

    Firstly is would like to appologise for my previous post. If your getting permission denied, when your trying to open a file for amending. Either the file or path is invalid ie the path could be D:\inetpub\websiteguestbook.txt or the file already exists and is readonly. This could be set not...
  8. uberskunk

    Help!!!!

    Hi, Line 54 and 55 read Set textFile = _ fileObject.OpenTextFile( guestbook, 8, True ) It should be fine if you change it to Set textFile = fileObject.OpenTextFile( guestbook, 8, True ) Let me know if you have any more problems, Mike
  9. uberskunk

    Finding all SQL servers on the network

    Hey NoCool, I've not used the SQL references before and I'm trying to understand the type of the variant values. Can you tell me how it manages to go into the recordset but I can't convert it using CStr() and put into a ListBox As once it is in the recordset I can mess about with it. And...
  10. uberskunk

    Secure Server Methods

    Thank you very much. That is very useful to know. Mike
  11. uberskunk

    Checking for a valid date

    This should do the trick, The function return False and True MsgBox IsDate(Text1.Text)
  12. uberskunk

    Secure Server Methods

    Hi, Can anyone give me a method of automatically redirecting my web intro page to a secure web page after a few seconds or on a 'skip intro' link. I have coded the following but I'm just not sure if it really works. I get the right output the web address contains the https but is that enough...
  13. uberskunk

    Lock/Unlock Worksheets

    This code was originally written for Word but I bet it would work in Excel. We also have 2 buttons on the menus that do this for you. Might make it easy for you. Sub ProtectForm() ActiveDocument.Protect Type:=wdAllowOnlyFormFields, NoReset:=True End Sub Sub UnProtectForm() On Error GoTo...
  14. uberskunk

    Number of Years, Months & Days from Start Date

    Hi, It's not quite a solution but it should help some. x = "01/02/1999" y = DateDiff("yyyy", x, Now()) m = DateDiff("m", x, Now()) d = DateDiff("d", x, Now()) I realise the code isn't a cell function but I was hoping you could use it anyway. I think...
  15. uberskunk

    Word 2k instance grouping on Win2k

    Right, So do you know of anyway I can group these together. So 10 open documents only have one startbar window? I find it hard to believe that they would make this change and not let you alter it.
  16. uberskunk

    Word 2k instance grouping on Win2k

    Hi, I have a problem that Word 2000 on Windows 2000 opens a new instance of word everytime a document is opened. Is there a way round this? So that all documents are opened in the first instance of word unless there are already 25 doc open, which is how it works in Word 97. I am using Word 2k...
  17. uberskunk

    Stored Procedure with parameters returns empty recordset

    I can't say exactly why yours isn't working as it seems a very logical way of running a store procedure but have you tried passing the parameters in the .commandtext? .CommandText = "spGroupProduction " & dtStartDate & ", " & dtEndDate Also Try adding Msgbox rs.recordcount...
  18. uberskunk

    User Name Password Coding

    Oh I forgot to add, put all the code in the code for your logon form and the public variable will be reloaded and set to 1 everytime you load the form.
  19. uberskunk

    User Name Password Coding

    Yeh, I agree with DirectDrive. I wrote this before I read Direct's post but you may as well see if it's useful for you. Public ipwdCount As Integer Private Sub cmdSubmit_Click() If ipwdCount < 4 Then ipwdCount = ipwdCount + 1 'Process Logon Here Else Unload Me 'Run cancel...
  20. uberskunk

    SELECT query on multiple fields

    Oh yeh, my mistake sorry I was rushing when I wrote that. I believe you can also remove the .item and just use recordset.fields(i).name But anyway, glad I could help some, Mike

Part and Inventory Search

Back
Top