Dennis, Your answers make a lot of sense. Thanks for the advice.
James T --- Dennis Jensen <[EMAIL PROTECTED]> wrote: > 1) To Append or Overwrite that is the question. > > This depends on whether you need to reference he > older > data or not. As well as how frequently you plan on > backing up your database. If you have a good back > system for the database then overwrite (or delete > and > add) coupled with a compact will keep the database > smaller. If you not planning on storing a lot of > data > then Append is quicker and simplier. > > 2) To Use a Report or export to Word which is > better. > > If you want to keep it very simple go with the > Report. > If you want to get to know the mechanics behind > exporting to a Word document for possible other > projects then I'd go that route or if you need to > keep > an easily viewable electronic copy of the report on > file for some reason. > > 3) How much VBA and/or SQL would be involved. > > Not sure how to answer this one... my biggest > problem > here is I'm a VB programmer and I'd probably do > nearly > all of it in VBA/SQL since that would allow it to be > much more portable for when this small critter > eventually turns into a large monster and they need > to > migrate it to a SQL Server or if I want to be able > to > reuse code segments for other jobs later on down the > road. Short Term solution the smallest amount of > VBA/SQL will do the job... Long Term solution the > more > VBA/SQL you use the easier it is to maintain, > enhance > and to port. > > Hope that was helpful. > > > > > __________________________________________________ > Do You Yahoo!? > Tired of spam? Yahoo! Mail has the best spam > protection around > http://mail.yahoo.com > __________________________________________________ Do You Yahoo!? Tired of spam? Yahoo! Mail has the best spam protection around http://mail.yahoo.com Yahoo! Groups Links <*> To visit your group on the web, go to: http://groups.yahoo.com/group/AccessVBACentral/ <*> To unsubscribe from this group, send an email to: [EMAIL PROTECTED] <*> Your use of Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/
