 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWordDirectoryUser Groups Related Topics Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ... |
MS Office Forum / Word / Programming / May 2008Word + Access DB + need Help
Hi, I should write a Data Base application. but the problem is the data entry of this database. I have a word document which contains the data that must be put into the field of this database. Imagine I have a document which has some signs to recognize which paragraph must be put in which field of the database. for example my db has 2 fields. Paragraphs starting with # must be put in field1, and paragraphs starting with ~ character must be put in field 2 of my db. I would like to write a program to do this work for me and by the way every paragraph may contains some formulas or Images(small size) in it. by the way, my DataBase is MS Access, and I use delphi to write program. Is it possible? what method do you suggest? I would be greatly happy for each comments, tips that guides me. -Thanks in advance The Word object model has a paragraph object; I think it is a range but you can find it very easily in the documentation. So I assume you can just read each paragraph form beginning to end. Note that your definition of a paragraph might not be the same as Word's definition so you need to do a little analysis. You don't explain the relevance of the formulas and images. More specifically, you do not specify whether they need to be ignored or included in the database. > Hi, > I should write a Data Base application. but the problem is the data entry [quoted text clipped - 16 lines] > > -Thanks in advance Thank you for your reply. The formulas and Images should be included in the database. in fact my document contains chemistry questions with answers of that questions. questions starting with # and answer of that question in the next paragraph starting with ~ character. I want to write an application to take a test from the user. so I thought I should firstly convert these document to a database, then I'll use them in my application. the position of the formulas or the images in the text is important to me. because afterwards I want to read them from database and show them to the user. so during transferring paragraphs from document to the database and during reading database and showing the information in my application, the position of these formulas should not be changed. In Access should I select Ole for the type of the fields? would you please give me a link to the necessary documentation? I'm newbie to this subject. -Thanks a gain I can't help much so I hope someone with more experience will also help. It might be possible to have an Access field for OLE-style objects. Look at the Access documentation; it should be possible to answer this question with a quick look at the documentation. Or you can simply look at what types are available in the drop-down box of available types when we create a database field. There might also be a type for RTF data and it is probably possible to convert the Word paragraphs to a RTF format. There might also be a type for HTML data and it is probably possible to convert the Word paragraphs to a HTML format. Both RTF and HTML can be stored as plain text so that is an alternative (last-resort) possibility. > Thank you for your reply. > The formulas and Images should be included in the database. in fact my [quoted text clipped - 16 lines] > > -Thanks a gain You are really jumping in at the deep end. You will find some information about moving data from Word to Access in the last of the articles at: http://www.mousetrax.com/techpage.html#autoforms The folks over in microsoft.public.access newsgroups can probably offer you more advice on the OLE field question. At this point however, not knowing any more about your "application" and how you intend to make use of the data if you had it in Access, I could not be certain that it is even the way that you should be going. Maybe just a two column table in a Word document with the questions in the first column and the answers in the second column might be a far simpler approach.  SignatureHope 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 > Thank you for your reply. > The formulas and Images should be included in the database. in fact my [quoted text clipped - 16 lines] > > -Thanks a gain Besides the other thoughts... It would be very important to know which versions of Office you're targeting... Cindy Meister INTER-Solutions, Switzerland http://homepage.swissonline.ch/cindymeister (last update Jun 17 2005) http://www.word.mvps.org This reply is posted in the Newsgroup; please post any follow question or reply in the newsgroup and not by e-mail :-) |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.