ACCESS FEED: RE: [MS_AccessPros] Re: Errors after update to Office365

Senin, 21 September 2015

RE: [MS_AccessPros] Re: Errors after update to Office365

Hmm, does seem like a Early Binding issue. What are the rest of the References you have checked? I would also suggest you switch to Late Binding which should take care of the issues with Outlook and Excel. See…

http://www.granite.ab.ca/access/latebinding.htm

Gina Whipp

From: MS_Access_Professionals@yahoogroups.com [mailto:MS_Access_Professionals@yahoogroups.com]
Sent: Monday, September 21, 2015 3:49 PM
To: MS_Access_Professionals@yahoogroups.com
Subject: [MS_AccessPros] Re: Errors after update to Office365

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=281087

It'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

---In MS_Access_Professionals@yahoogroups.com, <strive4peace2008@...> wrote :

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
>>
>>
>>
>