Search results

Hi, I am just wondering, I have a database which can be used to send emails via Outlook. However, it only works if Outlook is already running in the background. If Outlook is not already running, I get error 462 (The remote server machine does not exist or is unavailable). Is there any way...

Hello, Part of my database contains procedures of automatically send emails. I notice that if Outlook is not running already, Access displays an error. Therefore, I am now trying to get Access to check if Outlook is already running, and if not, run Outlook. Unfortunately, I receive a...

Hi, firstly please take a note on this code: Private Sub AddItem_Click() On Error GoTo Err_AddItem_Click Dim UserConfirm As Integer Dim strSQL As String Dim OID As String OID = Me.ChangeOrderNumber.Value 'Check if the relevant fields have been filled in Dim...

Hi, I hope someone can help me. I've never done any public functions previously, but I have a short procedure which is going to be used in various part of the database so I'm hoping to put it into public function. However I am unable to call it (either the public function is wrong, or the way...