Re: Report Template and Access (Big Task)

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

We would need to know a lot more about your requirements to give specific
advice, but see the following page of fellow MVP Greg Maxey's website:

http://gregmaxey.mvps.org/Extract_Form_Data.htm



--
Hope this helps.

Please reply to the newsgroup unless you wish to avail yourself of my
services on a paid consulting basis.

Doug Robbins - Word MVP

"Eric" <Eric@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:DE7710D5-C8CF-4B9A-9D56-DD9CC9B9AEBE@xxxxxxxxxxxxxxxx
Hi all, I have read almost all posts in these Discussion Groups and still
can't get a handle on what I'm doing. I now have a great library of
favorites to use in the future but still need some advice.

I am developing a template for our agency. The goal is to standardize our
formal reports and also capture specific elements of the reports for use
in
an access database. These reports can be as large as 100 pages sometimes.
The Template will actually be the final report and needs to be formal.

I have protected sections and non protected sections, form fields and
tables
etc. But exporting the data to .txt seems to be an issue and I am
questioning my approach.

1. Exporting the fields are not a problem. Except if the user has to add
an additional field. The new field does not have a name, or takes on a
generic (Text1) name. This creates an export and database issue.
2. If I use tables then the "convert tables to text" can be a huge task
doing them individually. Plus tables want the first row as labels and
that
really doesn't' work with the formatting I'm trying to maintain.
3. Form fields seem to be the best way to go, except in a protected
document the user looses all the formatting flexibility; underlining,
bullets
etc.

Capturing the data in these reports is just as important as the report
itself. The protection of the document is vital because of the
possibility
of fields being deleted etc.

Does anyone have a better approach then any of the ones I have mentioned?
Maybe a combination of methods? I really don't know.

I appreciate any and all comments, best wishes and prayers.

LOL

Thanks
--
Rookie



.

Relevant Pages

  • Re: Unhandled exceptions during report outputs to snapshot files
    ... spike protection. ... you wrote, "3) For whatever reason, my database is VERY ... lost 2 hard drives within a short period of time and my son ... Regarding your first comment about number of reports: ...
    (microsoft.public.access.reports)
  • Re: If Ebay werent run by a bunch of crooks.....
    ... the best bit of protection is to use the U.S. Mail to send a postal ... money order for items...that protects both legitimate buyers and sellers ... personally have file two mail fraud reports and BOTH were resolved AND I ...
    (rec.photo.digital)
  • Re: Report Template and Access (Big Task)
    ... Eric the Rookie ... Please reply to the newsgroup unless you wish to avail yourself of my ... formal reports and also capture specific elements of the reports for ... The protection of the document is vital because of the ...
    (microsoft.public.word.vba.general)
  • Re: Report Template and Access (Big Task)
    ... Template, How can I run a macro that would name those 4 new fields? ... formal reports and also capture specific elements of the reports for ... really doesn't' work with the formatting I'm trying to maintain. ... The protection of the document is vital because of the ...
    (microsoft.public.word.vba.general)