I am using Microsoft Access 2007 to create a database program for a police department for Incident Reporting. I have included tables such as Incident Information, Subjects involved, Vehicles involved, Evidence involved, Etc. I am new to this and the hardest portion seems to be creating a word processor.
#1 The word processor is needed as opposed to the "memo" function from a table because a report narrative can go on for pages and pages depending on the type and amount involved in a case.
#2 The text would need to remain saved on its parent table just as all the information from the other CATEGORIES will be for future searching and or correction.
I am very green when it comes to programming, I don't have a clue how to write CODE or what an SQL is. I would prefer to be able to use Microsoft Word in the Access application, but at this point any word processor will do. Any help is appreciated.It's not exactly what you asked for, but have you considered using Word and saving the file, then attaching it to the database as an attachment?
I would strongly consider it as long as it could be MODIFIED while in the Access program (even if having to open word through a command button). But it has to be able to save on access for future viewing. Also I have no idea how. I know how to add an OLE object to a table if that is what you are talking about, but then have no clue what to do with that OLE object. I guess I am to inexperienced for this program.What the OP wants is very reasonable and is part of what a database can or should do. A few very long reports should be linked to the database when needed. Otherwise, database records a re to be short to reduce space and to make editing easier. Thee should be a place to link an external document. The ability of linking documents across applications is one of the reasons people choose MS Office.
Here is one possible method that may n work.

how do I attach a ms word document to a ms access record
Hope this helps.Access has a Attachment type, looking quickly at Access 2013. I imagine OLE Object would be similar. It has been some time since I've used Access (and only used it much with Access 2.0) but I would surmise that you could bind the Column for an OLE Object to a OLE Control in a userForm. If you wanted to automatically have it start with a blank document you would have to set the default to an empty word document, Or more likely it would require VBA code in the UserForm- eg. create a new Word Document (doable by setting some properties on the control) when there isn't one present. It would be saved right in the database and the OLE Control on the Userform would present a Word interface and toolbars.

I cant BELIEVE it took this long for a good answer, Thanks to both of you.I believe the best way is to set an attachment in a field, however, The Word Document only appears on the field selected. Is there any way to make all records have a Word Document attachment without having to manually insert it in the datasheet for every record/new record
Quote from: taquecop on March 23, 2014, 02:18:11 AM

I cant believe it took this long for a good answer,