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!

Register Log in
  • Congratulations Chris Miller 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. cablass

    Error handling: Document is locked for editing, MSAccess

    I think the problem with Word loading is, it isn't actually an error, unless I close word and the rest of the code can't execute. It will happily create a read-only copy, in this case no error occurs. I've acted on your advice - and added a more appropriate message (my headache's gone now!)...
  2. cablass

    Error handling: Document is locked for editing, MSAccess

    Thanks, I'll try that :o)
  3. cablass

    Error handling: Document is locked for editing, MSAccess

    Oops. Actually my error handler does prevent the user accessing the code. However a msgBox warning the user the document is locked still appears, how can I disable this & show my 'headache' msgbox first?
  4. cablass

    Error handling: Document is locked for editing, MSAccess

    I have a mail merge procedure based on bookmarked templates. I have added an error routine: On Error Goto cmdSendLetter_Click_Error **Procedure** Exit Sub cmdSendLetter_Click_Error: msgBox ("I'm sorry I have a headache right now" & Chr(13) _ "Please try again later, I may be feeling...
  5. cablass

    Access Mail Merge without OpenDataSource Curr Record only

    I was having difficulty with OpenDataSource when trying to mail merge from Access to Word. Also I only wanted to merge the current record. I got round it thanks to a post by Benoit Mann on Blue Claw Database Design. Go to http://www.blueclaw-db.com/mail-merge-bookmarks.htm to view the original...

Part and Inventory Search

Back
Top