Search results

  1. H

    need Word maximised after merge

    Using Access 2003 and XP I am able to effect a merge from Access and Word appears maximised ready for the user to make additional changes etc. However using the same code on my Access 2003 and Vista machine the resulting merged Word document appears minimised on my desktop. Why is there a...
  2. H

    code to force print layout

    Almost- but not quite I have been testing using your suggestion and with some minor change to your suggested code. However something else is wrong or the placement of the code is wrong. I paste the code underneath (but have deleted the majority of the code you do not need to see in the middle)...
  3. H

    code to force print layout

    Exactly what I needed Thank you so much, this is the answer- I do appreciate your assistance
  4. H

    code to force print layout

    I use Access to merge a query with a Word 2003 document then save it ready for emailing. However as the clients receive the document via email the view appears to be "normal". Is there a way I can force Print Layout by saving the document in that Print Layout view by code after the merge is...
  5. H

    merging several records into a single Word document

    my amended code thanks premy I have used your code and placed it in mine where I needed it (or so I was thinking). It stops at the line Set rs = db.OpenRecordset("qryIndividualStudentReport4", dbOpenDynaset) Can you look over this code and tell me what is wrong? Sub ConstructStudentReport()...
  6. H

    merging several records into a single Word document

    I am trying to merge multiple records into one Word document with the following code, however only the first record is merged into the single document....What do I need to add to my code below. Many thanks Sub ConstructStudentReport() Dim objWRD As Word.Application Dim objDoc As...
  7. H

    Access Database as source for Mail Merge

    KB article 885832 states exactly my problem. I have a query which makes a table as the data source for a Word 2003 merge document. It takes the results of a single record and plonks it in a table and does that exactly as expected. However when access calls word it says I need to locate the data...
  8. H

    Pictures on Long forms with Tabs

    many thanx
  9. H

    Pictures on Long forms with Tabs

    Is it possible to place an image on a single Tab which does not then appear on the 2nd and third tabs of the form? Access 2003
  10. H

    Do I use "0" or 0

    thank you thank you again
  11. H

    Do I use "0" or 0

    thank you thank you for your help
  12. H

    Do I use "0" or 0

    I wonder which is correct If IsNull(DLookup("PrivateContractFee", "tblAllStatementTEMP")) Or (DLookup("PrivateContractFee", "tblAllStatementTEMP")) = "0" Then objDoc.Bookmarks("PrivateContract").Select objWRD.Selection.Rows.Delete End If or is it ? If...
  13. H

    Access to Word merge

    I have a query which populates a form with one record. I have a list box on that form which is a list of current Word Merege documents. (created in Word 2000 and Access2000) I am upgrading to Word and Access 2003 and I am wanting to merge the data from the record displayed on the form into the...
  14. H

    Access 2003 Query to Word 2003

    Yes basically thats the idea. A command button on an Access form calls a particular word document which runs an instance of word and the word document has as its data source an access query which has a criteria required i.e. a file number which then gets just that record and merges it all into a...
  15. H

    Access 2003 Query to Word 2003

    query problem Thank you for your advice. I really want to be able to select the particular letter from within Access and start an inatnce of Word which then uses the existing Access query which is set to locate a particular record thru the criteria input to populate the letter with the correct...
  16. H

    Access 2003 Query to Word 2003

    I am wanting to merge data from a specific record in Access. I have created a query in which I have placed a parameter in the criteria [Enter a file Number] in the appropriate field in the query. The query works properly. I have then merged it with Word and selected an existing document...
  17. H

    pop up message

    Old Boss? OK- I'm not too cocky at the moment...my team is nearly bottom!!! Thank you for the next version of this little pop up program. I have a small application which we use to record our telephone Messages. Sort of like the old written message book. Trouble now is that we forget to open up...
  18. H

    pop up message

    Old Soft Boss G'day..I have a lot of sympathy for Victorians! Thankyou for the attachment. How would I be able to view this code? After extracting and double clicking it -it opens and for love nor money I can't get into the properties to see events etc. I am hoping I can just paste this code...
  19. H

    pop up message

    Thankyou for such a quick response. Basically where does this code go? Is this three different ways of doing the same thing or all of it needed.? I would be grateful for a little more basic instructions....thanx
  20. H

    pop up message

    I am wanting to create a small program which enables three users on a XP network peer to peer which enables each user to send a pop up message (i.e. You have a message waiting). This would be used to alert a user they have a message waiting and or just to send a simple message to the other. I...
Back
Top Bottom