runtime error 5852 requested object is not available Sugar Tree Tennessee


Address 166 W University Pkwy, Jackson, TN 38305
Phone (731) 410-7633
Website Link

runtime error 5852 requested object is not available Sugar Tree, Tennessee

If you plan to perform any functions that require Adobe, it is recommended that you launch a new session of Word. Nothing different than the other times, since the "compared" document is always a new document Word creates. All rights reserved.Unauthorized reproduction or linking forbidden without expressed written permission. Making Objects from Custom HttpModule Available to ASPX Page or ASCX Controls?

Xyberg, Aug 3, 2016 #6 Advertisements Show Ignored Content Want to reply to this thread or ask your own question? In the past I linked my word files directly to the tables and then simply changed the QueryString of the merge file for the particular record I need to create a This other error we are not able to correct in the same manner.Both of the issues stem from the FindRecord,FirstRecord,etc calls to the access database. Can't I sign the macro (with a security certificate)?

Posting Guidelines Promoting, selling, recruiting, coursework and thesis posting is forbidden.Tek-Tips Posting Policies Jobs Jobs from Indeed What: Where: jobs by Link To This Forum! By joining you are opting in to receive e-mail. I appreciate any thoughts. Any Ideas Thanks "Cindy M." wrote: Hi Diane, In Word 2003 (and I thought 2007) opening a Word document using automation unlinked the data source, so no message would appear.

Privacy statement Help us improve MSDN. Go to Solution 5 Comments LVL 76 Overall: Level 76 MS Word 65 VB Script 16 Message Active today Expert Comment by:GrahamSkan2008-06-02 Is this VBScript? I put your code in at two different locations, the very beginning of the code, and again just before the error line. Haven't tried Word 2003.        Set wrdApp = CreateObject("Word.Application")        wrdApp.Documents.Open FileName:=strContractDir & "\" & strDoc, AddToRecentFiles:=False, Visible:=False        wrdApp.Documents(strDoc).Activate        With wrdApp.Documents(strDoc).MailMerge            .DataSource.FirstRecord = 1   Line causes error  (Error 5852: Requested object is not

As a very strong recommendation - never work on code in a word processor or document editor. The time now is 06:51 AM. - Contact Us - Microsoft Word Forum WordBanter forum home - FAQ - Links - Privacy Statement - Top Powered by vBulletin Version 3.6.4Copyright ©2000 It opens the merge document but doesn't complete the merge. I'll report back!

Post your question and get tips & solutions from a community of 418,639 IT Pros & Developers. PC Review Home Newsgroups > Microsoft Access > Microsoft Access Forms > Home Home Quick Links Search Forums Recent Posts Forums Forums Quick Links Search Forums Recent Posts Articles Articles Quick Please reply to the newsgroup unless you wish to avail yourself of my services on a paid consulting basis. RE: Runtime error 5852 during Access-Word mail merge Creosote65 (TechnicalUser) (OP) 19 Apr 05 11:58 Hi JoyInOK,The register edit that you referenced is exactly what is needed to resolve the error.

Any help would be greatly appreciated. Thomas Staudte Mailmerge 8 December 13th 05 05:35 AM Word 97 in Windows XP to maintain formatting Charlie''s Word VBA questions Microsoft Word Help 21 October 24th 05 09:49 PM Date Talk With Other Members Be Notified Of ResponsesTo Your Posts Keyword Search One-Click Access To YourFavorite Forums Automated SignaturesOn Your Posts Best Of All, It's Free! Click Here to join Tek-Tips and talk with other members!

Thanks again for your help. Can you post your final code for others to see? First Name Please enter a first name Last Name Please enter a last name Email We will never share this with anyone. Requested object is >not available' message when I use Access 2003 to send data to a word >(2003) mailmerge document. > >Prior to going over to Office 2003 we have not

Next by Date: macro to delete parts of the document Previous by thread: Re: Event bubbling in forms? I will assume then that it also lost it's SQL query? Next by thread: macro to delete parts of the document Index(es): Date Thread Flag as inappropriate (AWS) Windows Science Usenet ArchiveAboutPrivacyImprint >Archive >Word >microsoft.public.word.vba.general >2008-09 United States English English IBM® Yes, we're running Word XP, 2003 and 2007 - MS even shows registry edits for 2002, 2003, and 2007.

This behavior is not known to have any adverse effect aside from the error being displayed and the user having to acknowledge the dialog. Here is a sample of the code I used in the past. ************************************************** ***************** Private Sub Command0_Click() Dim w As Word.Application Dim m As MailMerge Dim mm As MailMergeDataSource Dim d Registration on or use of this site constitutes acceptance of our Privacy Policy. The default value No is used.

In both cases it was blank ... lambic06-22-2006, 01:00 AMHi, Thanks for the reply. That being the case, from the Tools menu in Word, select Options and then go to the General tab and check the box against "Confirm conversions at open." After you do Doug Robbins - Word MVP wrote in message

no value, no zero ... Here's Why Members Love Tek-Tips Forums: Talk To Other Members Notification Of Responses To Questions Favorite Forums One Click Access Keyword Search Of All Posts, And More... Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework. Advanced Search VBForums Visual Basic Office Development Urgent: "Requested object is not available." If this is your first visit, be sure to check out the FAQ by clicking the link above.

Suggested Solutions Title # Comments Views Activity Trying to populate a summary worksheet in excel from another worksheet 14 70 48d Appending Access Queries to Excel Sheet 7 39 50d Userform, We recently converted to Office XP (2002) and I now have an issue I am unfamilliar with and have been unable to resolve. Steele Oct 21, 2006 Error:execution of this application has stopped due to a run-time error Sandy H, Jun 22, 2009, in forum: Microsoft Access Forms Replies: 1 Views: 2,394 Clifford Bass Mo, Aug 23, 2006 #3 Mo Guest OK John, it's sorted.

I appreciate any thoughts. Copyright 2004-2016 Microsoft Office Word Forum - WordBanter. even so, you need declare the constant, wdsendtonewdocument or replace it with the zero value, Odoc.MailMerge.Destination = 0 or const wdsendtonewdocument = 0 as currently it is doing nothing i do Requested object is not available' message when I use Access 2003 to send data to a word (2003) mailmerge document.

Close Box Join Tek-Tips Today! The best place to get assistance is the Mail Merge newsgroup, where you'll find people who specialize in this kind of thing. But keep this in mind. 1) This same code, works flawlessly on "Computer A". If you replace these characters with single quotes then you should get past this problem.