Search results for query: *

Hi All, I have one user that has a missing reference for msoutl.olb or more commonly know as Microsoft Outlook Object Library. We are using the 11/2003 verion using OFFICE11 directory Naturally i have checked the below directory for the following which does exist. C:\program files\microsoft...

Hi All, You proberly have seen this before but attemptin to simply transfer a query results into a spreadsheet using DoCmd.TransferSpreadsheet _ TransferType:=acExport, _ SpreadsheetType:=acSpreadsheetTypeExcel97, _ TableName:="query_name", _ FileName:="file", _ HasFieldNames:=True there is...

legend cant believe i forgot that one cheers again

Hi there got a slight problem with formating a string ive done this before but too long ago need some reminding all im trying to do is get the frist two letters from a code eg bd1001 all i want to use is the bd currently got prefixedcodedigits = Format(prefixedcode, "##") but does not work...

Hi all, bit of a prob sending an e-mail to clients. the problem being with the below code is that it will send the message after all feilds are filled in outlook but then decides to start a new message as well any idea how to stop this so when the message is sent it goes back to access or is it...

Never mind got it working now thanks everyone for your help its greatly appreciated Nick

You wouldn't happen to have a code example of how its is used would you phv?

Hi all, does anybody know a good way of coding for a search while typing can it be done on the after update comand or is there a better way e.g. searching nick, nigel, nathan n needs to bring up list of all names begining with n nick and nigel and nathan ni brings up nick and nigel nic...

Hi again, what im trying to do is a holiday request system and when the process is complete a request will be logged with an approver, but that approver needs to know theres is a request for them to approve. we are using access 97 and outlook for e-mail can you just give an example on how it...

hello all does anybody know of a good way to search each letter whilst you are typing it???? in access 97

Hi all has anyone got an idea how to do e-mail confirmation in access 97 by any chance