Microsoft Access Grammar example .mdb

Posted on 2011-10-27
Last Modified: 2013-11-28
I have a continuous form that has a memo field.  On double click of this field, another form opens and the memo fields text from the first form transfers to a memo field on the second form.  

My users currently have the option to spell check and modify the second form's field text and then close that form, transferring the updated text back to the orginal control.  The second form also allows them to have a larger area to edit from.

I want to be able to grammar check the field as well.  I know how to use the embedded OLE word doc object to grammar check text that I type in it.

Ideally, I would like to be able to do the grammar check without it looking like word was being used at all.  I can see how this could be done, but I am a cut and paste programmer (I use the term Programmer very loosely here) and I know it will take me forever to get it working properly.  

I've seen several coding examples of how to potentially accomplish this, but never a working product.  

Does anyone have a working example .mdb to check grammar in access in this fashion?  It's just so much easier to be able to troubleshoot how I'm coding if I can see how it actually works in other's examples.

BTW, my office is currently using Access 2003.  They spoil us ( :

Question by:whiteshua
    LVL 9

    Expert Comment

    Have a look at this article, with one possible method:

    Author Comment

    Thank you for your reply, but that is what I meant by,

     "I know how to use the embedded OLE word doc object to grammar check text that I type in it."

    What I'm trying to do though, is to use that embedded word doc as the place where the original memo field control's text is transferred to, do all the checks there, then transfer that updated text back to the original control, and clearing out the text in the word doc(at least on reopen of the pop up form, if not on close), so I'm not using more than one embedded word object in the database to do grammar checking.  

    I think my problem has more to do with not being able to figure out how to transfer the text between the memo field and the word object, then back again.  I've tried to use Robdogg888's example that he made I think for VB6 in another forum, but it has yet to work properly for me.  

    Unfortunately, I won't be able to post the code I have for this currently until later, if a solution hasn't been posted by then.

    However it ends up, when I get a streamlined working example, I'm going to post it.  I've searched everywhere for a good example, and somehow this is one of those things that several people have had a hard time getting to work, but no one posts working example .mdbs.

    Thank you again for your response ( :

    LVL 74

    Expert Comment

    by:Jeffrey Coachman
    Access is a database.
    Grammar check is a word processing function.

    If it were me, I would either grammar check the text in Word, then transfer it to Access, or not worry about it at all.

    This is the reason why it has always been debated as whether or not a database should even be concerned about Word processing issues like spell check or Grammar.

    As you know, there are "Dozens" of grammar setting and styles.
    Which one will you uses?
    What is right?, what is wrong?

    Again, the database stores and manages the data.

    Doing things like swapping the data back and forth  to grammar check text, just seems like something that is not worth the hassle.
    This is the reason why Grammar check is not directly available in MS Access
    There is no Grammar check in MS SQL Server, Oracle or MySQL either...

    IMHO, if Grammar check is a MUST, then leave the data in Word, and use OLE to link, display, and edit the data.

    Again, just my 2c.



    Accepted Solution


    Thanks for the help everyone.  

    I figured out how to do it in a slightly different, mixed and matched sort of way.

    I've attached an Access 2003 .mdb as an example and to hopefully get everyone's thoughts on how i could get it to function better or properly.  As I said in my original post, I'm a cut and paste VBA programmer, that is, I make things work, but I am far from a professional.  Please feel free to rip my approach apart, I welcome the learning ( :

    Thanks again

    Author Closing Comment

    I provided the solution for my own question, however, I was also looking for the experts to point out the flaws in my design as I know there are some that need fixing, which unfortunately didn't happen.

    Featured Post

    6 Surprising Benefits of Threat Intelligence

    All sorts of threat intelligence is available on the web. Intelligence you can learn from, and use to anticipate and prepare for future attacks.

    Join & Write a Comment

    Overview: This article:       (a) explains one principle method to cross-reference invoice items in Quickbooks®       (b) explores the reasons one might need to cross-reference invoice items       (c) provides a sample process for creating a M…
    I see at least one EE question a week that pertains to using temporary tables in MS Access.  But surprisingly, I was unable to find a single article devoted solely to this topic. I don’t intend to describe all of the uses of temporary tables in t…
    In Microsoft Access, learn different ways of passing a string value within a string argument. Also learn what a “Type Mis-match” error is about.
    This Micro Tutorial well show you how to find and replace special characters in Microsoft Word. This is similar to carriage returns to convert columns of values from Microsoft Excel into comma separated lists.

    754 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    24 Experts available now in Live!

    Get 1:1 Help Now