Recent content by Tallbloke

So this is the error : The box has a title Microsoft Outlook The message is " We're sorry, but Microsoft Office has run into an error that is preventing it from working correctly. Microsoft Office will need to be closed as a result. WOuld you like to repair now? With the options : Repair...

Hmmm, just tested and it doesn't work. Everything else in the database seems fine, just this causing problems. Access throws a very polite but generic error message and asks me if I want to repair or close.

HI guys, Is there anything in this code that will stop me from upgrading to Office 2013 (so outlook and access 2013) Private Sub MailPackageWithPass_Click() On Error GoTo Err_MailPackageWithPass_Click Dim Signature As String Signature = "Kind regards," & Chr(13) & Chr(10) &...

That seems to work...will test some more and let you know!

The code is in the onload of the report.

I've re-opened the thread as something isn't quite right. I was using that code to set the .visible property to hide empty fields (they have a border). Whilst this works in print preview they aren't hidden when I generate a pdf.... Any ideas?

Yup, got it, sorted thanks!

Like this? If IsNull(Reports![PackageReportNew]![PackageDayReportNew].Report![Arrive2]) Then

Hi Guys, I can't seem to get this to work.... If Reports![PackageReportNew]![PackageDayReportNew].Report!IsNull([Arrive2]) Then Is the syntax correct or does the final! need to be followed by the field name? Arrive2 is a Date / Time field. Thanks!

Ah...got it! Posting here always helps :) With Forms!Customer!Payments.Form.RecordsetClone End With

I have the following bit of VBA which works like a charm : With CallNotes.Form.RecordsetClone .AddNew !CustomerRef = Me!CustomerRef !Who = Forms.markswitchboard!Text52 !Date = Now() !Notes = "Final Deposit Due on" & " " &...

TO be honest, I just re-created the query and report from scratch and it work... I'm not going to worry about it... but I'm sure the image will entertain people :)

The screenshot attached is taken from a report. This doesn't happen on a form. Any ideas what is causing this and how to solve it?

After spending hours on this, I decided the neatest work round would be to include the label in the control... ="Arrive Time: " & [ArriveTime4] and then use this code in the OnLoad section of the report If Me.ArriveTimeCombo4 = "Arrive Time: " Then Me.ArriveTimeCombo4.Visible = False Else...

Sorry to reply to such an old thread but I really can't get this to work on my reports! I have labels that I have converted to text boxes that I want to disappear if the control is empty and I can't get anythig to happen at all :(