Recent content by snakie

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...

Hmmm I'll see what I can do... It's so weired I can't use GetObject and CreateObject at the same time. Initially I thought it would be so straight forward... GetObject on Outlook, if failed, CreateObject. This is like a totally different world to me.. :confused:

Hi and thanks for this. I can do a CreateObject if Outlook is not running or not already in the system memory. However, if Outlook is already running, a Runtime error 462 (the remote server machine does not exist or is unavailable). As a result, I am hoping to get Access to check and see if...

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 and thanks very much for this. I have cleaned the code a bit and have done as you suggested. It all works now. Thanks very much for your help.

Hello, I have just opened up the database again and the forms are working though... I have re-attached the database here and see if you can open it, thanks. Joe PS. If you wish to add a test record on frmQuotesGenerator, the Change Order Number field needs to be filled in first, and must...

Hello and thanks for this. I am afraid the requery didn't work, and the main form frmQuotesGenerator jumped back to the first record. However, if I manually return to the form and refresh the data via DoCmd.DoMenuItem acFormBar, acRecordsMenu, 5, , acMenuVer70 then it works though. Why is...

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...

Hello and many thanks for this. Somehow I still got this error message when trying to run it (regardless of whether it is a Public Function or Public Sub. The error message is "Compile Error: Expected variable or procedure, not module". Do you know why this is the case? Thanks in...

Hello, Basically, if I put the whole thing in public function so that I can call it anywhere in the database: Public Function modFormCompletionCheck(strValueEntered As Variant) strValueEntered = Nz(Me.LocationID.Value, "") If strValueEntered = "" Then MsgBox "The location...

Hi and many thanks for the explanation. It's very useful. This public function is going to be used in 12 locations in the database because there are 12 separate reports to be linked to. Is there a way to put everything into the public function and just use one line to call the function over...

Hi, Erm... I have checked and it doesn't make any difference. Am I right calling modFormCompletionCheck in the correct way? (see above) Joe

Hello and thanks for this. I have changed it to: Dim strValueEntered As Variant Call modFormCompletionCheck(strValueEntered) However it doesn't work. It said "Expected variable or procedure, not module". Why is that? Joe

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...