Sending commands to Microsoft Word Application

[GESALO]

While sending field values to word document (creating memo or letter from access to word application) only those fields are transferred where the values are present otherwise the process stops as soon as it encounters a null value and we get a message “Run time error ‘94’ Invalid use of null”. Please suggest a solution.

Thanks.

 

[Ruairi]

If Not IsNull(ValueYou'reSending) Then 
   'Do whatever youre doing now 
Else 
   'Substitute a zero or some other acceptable value for 
   'the null 
End If

Ruairi

Could your manufacturing facility benefit from real time process monitoring? Would you like your employees to be able to see up to the minute goal and actual production?
For innovative, low cost solutions check out my website.

http://www.plccontroltechnologies.com