Search results for query: *

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

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

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

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

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

Hi, Yeh you'll need to use the API CreateProcess and WaitForSingleObject Here is the code for the module 'Win32 (Kernel32.lib) constants, datatypes and funtions '(used to create and execute processes). Public Const K32_INFINITE = &HFFFF 'Infinite Wait period. Public Const...

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

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

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

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

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

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

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

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

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.

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

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

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.

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

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