Search results

Hi, I want to search a cv field (data type memo) and match it against multiple criteria for instance - Administrator, Hospital, Degree etc ... this would be looking for someone who has experience in administration possibly in hospitals with a degree .... can anyone suggest the best way of doing...

Hi, I have used this code to handle 2501, On Error GoTo Err_Handler DoCmd.SendObject acSendNoObject, , , Me![Top of Jobs].Form.Email, , , "Re:" & [Job Title], "Dear " & Me![Top of Jobs].Form.[Title] & " " & Me![Top of Jobs].Form.[Last Name] & ",", , False Exit_Handler: Exit Sub Err_Handler...

2501 when i clcik the email window closed to cancel the sendobject command ... i have read that you can put code into the save button field but i can't see a save button property listed .... i am currently trying to work out the code below and where to put it maybe in one of my button properties...

ps what should i put instead of On Error Resume Next i just want to make sure that if they click to close the email window it doesn't pop up an error message! Cheers ed

I've got it working now i think i had just left off the [templatefile] parameter now i have added it it seems to be working fine! Thank You for your time and patience!

ok no probs i'll do it but can you tell me how to delete it after ... cheers ed

can i ask will anyone be able to download it cos i won't be able to if they can. : (

how i do that?

No its not its just a normal form ... seem to have a problem with active x control on another button could that be causing the problem with the email sub?

no it isn't it's just a normal form. Why would the button hang on second push? Ed

Basically it wasn't anything to do with the error handling line the button seems to fail the second time i push it. There is no error message access just hangs! Cheers, hope that helps narrow it down. ed

the code works fine. But if i close the email window without sending the it comes up with a sendobject macro halted which i didn't want so i just put a on Error Resume Next .. ps "Hardly do you see developers supressing error messages in such fashion" - everyone has to start somewhere."

Here is the code with code tags! Private Sub Command286_Click() On Error Resume Next DoCmd.SendObject acSendNoObject, , , Me![Top of Jobs].Form.Email, , , , , True End Sub

Hi vbaInet, yes i have. Thank you. I have managed to write the code. Currently it is hanging when i press the button a second time. I'm assuming i have to end the On Error Resume Next - any ideas. Will be working on that now! Cheers and Thank You Eddy

I have built it now itworks until i press the button again! the second time access hangs can anyone tell me why? Private Sub Command286_Click() On Error Resume Next DoCmd.SendObject acSendNoObject, , , Me![Top of Jobs].Form.Email, , , , , True End Sub Thank You Ed

DoCmd.SendObject acSendNoObject, , , Me![Top of Jobs].Form.Email, , , "Email Subject", "Email Message Boddy Text", "False" it is saying that "an expression you entered is the wrong type"!? Email field is a text field maybe it is expecting single paretnheses?

Thank You. That is great but how do i pass it the contents of a field on the form for instance put [Client Email] into the address bar when the window opens?

I want to pull up an outlook send message window, the address having been taken off the access form .... how do i do this. I have looked up code but it looks complicated is it? Also unsure how to call a module once i have written or in my case copied it!!!!! aaaaahhhhh!

That is very kind - Thank You! I have it working now and it has transformed the form. I feel very encouraged by you and really appreciate your help. Thank you very much!

Is it possible to do this Me.Filter = "[OPEN/CLOSED] = 'OPEN'" And "Not [Archive Dates] Is Null" ?