Search results

:confused: but... have you tried???: Precs.Filter = "[KT]='P' And [RF]=" & rfs![RID] & " And [" & i & "] IS NOT NULL" If it works pay me a coffee...

Hi again, For a copy to somebody, according to the code I wrote the correct codeline would be: OutlookMessage.recipients.Add (email address).Type = 2 For a hidden copy the code would be the same changing type "2" for type "3". A "normal" recipient would be a "Type 1", but it's not showed in my...

Why don't you try with a Recordset? For instance: Dim rsttmp as dao.recordset Set rsttmp = currentdb.openrecordset([ Error_handling_table], dbopentable]) with rsttmp .add .fields("Error_Number").value = lngErrNum .fields("Error_Description").value = strErrDesc...

Hi, I don't know any way of changing it in VBA code using the Transfertext method. You can do it with the "CreateObject("Scripting.FileSystemObject").CreateTextFile" method, but it's more complicated and takes more time and system resources. So I'll porpose you an alternative solution: I...

Hi, Yo can do it in parts (maybe there's a better way, but I currently use that one, I think it’s more customizable): 1) Create the file or files to be sent "as you want" 2) Send the file by Outlook 3) Delete the file The first point is easy, you can use an “OutputTo” sentence or the...

Same answer... just use: Killl "c:\blabla.txt" This method will produce an Error 70 if the file to delete is blocked or opened, think you need an error handler.

That's have been really hard to understand...I have some Access Database working more or less "as you want". It's not necessary to go to the VBA level except for some small details. Assuming that the [OrderId] field in the ORDERDETAILS table is linked to the [OrderRefId] field in the...

Hi, If nothing of the above works, try using the Set objWord = nothing (yes, I know you said it doesn't work) but with this Dim instruction: Dim objWord As Object Set objWord = CreateObject("Word.Application") It works for me... anyway, there are a lot more of things to consider, for instance...

Another way to do the same (not exactly, but...) The right answer for your question has been already given, but maybe you don't know this option: In the design view of a form, see the properties of the textbox. In "Others" you'll find the property "EnterKeyBehavior". Changing this property you...