Sending commands to Microsoft Word Application

GESALO · Feb 12, 2001

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 · Feb 14, 2001

Code:

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

Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Sending commands to Microsoft Word Application

GESALO

Programmer

Ruairi

Programmer

Similar threads

Part and Inventory Search

Sponsor