Michael R Mattys
michael.mattys at adelphia.net
Thu Aug 21 01:04:25 CDT 2003
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