Adding tables to Created word document whilst other word document open Help

macropod · #14 03-23-2016, 04:13 PM

Quote:

Originally Posted by rpb925

it didn't like the below code especially the last if is null statement not sure why though so I changed it back to the other format and it worked ok.
Code it didn't like

Code:

If IsNull(QueryA!CheckTitle) = False Then .Cell(1, 1).Range.Text = QueryA!CheckTitle
          If IsNull(QueryA!CheckOutcome) = False Then .Cell(1, 2).Range.Text = QueryA!CheckOutcome
          If IsNull(QueryA!CheckComments) = False Then .Cell(1, 2).Range.End.InsertBefore vbCr & QueryA!CheckComments
          End With

In that case, you might try:

Code:

If IsNull(QueryA!CheckTitle) <> True Then .Cell(1, 1).Range.Text = QueryA!CheckTitle
If IsNull(QueryA!CheckOutcome) <> True Then .Cell(1, 2).Range.Text = QueryA!CheckOutcome
If IsNull(QueryA!CheckComments) <> True Then .Cell(1, 2).Range.End.InsertBefore vbCr & QueryA!CheckComments

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Adding furigana to a Word document	rjribbit	Word	0	12-03-2015 09:33 AM
Inexperienced user having dificulty adding text to document I created. Fixed text moves around.	Athalwolf	Word	2	02-08-2015 09:08 AM
Error message opening a document in Word "Word cannot open this file because it is larger than 512 M	poonamshedge	Word	2	09-11-2014 06:11 AM
Adding and Moving parts of a document in Word	PauledInAction	Word	4	07-13-2012 02:38 PM
Adding bullets in a protected Word document	Cindylu3	Word	0	10-03-2008 03:16 PM