Search results

Thanks Isaac, for pointing me to the solution, I already noticed that ?TypeName(item), returns "DocumentItem" I will let you know if I can figure this out

Hello, I would appreciate your help with the folowing code, wich retrieves jpg files sent to a folder in my Outlook email account, and it works just fine, but if instead of receving a email with a image attachment, I just drag and drop a jpg file into the Outlook folder the code wont recognize...

Thank you all for your help, I ended up going with arnelgp solution that works great

I want to find out if the string "Bolo" is contained in a text field in my recordset and avoid the field "spagetti bolonhese", but I wanting to find the field "bolo marble chocolate" the folowing finds both If rst(1) Like "*" & Term & "*" Then so I tought I should add a space before and...

That works nicely. Many thanks for your help

I tried the chang event wich is triggered when I paste the number 55.55, but I on that event I cant access the number as it is not available yet to manipulate with the replace function CJ_London, there is no formating applied no input mask the control is bound to a datatype number/double the...

Hi, I cant figure out how to change dots into comas to separate the decimal part of a number If KeyCode = 190 Then KeyCode = 110 the previous code on the keydown event works when entering numbers separated with commas, but not in case I paste a number When I copy 55.55, into my form control...

Hello, I wonder if it is posible with VBA to set the enter key to shortcut closing a jpg file.something like pressing the enter key instead of ALT+F4 Thanks

Arnel, i did as you suggersted and read those posts, wich made me find the solution, wich ended up as folows : Dim db As dao.Database Dim ns As Namespace Dim Inbox As MAPIFolder Dim filename As String Dim i As Integer Dim objSearchFolder As Outlook.MAPIFolder Dim Item As MailItem Dim atmt As...

I am trying to download the attachments that I have in a folder in Outlook with the code : Dim db As dao.Database Dim ns As Namespace Dim Inbox As MAPIFolder Dim filename As String Dim i As Integer Dim objSearchFolder As Outlook.MAPIFolder Dim item As MailItem Dim atmt Dim strSQL As String...

Thanks the DBguy, you were right I had code behind my subform that had to be updated, that was the problem, so on the afterUpdate event of the for I dis Me.requery, and on the afterInsert event DoCmd.GoToRecord , , acNewRec, and that did the trick Thanks for your help

I attached 3 images, before update, after update, and finaly after mouse rolling down thanks

Hello, Everytime I update a new record in my continuous subform, the first record becomes invisible. I have to use the mouse rolldown to make it visible again. I ve been trying most of the format properties of the subform, even creating a new subform, and still I cant solv this. any thoughts ?

me.Requery didnt work either. I the end I had to go with Dsum in the onCurrent event : DSum("[Debito]", "tblDetalheMovFinanc", "[movimentoid] =" & Me.MovimentoID) Thanks for your help

the only way I can make it work is by pressing F9. is there a way to replicate F9 programaticaly?

This is an image of the file that I uploaded.

hummm, that is strange !! this is what I get opening the same form why would this happen ?

I added a demo of the form, and the two controls (yellow color)

it is not a calculated field

that is the syntax i was using