Adding an Epicor DLL reference in MS Access

I was thinking about that but in this case, I need to pull data from
Access to make the BO call and then store the results in a table in
Access.
I think for this task, that's more coding than is needed when compared
to how it would have worked in Access.










Joe Rojas | Director of Information Technology | Mats Inc
dir: 781-573-0291 | cell: 781-408-9278 | fax: 781-232-5191
jrojas@... | www.matsinc.com Ask us about our clean, green and beautiful matting and flooring


This message is intended only for the individual named. If you are not the named addressee you should not disseminate, distribute or copy this e-mail. Please notify the sender immediately by e-mail if you have received this e-mail by mistake. Please note that any views or opinions presented in this email are solely those of the author and do not necessarily represent those of the company.



-----Original Message-----

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of Jose Gomez
Sent: Friday, September 28, 2012 11:52 AM
To: vantage@yahoogroups.com
Subject: Re: [Vantage] Adding an Epicor DLL reference in MS Access

You could write an External.NET program that will write to the Acccess
DB thoug.

*Jose C Gomez*
*Software Engineer*
*
*
*
*T: 904.469.1524 mobile
E: jose@...
http://www.josecgomez.com
<http://www.linkedin.com/in/josecgomez>
<http://www.facebook.com/josegomez>
<http://www.google.com/profiles/jose.gomez>
<http://www.twitter.com/joc85>
<http://www.josecgomez.com/professional-resume/>
<http://www.josecgomez.com/feed/>
<http://www.usdoingstuff.com>

*Quis custodiet ipsos custodes?*



On Fri, Sep 28, 2012 at 11:48 AM, Joe Rojas <jrojas@...> wrote:

> **
>
>
> Thanks Jose.
> If figured that much but I thought it was worth an ask. :(
>
>
> Joe Rojas | Director of Information Technology | Mats Inc
> dir: 781-573-0291 | cell: 781-408-9278 | fax: 781-232-5191
> jrojas@... | www.matsinc.com Ask us about our clean, green and

> beautiful matting and flooring
>
> This message is intended only for the individual named. If you are not

> the named addressee you should not disseminate, distribute or copy
this e-mail.
> Please notify the sender immediately by e-mail if you have received
> this e-mail by mistake. Please note that any views or opinions
> presented in this email are solely those of the author and do not
> necessarily represent those of the company.
>
> -----Original Message-----
>
> From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On
> Behalf Of Jose Gomez
> Sent: Friday, September 28, 2012 11:44 AM
> To: vantage@yahoogroups.com
> Subject: Re: [Vantage] Adding an Epicor DLL reference in MS Access
>
>
> No can do, Access uses VBA which is not .Net is ore like old school
COM.
>
> *Jose C Gomez*
> *Software Engineer*
> *
> *
> *
> *T: 904.469.1524 mobile
> E: jose@...
> http://www.josecgomez.com
> <http://www.linkedin.com/in/josecgomez>
> <http://www.facebook.com/josegomez>
> <http://www.google.com/profiles/jose.gomez>
> <http://www.twitter.com/joc85>
> <http://www.josecgomez.com/professional-resume/>
> <http://www.josecgomez.com/feed/>
> <http://www.usdoingstuff.com>
>
> *Quis custodiet ipsos custodes?*
>
>
> On Fri, Sep 28, 2012 at 11:24 AM, Joe Rojas <jrojas@...>
wrote:
>
> > **
>
> >
> >
> > Hi All,
> >
> > I went to add Epicor.Mfg.BO.Part.dll as a reference to a MS Access
> > module and it told me it couldn't add the reference.
> >
> > Is there some other way to do this?
> >
> > Why Access? Because I want to pull specific data from Epicor,
> > exactly the way Epicor does, and then store it in a table in Access.
> >
> >
> >
> >
> >
> > Joe Rojas | Director of Information Technology | Mats Inc
> > dir: 781-573-0291 | cell: 781-408-9278 | fax: 781-232-5191
> > jrojas@... | www.matsinc.com Ask us about our clean, green
> > and
>
> > beautiful matting and flooring
> >
> > This message is intended only for the individual named. If you are
> > not
>
> > the named addressee you should not disseminate, distribute or copy
> this e-mail.
> > Please notify the sender immediately by e-mail if you have received
> > this e-mail by mistake. Please note that any views or opinions
> > presented in this email are solely those of the author and do not
> > necessarily represent those of the company.
> >
> > [Non-text portions of this message have been removed]
> >
> >
> >
>
> [Non-text portions of this message have been removed]
>
> ------------------------------------
>
>
> Useful links for the Yahoo!Groups Vantage Board are: ( Note: You must
> have already linked your email address to a yahoo id to enable access.

> )
> (1) To access the Files Section of our Yahoo!Group for Report Builder
> and Crystal Reports and other 'goodies', please goto:
> http://groups.yahoo.com/group/vantage/files/.
> (2) To search through old msg's goto:
> http://groups.yahoo.com/group/vantage/messages
> (3) To view links to Vendors that provide Vantage services goto:
> http://groups.yahoo.com/group/vantage/linksYahoo! Groups Links
>
>
>


[Non-text portions of this message have been removed]



------------------------------------

Useful links for the Yahoo!Groups Vantage Board are: ( Note: You must
have already linked your email address to a yahoo id to enable access. )
(1) To access the Files Section of our Yahoo!Group for Report Builder
and Crystal Reports and other 'goodies', please goto:
http://groups.yahoo.com/group/vantage/files/.
(2) To search through old msg's goto:
http://groups.yahoo.com/group/vantage/messages
(3) To view links to Vendors that provide Vantage services goto:
http://groups.yahoo.com/group/vantage/linksYahoo! Groups Links
Hi All,



I went to add Epicor.Mfg.BO.Part.dll as a reference to a MS Access
module and it told me it couldn't add the reference.

Is there some other way to do this?



Why Access? Because I want to pull specific data from Epicor, exactly
the way Epicor does, and then store it in a table in Access.








Joe Rojas | Director of Information Technology | Mats Inc
dir: 781-573-0291 | cell: 781-408-9278 | fax: 781-232-5191
jrojas@... | www.matsinc.com Ask us about our clean, green and beautiful matting and flooring


This message is intended only for the individual named. If you are not the named addressee you should not disseminate, distribute or copy this e-mail. Please notify the sender immediately by e-mail if you have received this e-mail by mistake. Please note that any views or opinions presented in this email are solely those of the author and do not necessarily represent those of the company.


[Non-text portions of this message have been removed]
No can do, Access uses VBA which is not .Net is ore like old school COM.



*Jose C Gomez*
*Software Engineer*
*
*
*
*T: 904.469.1524 mobile
E: jose@...
http://www.josecgomez.com
<http://www.linkedin.com/in/josecgomez> <http://www.facebook.com/josegomez>
<http://www.google.com/profiles/jose.gomez> <http://www.twitter.com/joc85>
<http://www.josecgomez.com/professional-resume/>
<http://www.josecgomez.com/feed/>
<http://www.usdoingstuff.com>

*Quis custodiet ipsos custodes?*



On Fri, Sep 28, 2012 at 11:24 AM, Joe Rojas <jrojas@...> wrote:

> **
>
>
> Hi All,
>
> I went to add Epicor.Mfg.BO.Part.dll as a reference to a MS Access
> module and it told me it couldn't add the reference.
>
> Is there some other way to do this?
>
> Why Access? Because I want to pull specific data from Epicor, exactly
> the way Epicor does, and then store it in a table in Access.
>
>
>
>
>
> Joe Rojas | Director of Information Technology | Mats Inc
> dir: 781-573-0291 | cell: 781-408-9278 | fax: 781-232-5191
> jrojas@... | www.matsinc.com Ask us about our clean, green and
> beautiful matting and flooring
>
> This message is intended only for the individual named. If you are not the
> named addressee you should not disseminate, distribute or copy this e-mail.
> Please notify the sender immediately by e-mail if you have received this
> e-mail by mistake. Please note that any views or opinions presented in this
> email are solely those of the author and do not necessarily represent those
> of the company.
>
> [Non-text portions of this message have been removed]
>
>
>


[Non-text portions of this message have been removed]
Thanks Jose.
If figured that much but I thought it was worth an ask. :(










Joe Rojas | Director of Information Technology | Mats Inc
dir: 781-573-0291 | cell: 781-408-9278 | fax: 781-232-5191
jrojas@... | www.matsinc.com Ask us about our clean, green and beautiful matting and flooring


This message is intended only for the individual named. If you are not the named addressee you should not disseminate, distribute or copy this e-mail. Please notify the sender immediately by e-mail if you have received this e-mail by mistake. Please note that any views or opinions presented in this email are solely those of the author and do not necessarily represent those of the company.



-----Original Message-----

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of Jose Gomez
Sent: Friday, September 28, 2012 11:44 AM
To: vantage@yahoogroups.com
Subject: Re: [Vantage] Adding an Epicor DLL reference in MS Access

No can do, Access uses VBA which is not .Net is ore like old school COM.



*Jose C Gomez*
*Software Engineer*
*
*
*
*T: 904.469.1524 mobile
E: jose@...
http://www.josecgomez.com
<http://www.linkedin.com/in/josecgomez>
<http://www.facebook.com/josegomez>
<http://www.google.com/profiles/jose.gomez>
<http://www.twitter.com/joc85>
<http://www.josecgomez.com/professional-resume/>
<http://www.josecgomez.com/feed/>
<http://www.usdoingstuff.com>

*Quis custodiet ipsos custodes?*



On Fri, Sep 28, 2012 at 11:24 AM, Joe Rojas <jrojas@...> wrote:

> **
>
>
> Hi All,
>
> I went to add Epicor.Mfg.BO.Part.dll as a reference to a MS Access
> module and it told me it couldn't add the reference.
>
> Is there some other way to do this?
>
> Why Access? Because I want to pull specific data from Epicor, exactly
> the way Epicor does, and then store it in a table in Access.
>
>
>
>
>
> Joe Rojas | Director of Information Technology | Mats Inc
> dir: 781-573-0291 | cell: 781-408-9278 | fax: 781-232-5191
> jrojas@... | www.matsinc.com Ask us about our clean, green and

> beautiful matting and flooring
>
> This message is intended only for the individual named. If you are not

> the named addressee you should not disseminate, distribute or copy
this e-mail.
> Please notify the sender immediately by e-mail if you have received
> this e-mail by mistake. Please note that any views or opinions
> presented in this email are solely those of the author and do not
> necessarily represent those of the company.
>
> [Non-text portions of this message have been removed]
>
>
>


[Non-text portions of this message have been removed]



------------------------------------

Useful links for the Yahoo!Groups Vantage Board are: ( Note: You must
have already linked your email address to a yahoo id to enable access. )
(1) To access the Files Section of our Yahoo!Group for Report Builder
and Crystal Reports and other 'goodies', please goto:
http://groups.yahoo.com/group/vantage/files/.
(2) To search through old msg's goto:
http://groups.yahoo.com/group/vantage/messages
(3) To view links to Vendors that provide Vantage services goto:
http://groups.yahoo.com/group/vantage/linksYahoo! Groups Links
You could write an External.NET program that will write to the Acccess DB
thoug.

*Jose C Gomez*
*Software Engineer*
*
*
*
*T: 904.469.1524 mobile
E: jose@...
http://www.josecgomez.com
<http://www.linkedin.com/in/josecgomez> <http://www.facebook.com/josegomez>
<http://www.google.com/profiles/jose.gomez> <http://www.twitter.com/joc85>
<http://www.josecgomez.com/professional-resume/>
<http://www.josecgomez.com/feed/>
<http://www.usdoingstuff.com>

*Quis custodiet ipsos custodes?*



On Fri, Sep 28, 2012 at 11:48 AM, Joe Rojas <jrojas@...> wrote:

> **
>
>
> Thanks Jose.
> If figured that much but I thought it was worth an ask. :(
>
>
> Joe Rojas | Director of Information Technology | Mats Inc
> dir: 781-573-0291 | cell: 781-408-9278 | fax: 781-232-5191
> jrojas@... | www.matsinc.com Ask us about our clean, green and
> beautiful matting and flooring
>
> This message is intended only for the individual named. If you are not the
> named addressee you should not disseminate, distribute or copy this e-mail.
> Please notify the sender immediately by e-mail if you have received this
> e-mail by mistake. Please note that any views or opinions presented in this
> email are solely those of the author and do not necessarily represent those
> of the company.
>
> -----Original Message-----
>
> From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
> Of Jose Gomez
> Sent: Friday, September 28, 2012 11:44 AM
> To: vantage@yahoogroups.com
> Subject: Re: [Vantage] Adding an Epicor DLL reference in MS Access
>
>
> No can do, Access uses VBA which is not .Net is ore like old school COM.
>
> *Jose C Gomez*
> *Software Engineer*
> *
> *
> *
> *T: 904.469.1524 mobile
> E: jose@...
> http://www.josecgomez.com
> <http://www.linkedin.com/in/josecgomez>
> <http://www.facebook.com/josegomez>
> <http://www.google.com/profiles/jose.gomez>
> <http://www.twitter.com/joc85>
> <http://www.josecgomez.com/professional-resume/>
> <http://www.josecgomez.com/feed/>
> <http://www.usdoingstuff.com>
>
> *Quis custodiet ipsos custodes?*
>
>
> On Fri, Sep 28, 2012 at 11:24 AM, Joe Rojas <jrojas@...> wrote:
>
> > **
>
> >
> >
> > Hi All,
> >
> > I went to add Epicor.Mfg.BO.Part.dll as a reference to a MS Access
> > module and it told me it couldn't add the reference.
> >
> > Is there some other way to do this?
> >
> > Why Access? Because I want to pull specific data from Epicor, exactly
> > the way Epicor does, and then store it in a table in Access.
> >
> >
> >
> >
> >
> > Joe Rojas | Director of Information Technology | Mats Inc
> > dir: 781-573-0291 | cell: 781-408-9278 | fax: 781-232-5191
> > jrojas@... | www.matsinc.com Ask us about our clean, green and
>
> > beautiful matting and flooring
> >
> > This message is intended only for the individual named. If you are not
>
> > the named addressee you should not disseminate, distribute or copy
> this e-mail.
> > Please notify the sender immediately by e-mail if you have received
> > this e-mail by mistake. Please note that any views or opinions
> > presented in this email are solely those of the author and do not
> > necessarily represent those of the company.
> >
> > [Non-text portions of this message have been removed]
> >
> >
> >
>
> [Non-text portions of this message have been removed]
>
> ------------------------------------
>
>
> Useful links for the Yahoo!Groups Vantage Board are: ( Note: You must
> have already linked your email address to a yahoo id to enable access. )
> (1) To access the Files Section of our Yahoo!Group for Report Builder
> and Crystal Reports and other 'goodies', please goto:
> http://groups.yahoo.com/group/vantage/files/.
> (2) To search through old msg's goto:
> http://groups.yahoo.com/group/vantage/messages
> (3) To view links to Vendors that provide Vantage services goto:
> http://groups.yahoo.com/group/vantage/linksYahoo! Groups Links
>
>
>


[Non-text portions of this message have been removed]