Stuart Sanders
stuart at pacific.net.hk
Thu Aug 21 01:52:50 CDT 2003
Maybe unrelated, but what version of office are you using? > -----Original Message----- > From: accessd-bounces at databaseadvisors.com > [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of > William Hindman > Sent: Thursday, 21 August, 2003 2:08 PM > To: Access Developers discussion and problem solving > Subject: Re: [AccessD] Select Range of Records ...Word from Access > > > ...ok ...I thought that was the question I'd originally asked > ...how do I > "throw" 600 records into each doc? :) > > William Hindman > So, then, to every man his chance -- to every man, regardless > of his birth, > his shining golden opportunity -- to every man his right to > live, to work, > to be himself, to become whatever his manhood and his vision > can combine to > make him -- this, seeker, is the promise of America. > -- Thomas Wolfe > > > > ----- Original Message ----- > From: "Michael R Mattys" <michael.mattys at adelphia.net> > To: "Access Developers discussion and problem solving" > <accessd at databaseadvisors.com> > Sent: Thursday, August 21, 2003 2:04 AM > Subject: Re: [AccessD] Select Range of Records ...Word from Access > > > > I don't know what you've got going into > > each record, but if you were to throw 600 > > records into each document ... you wouldn't > > run into a problem with either Word or the printer > > > > Maybe? > > > > Michael R. Mattys > > www.mattysconsulting.com > > > > > > ----- Original Message ----- > > From: "William Hindman" <wdhindman at bellsouth.net> > > To: "Access Developers discussion and problem solving" > > <accessd at databaseadvisors.com> > > Sent: Thursday, August 21, 2003 1:11 AM > > Subject: Re: [AccessD] Select Range of Records ...Word from Access > > > > > > > Michael > > > > > > ...you say that as if you thought dumb and dumber here > had a clue as to > > how > > > I'd pull that off ...maybe its just that at 1AM my brain > refuses to > > engage > > > in rational thought :) > > > > > > ...of course, many would say that's true even in the > middle of the day > :) > > > > > > William Hindman > > > So, then, to every man his chance -- to every man, > regardless of his > > birth, > > > his shining golden opportunity -- to every man his right > to live, to > work, > > > to be himself, to become whatever his manhood and his > vision can combine > > to > > > make him -- this, seeker, is the promise of America. > > > -- Thomas Wolfe > > > > > > > > > > > > ----- Original Message ----- > > > From: "Michael R Mattys" <michael.mattys at adelphia.net> > > > To: "Access Developers discussion and problem solving" > > > <accessd at databaseadvisors.com> > > > Sent: Thursday, August 21, 2003 1:07 AM > > > Subject: Re: [AccessD] Select Range of Records ...Word from Access > > > > > > > > > > Of course, using this you could also add > > > > a new document every 31 mb also ... > > > > > > > > Michael R. Mattys > > > > www.mattysconsulting.com > > > > > > > > > > > > ----- Original Message ----- > > > > From: "Michael R Mattys" <michael.mattys at adelphia.net> > > > > To: "Access Developers discussion and problem solving" > > > > <accessd at databaseadvisors.com> > > > > Sent: Thursday, August 21, 2003 12:17 AM > > > > Subject: Re: [AccessD] Select Range of Records ...Word > from Access > > > > > > > > > > > > > Bill, > > > > > > > > > > Having read this, it seems to me that you aren't > > > > > really using a template at all. If you save the doc > > > > > as .dot, this may help you for every 4 records: > > > > > > > > > > ---Posted by Dev Ashish--- > > > > > > > > > > Opening a new Word document based on a > > > > > template through Automation > > > > > > > > > > To open a new Word document based on an > > > > > existing template, we need to specify a > > > > > value for the Template argument of the > > > > > Add method of the Documents collection. > > > > > > > > > > If the template file (.DOT) is saved in > > > > > the UserTemplates path, we can use the > > > > > pre-defined contant wdUserTemplatesPath. > > > > > Otherwise, we will need to supply the > > > > > complete path to the template file. > > > > > > > > > > '****** Code Start ******** > > > > > Private mobjWordApp As Word.Application > > > > > > > > > > Private Sub Command1_Click() > > > > > Const conTEMPLATE_NAME = "\Templates\merge.dot" > > > > > > > > > > Set mobjWordApp = New Word.Application > > > > > With mobjWordApp > > > > > .Visible = True > > > > > .WindowState = wdWindowStateMaximize > > > > > .Documents.Add Template:=(.Options.DefaultFilePath( _ > > > > > wdUserTemplatesPath) & conTEMPLATE_NAME) > > > > > End With > > > > > End Sub > > > > > '****** Code End ******** > > > > > > > > > > Michael R. Mattys > > > > > www.mattysconsulting.com > > > > > > > > > > > > > > > ----- Original Message ----- > > > > > From: "William Hindman" <wdhindman at bellsouth.net> > > > > > To: "Access Developers discussion and problem solving" > > > > > <accessd at databaseadvisors.com> > > > > > Sent: Wednesday, August 20, 2003 10:56 PM > > > > > Subject: [AccessD] Select Range of Records ...Word from Access > > > > > > > > > > > > > > > > ...ok ...just don't ask how I get into these things > ...and if this > > > seems > > > > > > like a JC post, I really don't want to hear about it :( > > > > > > > > > > > > > > > > _______________________________________________ > > > > > AccessD mailing list > > > > > AccessD at databaseadvisors.com > > > > > http://databaseadvisors.com/mailman/listinfo/accessd > > > > > Website: http://www.databaseadvisors.com > > > > > > > > _______________________________________________ > > > > AccessD mailing list > > > > AccessD at databaseadvisors.com > > > > http://databaseadvisors.com/mailman/listinfo/accessd > > > > Website: http://www.databaseadvisors.com > > > > > > > > > _______________________________________________ > > > AccessD mailing list > > > AccessD at databaseadvisors.com > > > http://databaseadvisors.com/mailman/listinfo/accessd > > > Website: http://www.databaseadvisors.com > > > > _______________________________________________ > > AccessD mailing list > > AccessD at databaseadvisors.com > > http://databaseadvisors.com/mailman/listinfo/accessd > > Website: http://www.databaseadvisors.com > > > > > _______________________________________________ > AccessD mailing list > AccessD at databaseadvisors.com > http://databaseadvisors.com/mailman/listinfo/accessd > Website: http://www.databaseadvisors.com > -------------- next part -------------- A non-text attachment was scrubbed... Name: winmail.dat Type: application/ms-tnef Size: 4044 bytes Desc: not available URL: <http://databaseadvisors.com/pipermail/accessd/attachments/20030821/3348ad6a/attachment-0001.bin>