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!

Search results for query: *

  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