William Hindman
wdhindman at bellsouth.net
Thu Aug 21 06:38:32 CDT 2003
...2002 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: "Stuart Sanders" <stuart at pacific.net.hk> To: "'Access Developers discussion and problem solving'" <accessd at databaseadvisors.com> Sent: Thursday, August 21, 2003 2:52 AM Subject: RE: [AccessD] Select Range of Records ...Word from Access > 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 > > > ---------------------------------------------------------------------------- ---- > _______________________________________________ > AccessD mailing list > AccessD at databaseadvisors.com > http://databaseadvisors.com/mailman/listinfo/accessd > Website: http://www.databaseadvisors.com >