Need to upgrade - 2002 or 2003?

[Stephan Golux]

It seems I have run afoul of an unfixable and acknowledged bug in my
beloved access 97 which has no workaround other than to upgrade.

Current supported upgrades are 2002 and 2003.

2003 appears to use lots 'o system resources, so I am wondering if I am
best to go with the older (2002) version.

Any opinions out here? In particular, which version more likely to make
the conversion of the 97 databases the least painful? Both upgrades
cost the same...

Thanks for any thoughts.

[Lyle Fairfield]

Stephan Golux <st*****@nospam .com.goluxstudi o.invalid> wrote in
news:j%******** ********@newsre ad2.news.atl.ea rthlink.net:

First off, let me say your points are great, and welcome. Just to
specify:

Lyle Fairfield wrote:

I can't imagine buying a new version of Access just to address this
problem.

Let's suppose the KB article you cite is correct (they aren't correct
very often but we always have to allow for that possibility). Surely it
would be simple enough to remove double hard returns from the memo
field in the AfterUpdate event of the form where the data are entered,
or in a clean-up type query run before the report is generated.

The problem is that the application in question is for people who WANT
that double hard return in the field, and want it to be propagated
appropriately. So removing them is not an option!

But, of course, the KB article may be wrong, or not pertinent to your
problem. It's not wonderfully difficult to create a MS-Word file that
contains fields, to fill these fields from MS-Access (I prefer to have
the MS-Word file look for a text file where its field entries reside,
and to create that text file from MS-Access, (automation is another
route), and to send that MS-Word file, or those MS-Word files to
whomever, however. And MS- Access Files can look much better than RTF
files, which are quite limited.

Hmmm... this is an interesting idea, but I would love to pick your
brains for how to apply it in my case.

Basically this application is used by stage managers and directors and
assistant directors in theatre and film who need to create work notes
that are then sent via email or fax to the people who need them.

Essentially, the user types in the notes, and assignes any given note to
any given number of roles, where any number of people may be affiliated
with a given role. Then, once the notes are entered, the user hits a
dingle "distribute " button, and reports are generated for each
individual person, broken down by roles, and then emailed or faxed to
each person automatically. There could be several hundred people and
several hundred roles.

Do you see a way to automate something like this using MS-Word in the
way you describe? I feel like the driving engine needs to be Access in
this case, but perhaps you have experience that would allow me to do
something smarter and cleverer.

Before you embrace MS-Word, perhaps you should consider Don's suggestion.

--
Lyle
(for e-mail refer to http://ffdba.com/contacts.htm)

[Stephan Golux]

As I said to Don - I need to be able to distribute to non-MS platforms -
and I don't think the snapshot viewer works there...

-s

Lyle Fairfield wrote:

Before you embrace MS-Word, perhaps you should consider Don's suggestion.

[David W. Fenton]

Lyle Fairfield <Mi************ @Invalid.Com> wrote in
news:Xn******** ***********@130 .133.1.4:

Software becomes obsolete very quickly. Why start out that way?

Since the major premise is laughably untrue, the minor premise is
also false.

Software does not become obsolete very quickly. *Some* software
does, but not versions of Access.

And I long ago abandoned any thought of RTF export for anything but
the simplest purposes because it mostly produces entirely
unacceptable results.

--
David W. Fenton http://www.bway.net/~dfenton
dfenton at bway dot net http://www.bway.net/~dfassoc

[David W. Fenton]

Stephan Golux <st*****@nospam .com.goluxstudi o.invalid> wrote in
news:GZ******** ********@newsre ad2.news.atl.ea rthlink.net:

a very creative idea, and many thanks for it. Unfortunately,
to the best of my knowledge this viewer is not available for the
macintosh or for linux. RTF files can be viewed on all those
various machines.

What about PDF files?

I created PDF files with pdf995 (pdf995.com), which is a printer
driver wrapped around GhostScript. The results are great, and I
gladly view the web page advertisement that pops up every time I
print.

I'm sure there are PDF writers that can be programmed from VB/VBA,
so if you need something more integrated, that's another approach.

Yet another is to write the file with Word using automation and
then, in Word, save as RTF.

But if all you're really looking for is cross-platform non-editable
distribution, I'd say PDF is the way to go.

--
David W. Fenton http://www.bway.net/~dfenton
dfenton at bway dot net http://www.bway.net/~dfassoc

[David W. Fenton]

Stephan Golux <st*****@nospam .com.goluxstudi o.invalid> wrote in
news:j%******** ********@newsre ad2.news.atl.ea rthlink.net:

Do you see a way to automate something like this using MS-Word in
the way you describe? I feel like the driving engine needs to be
Access in this case, but perhaps you have experience that would
allow me to do something smarter and cleverer.

Have you looked at Albert Kallal's WordMerge sample database?

http://www.attcanada.net/~kallal.msn.../msaccess.html

(scroll down to " Super Easy Word Merge")

This basically does what Lyle described.

Based on your circumstances, and assuming Word is installed on all
users' PCs, I'd definitely use that instead of RTF.

--
David W. Fenton http://www.bway.net/~dfenton
dfenton at bway dot net http://www.bway.net/~dfassoc

[David W. Fenton]

Stephan Golux <st*****@nospam .com.goluxstudi o.invalid> wrote in
news:B_******** ********@newsre ad2.news.atl.ea rthlink.net:

I need to be able to distribute to non-MS platforms

There's always PDF, and I'd guess it's possible to do this without
having to install a PDF printer driver on everyone's PC. But so far
as I can see, it does require a licensed ActiveX control on the PC,
so you're introducing an additional dependency.

If you've got Word installed, I'd go with Albert's method and then
automate Word to save the result as RTF.

--
David W. Fenton http://www.bway.net/~dfenton
dfenton at bway dot net http://www.bway.net/~dfassoc

[Stephan Golux]

I can't keep up with all the people I need to thank for many good ideas,
so please consider yourselves all thanked.

Not that I want to stop them coming!

Seriously, very helpful. Much appreciated.

[tom]

how about printing these reports to a PDF printer and distributing
them in that format?

[Stephan Golux]

I've considered this, but am unsure how to automate it... all PDF
printer drivers I have tested stop with a dialog box to ask for the file
name. If you know one that is totally seamless, let me know, it might
work great...

-s

tom wrote:

how about printing these reports to a PDF printer and distributing
them in that format?

[Tony Toews]

Stephan Golux <st*****@nospam .com.goluxstudi o.invalid> wrote:

I've considered this, but am unsure how to automate it... all PDF
printer drivers I have tested stop with a dialog box to ask for the file
name. If you know one that is totally seamless, let me know, it might
work great...

Not specifically but there's got to be a solution somewhere at one of the links at
Creating PDF files from within Microsoft Access
http://www.granite.ab.ca/access/pdffiles.htm

Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm