OK, Dreamboat did as you said but I get this error message everytime Word opens:
"Run time error 91.
Object variable or With block variable not set"
What is wrong with your code statement that causes this error? I've done a lot of VBA coding but only in Access and I am not...
Dreamboat, I tried to follow your instructions but they are incomplete. 1. I don't see on the left side of the code window any reference to Normal.dot. How do I click on Normal.dot when it is not present? 2. When I exit Word it prompts me for a name to save Document1 under. If I save the...
Well, I solved the problem by re-installing Word. I did this before I read any of the above solutions. But I like Dreamboat's solution, and I will use it so that the problem doesn't reoccur. Thanks all.
I agree with Culshaw. I use several tables which I download from our mainframe. I do not set a primary key (reason is too lengthy of an explanation) on my tables and everything I do with them works fine. Like Mr. Culshaw says, a primary key speeds up searchs and makes each record unique. If...
Make Normal View default view when opening documents. Whenever I open a new document in Word 97, the doc always opens in Page Layout view. How can I make Word open docs in Normal view?
Paul7905: There is another method but it is not too pretty. You could create a subform, and it that subform display the results of a query (or perhaps create a recordset) of all the records the user wants to see. This way the user would be able to use the scroll bar on the right side to move...
njb: The only way I've figured out how to do this is to copy the entire .mdb that contains the import specs to a different drive, folder, or whatever. Then I rename the .mdb and delete the tables, queries, etc. I don't want in the new .mdb. You can now use the import specs to import text...
I have a similar problem in one of my programs. Each month I create a recordset of payments. All the amounts are stored as positive numbers but are identified by a code that designates them as either debits or credits. I created a function that reads every record in the recordset and if the...
PSchiele,<br>
<br>
OK, I found the Options buttom. But using this only works if you are going from one Access database to another Access database. When you import text files you don't get the Options button. <br>
<br>
I have import specifications for 5 text files that I import into Access...
Hi Al,<br>
<br>
I'm sorry but there is no Options button in the Import dialog box. At least there isn't in my version of Access 97. I know where the Import/Export Specs are cause I use them all the time but there is no Options button. I have the Import dialog box open as I type this and there...
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.