[AccessD] VM for different versions of Access - Resolved for now

Hi Mark,

Yes, I use that in  Access.  Does that function exist in Word?  I didn't 
see it.

The other method I considered using was to craft a concatenated field in 
the query - and there I would use TRIM - and then have that concatenated 
field be the inserted mergefield in the Word document.

Maybe I'll go back and play around with that a little more for my own 
satisfaction.  Thanks for the thought.

Tina

Mark A Matte wrote:
> Just an FYI...
>
>   
>> When that happens, the resulting name line
>> starts with a space. I know, it's a tiny detail, and it can be quickly
>> fixed with a little search and replace action
>>     
>
> I have the same problem in a Label/Envelope database...I use the TRIM function to get rid of the spaces.
>
> Just sharing.
>
> Mark A. Matte
>
>
>   
>> Date: Fri, 4 Apr 2008 11:20:43 -0400
>> From: tinanfields at torchlake.com
>> To: accessd at databaseadvisors.com
>> Subject: Re: [AccessD] VM for different versions of Access - Resolved for now
>>
>> Hi All,
>>
>> In order to just get my client's database functional - not perfected,
>> just functional - so they can record contributions and send out
>> acknowledgement letters, I did install a VM (using VMWare Server) and
>> load it with Win98 (with second edition update), then I installed as
>> much of Office 97 as I needed (Access and Word, essentially). About the
>> only problems I really had with that are: 1) it is slow to work in, 2)
>> the screen resolution is awful, and 3) it won't see my USB ports, so I
>> couldn't use my flash drive or my USB-connected printer (I installed it
>> and had the print feature print to a file, because I just needed to be
>> able to preview my reports, not really print them). For the future, I
>> have to learn a lot more about this virtual machine business.
>>
>> Working in that environment I succeeded in creating a new blank database
>> and importing into it the functional portions of my client's Version9
>> and Version10 databases. The data tables of Version10 were whole and
>> properly related, but many of the forms and reports were corrupted, as
>> well as a few queries. Pulling what worked from each of the database
>> versions I was able to get Version11 to work nicely, and I tested the
>> mail merge Word letter. It works.
>>
>> One nice little extra is that I fixed a detail that bothered me. The
>> form letter had a field for the honorary prefix (Mr., Ms., Dr., etc.)
>> before the field for the first name, which is great except when there is
>> no honorary prefix used. When that happens, the resulting name line
>> starts with a space. I know, it's a tiny detail, and it can be quickly
>> fixed with a little search and replace action, but, I'm very picky!.
>> So, I put in a conditional mergefield, which I knew could be done, but
>> which I hadn't done since Word was a DOS program (yes, I AM that old),
>> and it took me a while to sort it all out, but I got it and it works,
>> and I'm delighted.
>>
>> Next steps with this client include revisiting how they want to use the
>> database - there are features in it that haven't been used since 1999
>> when they moved their accounting to QuickBooks, for instance - and
>> remodeling it. Part of the remodeling will include splitting the
>> database into BE and FE, an area where I have only a little experience
>> so I'll be back for help. Furthermore, I have to put more security
>> measures in place than are there. It is very clear that someone has
>> been fooling around in the database, writing small queries with useful
>> names like Query1, and changing table names (without updating the
>> queries that depend on those tables) - stuff like that. Someone knows
>> enough to get into the database objects, but not enough to keep from
>> doing damage.
>>
>> My friend who built the database back in 1997, took the executive
>> director at his word that nobody would mess with the innards of the
>> database. Ha!
>>
>> Thanks for all the help I received from the members of this list.
>>
>> Tina
>> --
>> AccessD mailing list
>> AccessD at databaseadvisors.com
>> http://databaseadvisors.com/mailman/listinfo/accessd
>> Website: http://www.databaseadvisors.com
>>     
>
> _________________________________________________________________
> Pack up or back up–use SkyDrive to transfer files or keep extra copies. Learn how.
> hthttp://www.windowslive.com/skydrive/overview.html?ocid=TXT_TAGLM_WL_Refresh_skydrive_packup_042008
>