Sure thing. Give me a few minutes.
From: MS_Access_Professionals@yahoogroups.com
[mailto:MS_Access_Professionals@yahoogroups.com] On Behalf Of
giorgio_rovelli
Sent: Sunday, October 30, 2011 8:11 AM
To: MS_Access_Professionals@yahoogroups.com
Subject: [MS_AccessPros] Re: Opening MS Word from Access
Hi David, could you share the code in
http://tech.groups.yahoo.com/group/MS_Access_Professionals/message/93796
?
Giorgio
--- In MS_Access_Professionals@yahoogroups.com
<mailto:MS_Access_Professionals%40yahoogroups.com> , "David Tolson"
<drtolson@...> wrote:
>
> Crystal, I wonder if the saying "The difference between a man and a boy is
> the price of his toy," is really an axiom, because I must admit, I cannot
> remember being as thrilled over anything as a boy any more than I am when
I
> see a piece of complex code spit out the exact results. It may take some
> time to get to that moment of satisfaction, thanks to all the great
> professionals on this site, but when I do, it is hard to find anything
more
> exciting or rewarding.
>
>
>
> Thank you Crystal. Please have an awesome day too.
>
>
>
> Kind regards,
>
>
>
> David
>
>
>
> From: MS_Access_Professionals@yahoogroups.com
<mailto:MS_Access_Professionals%40yahoogroups.com>
> [mailto:MS_Access_Professionals@yahoogroups.com
<mailto:MS_Access_Professionals%40yahoogroups.com> ] On Behalf Of Crystal
> Sent: Sunday, October 30, 2011 7:04 AM
> To: MS_Access_Professionals@yahoogroups.com
<mailto:MS_Access_Professionals%40yahoogroups.com>
> Subject: Re: [MS_AccessPros] Re: Opening MS Word from Access
>
>
>
>
>
> thanks, David -- always nice to share your happiness about Access ;)
>
> John ... another one ;)
>
> warm regards,
> Crystal
>
> (: have an awesome day :)
>
> ________________________________
> From: David Tolson
>
> Thanks John, that's exactly what was wrong. You are such a blessing to so
> many people.
>
> Have a great day,
>
> David
>
> From:John Viescas
>
> David-
>
> It sounds like you've opened your database Exclusive, so Word can't get in
> to do
> the merge.
>
> John Viescas, author
> Microsoft Office Access 2010 Inside Out
> Microsoft Office Access 2007 Inside Out
> Building Microsoft Access Applications
> Microsoft Office Access 2003 Inside Out
> SQL Queries for Mere Mortals
> http://www.viescas.com/
> (Paris, France)
>
> -----Original Message-----
> From: David
>
> Hi Patrick, Good to type to you again J. When I entered the entire path in
> my code, including the name of the document "\Greetings" , Word open as
did
> the merge letter; however, I received the following error message:
>
> The database has been placed in a state by the user 'Admin' on machine
> 'David's-PC' that prevents it from being opened or locked
>
> And then a "Data Link Properties" dialogue box opened that had 4 tabs, and
> the one that was opened was "Connection." It appears to be giving me an
> opportunity to place the correct user name and password in the appropriate
> fields, but there is a check mark next to "Blank password". The User name
is
> already filled in with "Admin" but my user name for this computer is
David,
> so I tried David and still received the same error.
>
> r/David
>
> From: patrickawood
>
> Hi David,
>
> The CurrentProject.Path gives you the folder in which your database
resides.
> You will have to enter the path in your code or you could using code:
>
> .Documents.Open GetMyDocumentsDir & strMergeLetterName
>
> Function GetMyDocumentsDir() As String
> If gbolErrorTrapOff = False Then On Error GoTo ErrHandle
>
> Dim strValue As String
>
> strValue = Environ("USERPROFILE") & "\My Documents\"
>
> GetMyDocumentsDir = strValue
>
> ExitHere:
> Exit Function
>
> ErrHandle:
> MsgBox "Error " & Err.Number & vbCrLf & Err.Description _
> & vbCrLf & "In procedure GetMyDocumentsDir"
> Resume ExitHere
>
> End Function
>
> Kind Regards,
> Patrick Wood, Access MVP
> Access Easy Tips Blog
> http://accesstips.wordpress.com
> Microsoft Access and SQL Azure Information Center for Developers
> http://gainingaccess.net/SQLAzure/AccessAndSQLAzureInfo.aspx
>
> ---"djsdaddy531" wrote:
> >
> > Great Day, I have a form that produces a mail merge in MS Word, it works
> fine in Windows XP, but I am running Windows 7 now. I get this error when
I
> execute the code:
> >
> > This file could no be found.
> > ("C\...\Greetings")
> >
> >
> > When I click "Debug" from the error message, this is the code that is
> highlighted:
> >
> > .Documents.Open CurrentProject.Path & strMergeLetterName
> >
> > The file is in My Documents, which is where I thought
CurrentProject.Path
> would look.
> >
> > If anyone can straighten me up on this, I would be greatly appreciated.
> >
> > Thanks in advance,
> >
> > David
> >
>
> [Non-text portions of this message have been removed]
>
>
>
>
>
> [Non-text portions of this message have been removed]
>
[Non-text portions of this message have been removed]
Tidak ada komentar:
Posting Komentar