Recent content by z0001130

Thanks for the code, I had already done code to error trap the button, but I prefered to grey out button if there were no records. Thanks John

Thanks for that. Whilst this wasn't the soluction, it still errored on closing the form, it was the start of the solution. It made me rethink the logic for enabling the button. I have now disabled the button by default, and if there are any records I activate it, rather than the other way...

Hi, I has the On Open action for my Form set to: Private Sub Form_Open(Cancel As Integer) If Me.Recordset.RecordCount < 1 Then Me.Command33.Enabled = False Else Me.Command33.Enabled = True End If End Sub which works fine, unless I delete all the records shown on the form. Why, because the...

Thanks for that. I have to admit it is a little above my skill set. On further analysis of the symptoms, it only happens when Outlook is already running. I did try to use the GetObject but I failed. I then removed the oOutlook.Quit line and just left the oOutlook = Nothing and omail= nothing...

Everyone, I am using "MyOutlook.Quit" command to close the instance of Outlook that I created but... because the vba ruins faster than Outlook sends the email, I get the warning from Outlook about there being unsent messages in your outbox, exit without sending etc. I there a method of...

Thanks for that one, that was the starting point I needed, lots more has come form your that small seed you planted. One more small question, I am now able to send the email with the file attached to my list of emails in my table, but when I clean up after myself and tell outlook to quit, it...

Thanks, I will try that when I am home. Do you know what I would have to check via code to skip the 'email' part and just create the file if Outlook was not present on the machine. Thanks John

Hi, I have managed to write some code to create a text file and email it as an attachment using the Reference method (early binding), but I fear I will run into problems when I put the DB on a machione that has a earlier version of Outlook. I have searched and found several mentions of 'Late...