Access to Output into Word

[bluetongue]

Access to Word

After googling Error 13 - I find it refers to a datatype mismatch.

You have declared lng_Photo_Number as a string variable but the lng_ part of the name would seem to imply that the PhotoID in tbl_Photo_No is a long integer.

If the above assumption is correct try declaring lng_Photo_Number as long Integer (or the same data type as the field in the table if it is something else).

 

[The_Doc_Man]

Or use CStr or CLng to convert the value to another format before using it in the location where it gives the error.

 

[alastair69]

Cheers Doc Man i am messing about with it know, i will try that one

 

[KellyR]

Hi,

I'm pretty sure this procedure may have already been discussed with you, but here's what I'm using and it works great. From Microsoft.
http://msdn.microsoft.com/en-us/library/aa140082(office.10).aspx