Recent content by MattSmithProg

Thanks. That makes more sense. I am so used to using SQL server. No wonder I was pulling my hair out, the bit that I had left anyway!!! Matt Smith No two nulls are the same

Hi all, Just coming back in to doing some programing and have got stuck. I just can't seem to work out what I am doing wrong. Access keeps telling me there is a syntax error. Can you have a look and let me know what I am doing wrong. SELECT ContractNo, OrdDate, CASE WHEN...

Hi all, Does anyone know how to bring up the insert item window (On a new message, Insert - Item) in outlook programatically. I want to be able to have the user select a series of email/s and then extract their itemid's. Any ideas??? Matt Smith No two nulls are the same

Hi, Another option that you could use is to create a shortcut to the original word document. You can then change the icon of the shortcut. Quick and easy and no fees involved. Matt Smith No two nulls are the same

Hi all, I know this query isn't very efficient but I can't find a way to make it work any better. The problem I have is that I need to compare a one column string (Surname, FirstName) on one table with two columns of data (Surname & FirstName). What further complexes it is the way in which some...

Hi, I have had this problem for a while now. I am attempting to get the properties of an individual via the Global address book. What I have so far is this: Sub AddName(txtNameBox As Object, strTitle As String) Dim objSession As MAPI.Session Dim objRecips As MAPI.Recipients Set objSession =...

Hi, The unread calender item is exactly the same as an unread email. I would expect that her assistant has added an appointment or such to the calender and this (1) is for notification of a new calender item. The only way in which I have found the ability to find the unread calender items is...

Thanks Nikki, I was hoping that there may be any easy way to redistribute the class modules when a change has been made. Maybe not? Oh well I will probably when I get a chance, (Our organisation is moving from Win 95, Office 97 to Win XP ,Office XP), start recoding some of my more commonly...

You will have to recreate the query but when you create the new query instead of selecting a drive to access the database type the UNC as above instead. Matt Smith No two nulls are the same

Hi, You can use the Universal Naming Convention UNC. Ie. \\ServerName\Folder\File.mdb HTH Matt Smith No two nulls are the same

Hi, I have been programming in VBA for over 2 years now and have never found the need to use class modules. For all the reading I do everyone is recomending using them. I can see the benefits of using them but what I would use them for I can put in normal modules. The major reason that I would...

Hi, It would be my guess that the mail message was in HTML format and the "wooshing" would have been an animated GIF of some sort rather than VBA. Hope this gives some insight. Matt Smith No two nulls are the same

Just a little Microsoft humour. This has got to be one of the most useless functions built unless I have completely missed something. Matt Smith No two nulls are the same

Hi, There is a little funtion that may point you in the right direction. Place this code in the ThisWorkbook module Private Sub Workbook_BeforeSave(ByVal SaveAsUI As Boolean, Cancel As Boolean) SaveAsUI = False Cancel = True End Sub The only problem with this is that you can't save the code...

Hi, Instead of using the API to pause the connection you can use the inherent properties of the IEbrowser. Use Do While xxxxxx.ReadyState < READYSTATE_COMPLETE NewHour = Hour(Now()) NewMinute = Minute(Now()) NewSecond = Second(Now()) + 1 WaitTime = TimeSerial(NewHour...