Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
Discussion GroupsFormsForms ProgrammingQueriesModules / DAO / VBAReports / PrintingMacrosDatabase DesignSecurityConversionImporting / LinkingSQL Server / ADPMultiuser / NetworkingReplicationSetup / ConfigurationDeveloper ToolkitsActiveX ControlsNew UsersGeneral 1General 2
Access DirectoryToolsTutorialsUser Groups
Related Topics
SQL ServerOther DB ProductsMS OfficeMore Topics ...

MS Access Forum / General 2 / May 2008

Tip: Looking for answers? Try searching our database.

word with formulas in my application

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
LittleBird - 20 May 2008 17:25 GMT
:)
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. I should write a program to write
certain lines of this doc into the fields of my access database. by the way
my doc contains formulas and images. is it feasible?
I thought if it's not feasible, I'll forget about the database and
communicate with the document directly. I mean,for example,  just read from
lines 4 to 9 and then directly put this lines to my application forms(with
all the containing formulas, images and  formating,..), and don't use any
database.
which way is feasible? what method do you suggest? I would be greatly happy
for each comments, tips that  guieds me.
-Thanks in advance
Wayne-I-M - 20 May 2008 18:43 GMT
Hi

I don't think it's possible.

If you were to copy the data from a doc how would your access db know which
bit to copy or import.  You could specify line numbers but this is a variable
(by nothing more than page size or printer selection).  You could use the
word count option in word to specify the variable (but - you would need a
word macro for this)

I think, in this case, its just a matter of cut-n-paste into your new fields
in the new access database.  Or, create the DB and (if the doc is not too
long) then type the "stuff" in.  If you are looking a pictures as well as
text then you could drag those in with file import BUT you would be much
better leaving them where they are and inserting the path to the file rather
than the picture or the DB will get very big very fast.

Sorry - just a cut-n-paste or lots of typeing

Signature

Wayne
Manchester, England.

> :)
> I should write a Data Base application. but the problem is the data entry of
[quoted text clipped - 10 lines]
> for each comments, tips that  guieds me.
> -Thanks in advance
LittleBird - 23 May 2008 08:57 GMT
Wayne,
Thank you for your answer, but I think I didn't explained it well.
I can put some sign in my document.
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 # character 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 in it. Is it possible? If it is possible,
please let me know whats the appropriate function to do this?

-Thanks in Advance...

Rate this thread:






 
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.