• RickNTA
  • NEWBIE
  • 25 Points
  • Member since 2005

  • Chatter
    Feed
  • 1
    Best Answers
  • 0
    Likes Received
  • 0
    Likes Given
  • 7
    Questions
  • 41
    Replies

I would like to use the Office Toolkit (which I have installed) with MS Access.  However, when I open Access, I cannot see where to connect to Salesforce.  When I open Word, I have a Salesforce menu --- but nothing in Access.  I do not have the ODBC driver.

 

Any ideas?

 

Thanks!

Barb

  • April 30, 2010
  • Like
  • 0

Does anyone know if there's any way to do this? As far as I can tell it's impossible to override a custom object tab with a functional page (i.e., one with a controller), which seems ridiculous, but I can't find anything that explains it or works.  Yes, I'm aware of the many examples of overriding a standard object tab; it doesn't work for a custom object tab.  Any help would be appreciated.

We need an experienced independent VF/Apex developer to work with us as a subcontractor, for both short-term part-time work (June-July) and a long-term part-time subcontract relationship. Must be strong with Visualforce, and Partner Portal experience is helpful. Strongly prefer that you be in the San Francisco Bay Area, preferably in the East Bay.

I assume Ron himself is the best one to answer this, but just in case:

We hacked together a quick solution for our Access client app two years ago using Ron Hess' CSession and "KT"s (don't know who that is!) SFC class modules I dug up somewhere on line here.  Now we need to add functionality that requires version 3 of the Toolkit.  Before we rewrite it all from 2 to 3, a question: did Ron or somebody else ever update CSession and SFC to work with Toolkit 3? (and if so, where could I find it?)

TIA!

Rick N.

This new Identity Confirmation looks like it would be a problem for a user with dynamic IPs, as with most remote users who work from home, depending on how often their IP changes.  Don't some broadband ISPs change your dynamic IP frequently?  Looks like every change would require the user of an API app to get a new security token, which could make the app a real pain to use.  Anybody know anything about this?  TIA - Rick N.
Is there some way to upload a file to get it to other forum members??
OK - I'm a dumb newbie - but how do I print a thread on this forum?? It's right in front of me, right?
I'm assessing interfacing to sforce from a mature MS Access 2002 (XP) app, which already interfaces to 3 other web services. I'm trying to use the MS Office XP Web Services Toolkit 2.0 from within Access, which is pretty well documented, but doesn't seem to like the WSDL file generated by sforce (refuses to read it, although it will read other WSDL files). I've downloaded the sforce Office Toolkit and Excel connector but haven't explored them yet (just about to). As far as I can tell from previous posts there isn't much documentation on them and there's little or no experience with using the Office Toolkit from Access. Any suggestions on the shortest path for me? TIA.

Hello,

 

We all know that we have Login History Trail for login to Salesforce.com using User Interface.

 

However, is there a way we can capture login to Salesforce.com via Outlook or Mobile devices? This is required as management may need to know about who logged into Salesforce via Outlook connect and who logged via mobiles, specially the field sales guys.

 

Is there any App-Exchange product for same?

 

 

Thanks,

 

Vimal

Does anyone know if there's any way to do this? As far as I can tell it's impossible to override a custom object tab with a functional page (i.e., one with a controller), which seems ridiculous, but I can't find anything that explains it or works.  Yes, I'm aware of the many examples of overriding a standard object tab; it doesn't work for a custom object tab.  Any help would be appreciated.

I would like to use the Office Toolkit (which I have installed) with MS Access.  However, when I open Access, I cannot see where to connect to Salesforce.  When I open Word, I have a Salesforce menu --- but nothing in Access.  I do not have the ODBC driver.

 

Any ideas?

 

Thanks!

Barb

  • April 30, 2010
  • Like
  • 0

Some time I have in the desktop some file for upload into opportunities.

 

I'm studying a program in vb6 for clicking on file on the desktop with right click and chose the menu "upload to salesforce".

After, the user will be write the id of opportunities, and the work as done!!

I will have my file on desktop into SF; in this way is more fast than upload manually into SF and login etc...

 

I'm able to loggin into sf and update field, but I'm not able to upload file, maybe I have to create a field with bloob or something similar....

Anyone can help me ?

I'm looking on discussion boards but I find something only for vb.net .

 

thanks!

 

Hi,

 

I'm using the Sforce Office Toolkit and I get the following error when I try logging into a client's system:

INVALID_LOGIN: Invalid username, password, security token; or user locked out.

 

I can login to our developer accounts just fine -it's only the clients that don't work. The credentials that I'm using are 100% correct.

 

Any ideas?

  • March 26, 2010
  • Like
  • 0

Hi All,

 

I'm looking for a relatively simple solution to pull data from the SF database into Access to build some custom reports.  I've looked at OpenAccess ODBC and it works nicely but very expensive ($2000).  Also looked at Dataloader but it requires Enterprise edition and we have Professional.    DBAmp is also very expensive at $1250 per year.

 

Is there any type of lower cost solution to get access to the SF database?

 

Thanks,

 

Paul 

Hi,

I need to put a custom related list on the account detail page and put the Hover link on the top of the page for the custom related list.

 

I was able to do the custom related list displayed on the bottom of the Account detail page wiring a standard controller extension and visula force page.

 

Now the problem is How do I place the Hover link on the top of the page for the custom list? I saw couple of threads for the above, but the hover links issue was never discussed?.

 

Can any one please guide me how can I do this.

 

Thank you.

Hello,

I have done a fair amount of research on this topic, but I am still unclear on how to accomplish the following two things:

1. We are using Salesforce's Customer Portal product. We have built two custom objects and are displaying tabs for these custom objects in our Customer Portal. We have also built controller extensions for these custom objects to extend the functionality of the standard controllers. We want to display Visualforce pages when a user clicks on the tabs for these objects in the Customer Portal. In order to override the tabs for these objects with a Visualforce page, we cannot specify a standardContoller using the same object name in the Visualforce page. If we do, the VF page is not given as an option when you try to override the tab. If the VF page does not have a standardController specified, we can use it to override the tab, but we cannot link our controller extension to the page.

For example, I have a custom object called "Contact Us". I want to override the tab for this object with the following Visualforce page:

Code:
<apex:page standardController="Contact_Us__c" extensions="ContactUsExtensions">
  <h1>Custom Contact Us Page</h1>
</apex:page>

I am not given the option to override the "Contact Us" custom object tab with this page. It will only allow me to override it with a page that does not have a standardController specified. Why is that?

2. In addition to above, we need to show the standard "Contact Us" homepage when a user clicks on the "Contact Us" tab in the regular Salesforce interface, and we need to show a custom Visualforce page when a user clicks on the "Contact Us" tab in the Customer Portal. To do this, we created a new controller, ContactOverride - here is the code:

Code:
public class ContactOverride {
    public ContactOverride() {

    }


   String recordId;

public ContactOverride(ApexPages.StandardController
       controller) {recordId = controller.getId();}

public PageReference redirect() {
  Profile p = [select name from Profile where id =
               :UserInfo.getProfileId()];
  if ('Customer Portal User'.equals(p.name)
      || 'Customer Portal Test'.equals(p.name))
      {
       PageReference customPage =
Page.PortalContactUs;
       customPage.setRedirect(true);
       customPage.getParameters().put('id', recordId);
       return customPage;
      } else {
         return null; //otherwise stay on the same page
      }
   }
}

This code was lifted directly from the Force.com Cookbook (pages 53-56) and modified slightly to fit our needs. Basically, the controller sends users in the profiles "Customer Portal User" or "Customer Portal Test" to a custom Visualforce page (PortalContactUs) when they click on the "Contact Us" tab. If the user is not in either of those profiles, they stay on the same page.

Then, we created a new Visualforce page called ContactRedirect that looks like this:

Code:
<apex:page controller="ContactOverride" action="{!redirect}">
   <apex:detail />
</apex:page>

and override the tab on the "Contact Us" custom object with this page.

Again, we took this code from the Force.com Cookbook (pages 53-56) and modified it slightly. (The instructions in the Cookbook tell us to set a standardController and use the override controller we built as an extension. However, we cannot override the tab with a standardController set as explained in issue 1.)

This seems to work, but we would prefer that users who are not in the "Customer Portal User" or "Customer Portal Test" profiles see the standard "Contact Us" homepage under the "Contact Us" tab, and not the "ContactRedirect" VF page. Is there a way to change the controller (ContactOverride) to do this?

What are the best solutions to these issues?

Thanks for any help that you can offer,

-- Robert
 

 

I am trying generate apex code by uploading wsdl. But since the wsdl has 3 bindings (Soap 1.1, Soap 1.2 and HTTP), it is getting rejected. I understand Soap 1.2 is not supported at SalesForce. I commented out Soap 1.2 binding. Of the remaining 2 (SOAP 1.1 and HTTP), I could not anyone of them.

If I comment HTTP binding, then I am getting an error: No Http binding. If I comment SOAP 1.1, then getting error: Unable to find soap 1.1 address.

What should I do?
  • October 02, 2007
  • Like
  • 0
I have wrritten an addin using the Office Tookit that takes a Word document and saves it as an Attachment in the salesforce system.  The problem is, when I set the body field as the Word document, it isn't encoded in Base64 (the API docs say the client app is responsible for encoding and decoding the binary attachments as Base64 when sending or receiving objects including Attachments, MailMerge templates, and S-Controls.
 
I have googled and searched the Microsoft and MSDN pages and haven't found anything yet.  Does anyone know of any converter or have any VBA code that will decode/encode a Word document back and forth between Base64?  Thanks