Recent content by Jabba

Don't worry, spotted the stupid mistake - leaving the ".Protect wdAllowOnlyReading" copied from another bit of code.

Thanks Gerry. I use vba a lot but I wouldn't say I'm an expert, especially when it comes to interacting with other Office apps. I'm coming up against an issue when I try to insert the file (breaks on code in red below). I get an error message saying "This method or property is not available...

Hi Gerry, I finally got some spare time to take a look at your code. Whilst it's great if I want to create a new doc from scratch, the problem I have is that I have to use a template that I have been given which is 30-40 pages long. The doc is an insurance policy so the vast majority is just...

Thanks Gerry. That is very comprehensive and very helpful. Cheers!:)

Thanks Gerry. I actually ended up going the route of your first option. The users need to email the resulting doc so they can simply 'Send to>Mail receipient as pdf'. However, I would be interested in your vba code to create word docs with variable no. of records, as this would also give me...

Thanks for your reply Paul. However, it's not the access side of things I'm not clear on. I have my recordset in Access (2003) that I'm using to get the data that I need to populate the form fields with; this is formed of 2 tables linked on a one-to-many relationship. The issue I'm having is...

I have tried to search the forums for an answer to this but to no avail. Apologies if this is the wrong forum but here goes. I have an Access database where on click of a command button it populates form fields in a word template doc. Up to now this has been working fine, but it's only on a...

Hi, I'm pretty much a self taught Access programmer (amongst other things), and have been doing so for the last 7-8 years. Streets away from being an expert but learning as I go. Looking forward to benefitting from the vast experience of the many users on here :)