If you can get Access to treat your Word document as either a delimited file or as a set of fixed-width fields permitting you to capture the information you want, you should be able to write the field containing the information into your database. For example, if your form letter starts out...
How are you doing the subtraction? What version of Access are you using? I experimented with a make-table query in Access 2000. I just subtracted a number from the date (ie. [datefield]-3) and used IIF conditions based on a text field and a logical field, including the possibility of null...
I have a similar problem and have found the string functions, left, mid and right, helpful in writing an Access query that will read different segments of the array (extent) field from Progress.
There is a tutorial at http://www.progress.com/v9/documentation/getstart/ltu/ltu.pdf that I am just beginning to use. It is clearly wirtten and provides examples and exercises. My company uses Rexpert, a healthcare database written in Progress. We own the source code and want to learn Progress...
We recently started using Veritas when we upgraded our servers from NT 4 to Windows 2000, and I am just beginning to learn about it, but our setup includes something called Open File Option (OFO), and having a file open doesn't necessarily result in a failure message. Maybe someone who is more...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.