Search results for query: *

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 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, 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, 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, I am attempting to convert a datetime column to the format mm/yyyy. At present I have this SELECT CAST(Month(getDate()) AS CHAR(2)) + "/" + CAST(YEAR(getDate()) AS CHAR(4)) However this returns 8/2002 but I want 08/2002. Is there any way to get the month to return a zero at the...

Hi, I have a function written in VB that creates a User DSN via the registry for access to a networked database. We are soon migrating from Windows 95 to XP. I have been trying to get our technical support guys to give me some advice on any differences in the way the registry handles ODBC...

Hi, I have a funny problem that I can't seem to solve. I have two tables. I am trying to do a Left Outer Join on these tables. My understaning of Outer joins is that, in a Left Outer Join you will get all of the Left table in the query with matched columns if available to the right table and...

Hi, I am inserting a row of data in to a table and as the primary key determing the maximum field for that value and adding one. I would like to know how I can return this as soon as I have done it. I would normally just use a simple select query to return the max record but as there are...

Hi, I have a query that I have written and it works fine but it seems very inefficient. I would like to know if there is a better way to write it. My table consists of this NAT Finalisation_Result Finalisation_Date 4224 Adjust 01-04-2002 3224 Referred...

Hi All, I am attempting to devise a costing program for garages, Sheds, Roofing, Guttering etc and am trying to find a way to allow the user to either draw in the design of the Shed/Garage etc or be able to scan in a drawing so as to work out the area and thus the cost of the shed/garage. I...

Hi, I have a little problem trying to create a query so it returns in the manner I want. I have some data that looks like this. Type Due_Dt Fin_Dt Min_Sgn_Dt MIN 22/12/2001 18/12/2001 MIN 18/01/2002 15/01/2002 MPC 25/03/2002 17/03/2002 MCO...

Hi All, I have developed a small app in Excel that needs to confine key strokes in text boxes to numbers and decimal points. I am using the KeyPress event to generate the check and this works fine. However, I also use this event to call another routine which generates a value for another text...

Hi All, I have probably a really easy question but I can't seem to nut it out. I have a Union query like this. SELECT UserId, Site, NAT, Count(NAT) As Total FROM PTAPP_ACR_MAIN WHERE Site = 'HOB' GROUP BY 1, 2, 3 UNION ALL (SELECT UserId, Site, NAT, Count(Nat) As Total FROM...

Hi, I have two tables that have the same fields and structure. What I want to do is to have a Select statement that returns all records based on a where clause. ie Table1 Structure ID, Yr, Allocate_Dt Table2 Strucure ID, Yr, Allocate_Dt SELECT * From Table1, Table2 WHERE...

Hi All, I use our corporate intranet to distibute little applications based in Excel. We then provide URL's to download the Excel workbooks so they can then use them. We have just upgraded to IE5.5 and have found that on some machines when people download the file it says that the file is...

Hi all, I have been trying to find a fast/easy/efficient way to determine if a series of option buttons have been selected or not. At present I check each one individually but I am looking to find if there is a way I can pass each group of option buttons to a function and see if the user has...

Hi, I have a little problem trying to resolve an email address via the alias. Normally I have this code to resolve an email address and return the display name and office. Function GetNameAndSiteFromOutlook(sUserId) As Boolean 'sUserId is passed via an input form where the user enters a...

Hi, I am having a little trouble attempting to coerce the data in to a format that a report needs to be in. I have data in the format of this. NAT Finalisation_Result 25 Dr Amend 25 Cr Amend 50 On Hold 25 On Hold 40 NFA . . . . What I want is to have the data return like...