Replies

How about just pasting the cells from Excel? This should come in as a table that you can then format. (Unless you are trying to avoid having to format a table each time data changes in the Excel spreadsheet… that’s why you were merging in the first place.) Or record a macro for your formatting of the table, then each time you want your new roster, copy the data from Excel and run your macro. (formatrooster)

You can manually add this back – click Tools, Customize, select the Command tab. On the left, select Built in menus, on the right, look for Edit. CLICK AND DRAG this item (EDIT) back up to the menu.

How about placing your text in the header? This seems to work for me.

This works great! THANK YOU.

Very cool. Thank you!

That did the trick! Thanks again Charlotte.

That did it! Thanks!

THANKS! This did the trick.

Yes, that code is not in the groupheader2 as I wrote, it’s in the detail area, to suppress records that are not complete. Sorry for the confusion.

I have found a solution, some code in the header (just above the detail area, in groupheader2), to suppress the header just above the detail, when the detail record’s “items” field is null.

Private Sub GroupHeader2_Format (Cancel As Integer, FormatCount AsInteger)
If IsNull(Items) Then
Me.PrintSection = False
Me.MoveLayout = False
End IF
End Sub

Apparently a header can refer to the first record in the section just below it, in this case the [items] field in the detail section.

THANK YOU THANK YOU THANK YOU!!
That sendobject was going to be the end of me. Works like a charm every time.

THANK YOU! This works beautifully. (You can tell I don’t know VBA – I am amazed everytime it works.)

Private Sub Command6_Click()
DoCmd.SendObject , , acFormatHTML, , , , [Complaints.CompContact], “[Complaints.Comp.Desc] “, True, “”
End Sub

Form is based on Complaints table. Subject of the email is the CompContact and the message text pulls from the Comp.Desc (the description of the complaint). I’ve added and deleted statements like option explicit and this makes no difference. I need some signal to Outlook to reset or something like that. (I am not a VBA programmer, just guessing here…)THANK YOU.

THANK YOU! This worked perfectly. COMBOBOX is the solution I was seeking.

THIS IS BRILLIANT! Much better than advanced filter solutions, which is the way I’ve always taught it. So simple it hits you in the nose! THANK YOU.

THANKS.

I’m not yet familiar enough with VBA to follow your steps – I was hoping there was an easier solution.

I did FINALLY figure out those link gotchas – lots of trial and error (wasn’t much on this in the help files!).

DO YOU KNOW – how to get an icon to stick with the link? (I picked up an icon off my c drive, but when it’s copied to a floppy or emailed, it loses the icon.)

THANKS AGAIN.