Recent content by hbaggs

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...

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)...

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

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...

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()...

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...

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...

many thanx

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

thank you thank you again

thank you thank you for your help

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...

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...

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...

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...