Search results for query: *

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

...T8.CostCentre Cost_Centre, FROM EPUB..PublishingArticle T1, corporate..vwOfficerV2 T8 WHERE T1.Identifier = IS NOT NULL AND (T1.Owner *= LTRIM(RTRIM(T8.Surname)) + ', ' + LTRIM(RTRIM(T8.firstname)) OR T1.Owner *= LTRIM(RTRIM(T8.Surname)) + ', ' + LTRIM(RTRIM(T8.preferredNm)))...

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

Hi, I am trying to extract the document header from a web page. I have created an object using SHDocVw and can open up the page that I want. I just need the document header information from this page. If anyone has any ideas I would be extremely grateful. Thanks Matt Smith No two nulls are...

Hi, Are these files being downloaded of the Internet/Intranet. If so you may have to alter how the excel files are opened. If you open up Windows Explorer and then select View - Options. Then select the File Types tab. From here find the reference to Microsoft Excel Worksheet. Select it and...

Present Value is a function already built in to Excel. It is the function PV. It is supposed to return the Present Value of an investment. It shows the total amount of future payments is worth now. If this is not what you are after let me know and I can see if I can help some more Matt Smith...

You need to reregister Excel. The easiest way that I have found to do this is to copy the shortcut you use to open Excel and then open the properties dialog. From here you open the Shortcut tab. Look in the Target text box. You should see something like this &quot;C:\Program Files\Microsoft...

Hi, You could use the Application.StatusBar to display messages. Just check that it is turned on. Matt Smith No two nulls are the same