Hi Adam,
if you are running 2010 with Access but have later versions installed, those libraries will be used unless you specifically reference lower versions with early binding (use BROWSE -- for Excel, use the Excel.exe file, probably same for Outlook). I believe that you have to use the same version of Excel and other Office apps with automation that Access is running
warm regards,
crystal
Code Documenter for Access, Excel, Word, and PowerPoint
http://www.AccessMVP.com/strive4peace/CodeDocumenter.htm
~ have an awesome day ~
Crystal and Gina,
I'm not sure what you mean by trusting "everything."
What references should I have checked? Amongst the ones I have checked:
Microsoft Access 14.0 Object Library
Microsoft Office 15.0 access database Engine Object
Microsoft Outlook 15.0 Object Library
Microsoft Excel 15.0 Object Library
I do have both 2010 and 2013 versions of Excel, Word, Powerpoint, etc. I only have 2010 for Access. I only have the new version of Outlook.
Possibly related, the E-mail icon, under the External tab, is grayed out, even when I have a table open.
I found this on another forum, that talks about whether Access or Outlook is being run with admin privileges - see this thread http://www.access-programmers.co.uk/forums/showthread.php?t=281087It's not. I don't have admin privileges, so I rely on IT tech support to try this. It didn't work the first time we tried this, but may not have done it right.
Adam
Adam, I just looked up your original post.
"It is a trusted document. It worked before the upgrade to Office365.
This seems to happen just when I have code trying to send, or when
trying to save an Excel file. In the latter case, the code I have
manipulating the Excel file before the save works. The rest of the code
seems to work."
"I don't understand what it is about trusting that would just make those
lines of code not work?"
Are you sure you are allowing everything?
warm regards,
crystal
Access Defaults ... take a tour ... (cc)
https://www.youtube.com/watch?v=CF9n0B3MU_w
- Trust Center Settings and other Access defaults you can set
~ have an awesome day ~
On 9/21/2015 11:05 AM, crystal 8 wrote:
> Gina, you might have hit on something with References ...
>
> Adam, do you have multiple versions installed?
>
> When I was running multiple versions, I had to use early binding and
> navigate to the libraries specifically since only the latest was
> offered in the dialog box. For Excel, use the Excel.exe file
>
> warm regards,
> crystal
>
> GetDistance Function for Latitudes and Longitudes
> http://www.rogersaccesslibrary.com/forum/getdistance-function-for-latitudes-and-longitudes_topic604.html
>
>
> ~ have an awesome day ~
>
>
> On 9/21/2015 10:36 AM, gina@... [MS_Access_Professionals]
> wrote:
>> Just peeking in…
>>
>>
>> Check your References, might be you used Early Binding and now some
>> might be *MISSING*. For some help see…
>>
>>
>> http://www.access-diva.com/d5.html
>>
>>
>> If nothing jumps out at you please post the References you have
>> checked here.
>>
>>
>>
>> Gina Whipp
>> Microsoft MVP (Access)
>>
>> <http://www.access-diva.com/> access-diva
>>
>> Specializing in Microsoft© Access® Solutions
>>
>>
>> From: MS_Access_Professionals@yahoogroups.com
>> [mailto:MS_Access_Professionals@yahoogroups.com]
>> Sent: Monday, September 21, 2015 12:26 PM
>> To: MS_Access_Professionals@yahoogroups.com
>> Subject: [MS_AccessPros] Re: Errors after update to Office365
>>
>>
>>
>> Crystal, and other MVPs,
>>
>>
>> Any other ideas?
>>
>>
>> Adam
>>
>>
>>
>>
>>
>> [Non-text portions of this message have been removed]
>>
>>
>>
>> ------------------------------------
>> Posted by: <gina@...>
>> ------------------------------------
>>
>>
>> ------------------------------------
>>
>> Yahoo Groups Links
>>
>>
>>
>
Posted by: crystal 8 <strive4peace2008@yahoo.com>
| Reply via web post | • | Reply to sender | • | Reply to group | • | Start a New Topic | • | Messages in this topic (11) |
Tidak ada komentar:
Posting Komentar