Search results for query: *

Hi again I can understand a lot more about this now, however putting in a path for qryApprovalLetter.txt is not that easy for me. I have tried all sorts of things including strPath = AttachedTemplate.Path & Application.PathSeparator & "qryApprovalLetter.txt". It doesn't seem to recognise the...

Before I go off and try figure that one out, could it be anything to do with the fact that the form is going into a template (ThisDocument) because how I originally had it, when the form was attached to a particular document, rather than a template, it seemed to work. But then I ran into other...

Here's the code. Sorry it's a bit long. Public Sub UserForm_Initialize() With cmbStaff .AddItem "Buffy Devlin" .AddItem "Barrie Woods" .AddItem "Davina Hogg" .AddItem "Viviane Mulgrew" End With Dim myTemplate As String 'reads data from a file strPath = ActiveDocument.Path &...

Ok oops don't know what's happened now but when I go to create a document from the template, it says "file not found". When I click debug, it comes up with Load UserForm1. So I set a breakpoint in the initialize procedure, it steps through the code up right up until it tries to open the...

It is "Load UserForm1" that is sitting in the ThisDocument module.

Hi I have been trying to get my form to run since my last posting and with all your help I have now narrowed my problem down to this: when I run the form I get an error message saying "Object variable or With block variable not set". I don't understand this. Also are the forms linked with the...

Thanks Gerry That was put very clearly. And yes it is important to get the wording right there. I actually mean creating a new document and I can see that you know what I mean by your feedback. I feel like I'm getting somewhere although not quite there yet. I have added a Document_New()...

Thanks for your help. I had tried using a template, which would really solve some problems, but when I go to open up a document using the template, it won't load the form I have. You mentioned about putting it in the Document_New() event procedure; I don't really know how you mean. Could you...

Hi All I have a Word document that uses an input form. When initialized it reads data from a textfile. The document can then be saved. While this part works fine, the problem is that when this document is emailed and the recipient opens it, the file is looking for the data source that is...

Yes the problem is fixed. Thank you for your help.

Greg, I have tried that too. But it does the same thing, still cuts the last line in half. It's like Access doesn't really know where the bottom margin is and just guesses. Thanks for your reply.

Hi Tom It is not necessarily the last line of the footer, it can be any line in the footer depending on how much data is in the detail section. Pasting the footer data in the detail section repeats for each record in the detail. Is there anyway to attach or send you the database? It zips up...

The reason the footer is so large is because there is standard text that needs to be in the report for every client. This text needs to follow straight on after the data in the detail section. For some clients, the detail section is larger than for others (this data doesn't exceed the first...

Thanks for your reply. Is it then possible somehow to set a page break if the first page is a certain length?

I have a problem with the way the data on my report is printed. My report has one text field in the detail section, and can vary in size for different clients, and a large report footer (44.5cm) that contains a sizeable amount of text. Depending on the amount of data in the detail section, the...