"2. use the Dim Object varaible to open Word and the file. Hide Word, and close out of the File and Word. My problem here is that i cannot figure out how to run the macro from access once the file is open."
Could you post a sample of how this is done? Much appreciated!!!
I can respond to the first part of the question: Leaving a field blank as opposed to "0" is generally what I like to do. In addition to disk space, you can identify the contents of the field as "null" which is useful in coding & querying.
I have a table in access97 with memo fields that needs to be exported to excel 97. The export works just fine (using the outputto macro) but it cuts off all my memos after about 150 characters (aprox), but my memo fields are usually much longer than this. Is there any way to have the whole...
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.