Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations TouchToneTommy on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Recent content by kw2oak

  1. kw2oak

    Want to Execute code and then add more VBA

    Skip Thanks for your request. Unfortunately I cannot post my code as it is back at the office where I am working. In short it is code that establishes the active printer and sets the paper tray from which the user want to use. Where the printer is a Kyocera it has 9 output 'bins' and unless I...
  2. kw2oak

    Want to Execute code and then add more VBA

    I have code that for various reasons has to use the sendKeys function (setting printer settings that are not programmable) and I wish to unset them again using the same method. I have my routine using sendkeys and then using the ApplicationPrintout method (Word) and then use SendKeys to reset...
  3. kw2oak

    Access to Word Automation only works once

    I am firing-up 'word' from Access 2000 using 'automation' with the Get Object instruction. I then add a new document and work with the 'active document' placing field values that I have stored in variable before calling word - this works fine first time and then will not work again until 5 or 6...
  4. kw2oak

    Mail Merge: Not seeing all queries

    I have had a similar experience to this. With XP and Office 2003 If you open word and tick 'Confirm Conversion on Open' when you set-up a mail merge you will be prompted by a dialogue box where you must choose whether you want to use DDE as your connection - if you choose to use DDE then you...
  5. kw2oak

    CANNOT JOIN SYSTEM.MDW

    Thanks for this tip - I suspected a corruption of the MDW but was put-off this by the fact that the 12 PC's already joined appear to work fine. I am visiting the site where this is a problem again next week and I will let you know how I get on
  6. kw2oak

    CANNOT JOIN SYSTEM.MDW

    Thanks for the suggestion. I have made everyone log out of Access and close all windows but still no luck. (There were others using Access when I initially went to each PC and made them 'join' the workgroup, but this appeared not to affect the task.) I do not know whether I should be able to...
  7. kw2oak

    CANNOT JOIN SYSTEM.MDW

    I created a new 'workgroup information file' and joined 12 PC's to it. After changing some workgroup settings I found I could not get other pc's to join, suddenly I started to get 'Access Denied' messages.
  8. kw2oak

    ACT Contacts / Activities

    I am trying to add a new 'Contact' record to an ACT 5.0 database from Access 2k. I can open the database file and I can add a 'contact' record fine. When I try to add a new 'activity' I am successful in adding the entry to the file (I can see the entry if I open the file in Excel) but I cannot...
  9. kw2oak

    run a Word macro and close through Access button

    I have done this before in Access '97 - assume its same in 2K and XP: ObjWord being my word object. objWord.Run MacroName:="ProduceLetter" I am having a related problem to you - I am opening as word doc, filling in some text at a bookmark or two and then I want Word to stay open so...

Part and Inventory Search

Back
Top