Stuart McLachlan
stuart at lexacorp.com.pg
Mon Jun 6 20:00:24 CDT 2011
You can only use Export Specs with the built in Export Functions, with all of their inherent limitations. We are talking about writing your own complex formatted text files with Print# and formatted strings. -- Stuart On 6 Jun 2011 at 17:00, Charlotte Foust wrote: > Isn't this reinventing the wheel? An export spec should accomplish > the same thing without having to process each value inidividually. > > Charlotte Foust > > On Mon, Jun 6, 2011 at 4:52 PM, Debbie <delam at zyterra.com> wrote: > > > When I needed to do this, I made a function that i passed the string > > and the number of total chars needed. It would loop through until > > the length was the number of chars and would add a space ( or in my > > case a 0) to the beginning of the string. > > > > Debbie > > > > Sent from my iPhone > > > > On Jun 6, 2011, at 4:12 PM, "Brad Marks" <BradM at blackforestltd.com> > > wrote: > > > > We are using Access 2007 to create an output file for another firm. > >> > >> The specs for this file are dictated by the other firm. > >> > >> The specs call for numeric fields to be right justified and padded > >> with spaces on the left. > >> > >> What is the best way to do this with Access 2007? > >> > >> Thanks, > >> Brad > >> > >> -- > >> 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 >