Thanks for the quick reply Joe and Jose - both answers helped out so my code is now compiled.
Tim Lester
> **[Non-text portions of this message have been removed]
>
>
> So, I am not sure what I am doing wrong, but I am always getting the tab
> visible...My code compiles without error, but something is incorrect in the
> logic. I am testing with one user who is a member of the group and one who
> is not...The BAQ shows only one row (user who is a member). I have the
> control property set visible to false. Any ideas? Code is below...
>
> Sub InitializeCustomCode()
>
> '// ** Wizard Insert Location - Do not delete 'Begin/End Wizard Added
> Variable Intialization' lines **
> '// Begin Wizard Added Variable Intialization
>
> '// End Wizard Added Variable Intialization
> '// Begin Custom Method Calls
>
> '// End Custom Method Calls
> Dim Chemistry as EpiBasePanel =
> CType(csm.GetNativeControlReference("b7ef62fe-8b9b-454d-b24e-85e4b10c5a37"),EpiBasePanel)
> Dim _dq As New DynamicQuery(DirectCast(oTrans.Session,
> Session).ConnectionPool)
> Dim ds As DataSet = _dq.ExecuteByID("TST-SecAdvTest")
> Dim found As Boolean = False
> For Each dr As DataRow In ds.Tables(0).Rows
> If
> dr("UserFile.DcdUserID").ToString().ToUpper().Equals(DirectCast(oTrans.Session,
> Session).UserID.ToUpper()) Then
> found = True
> End If
> Next
> Chemistry.Visible = found
>
> End Sub
>
>
> From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
> Of Ted Koch
> Sent: Tuesday, December 11, 2012 10:42 AM
> To: vantage@yahoogroups.com
> Subject: Re: [Vantage] Customization - how do I set a tab visibile if user
> is a member of a group?
>
>
> Check out this example from Jose. Same idea but instead of disabling a
> button, hide the tab.
>
> http://www.usdoingstuff.com/2012/01/24/epicor-9-group-button-security/
>
> ________________________________
> From: Karen Schoenung <kschoenung@...<mailto:
> kschoenung%40fisher-barton.com>>
> To: vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com>
> Sent: Tuesday, December 11, 2012 10:45 AM
> Subject: [Vantage] Customization - how do I set a tab visibile if user is
> a member of a group?
>
> Hi,
>
> I have a customization that will set a tab to visible = false on load.
> However, I want the tab visible to certain groups. How do I set it after
> they enter a part for example? I have tried to use the after update and
> after exit edit mode, so far no success (just for a message box). The
> customization will be for Part Entry.
>
> TIA,
> Karen
>
> ------------------------------------
>
> 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/.<
> 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]
>
> [Non-text portions of this message have been removed]
>
>
>
On Tue, Dec 11, 2012 at 2:46 PM, Karen Schoenung < kschoenung@...> wrote:
> **
>
>
> So, I am not sure what I am doing wrong, but I am always getting the
> tab visible...My code compiles without error, but something is
> incorrect in the logic. I am testing with one user who is a member of
> the group and one who is not...The BAQ shows only one row (user who is
> a member). I have the control property set visible to false. Any ideas? Code is below...
>
> Sub InitializeCustomCode()
>
> '// ** Wizard Insert Location - Do not delete 'Begin/End Wizard Added
> Variable Intialization' lines ** '// Begin Wizard Added Variable
> Intialization
>
> '// End Wizard Added Variable Intialization '// Begin Custom Method
> Calls
>
> '// End Custom Method Calls
> Dim Chemistry as EpiBasePanel =
> CType(csm.GetNativeControlReference("b7ef62fe-8b9b-454d-b24e-85e4b10c5
> a37"),EpiBasePanel) Dim _dq As New
> DynamicQuery(DirectCast(oTrans.Session,
> Session).ConnectionPool)
> Dim ds As DataSet = _dq.ExecuteByID("TST-SecAdvTest") Dim found As
> Boolean = False For Each dr As DataRow In ds.Tables(0).Rows If
> dr("UserFile.DcdUserID").ToString().ToUpper().Equals(DirectCast(oTrans
> .Session,
> Session).UserID.ToUpper()) Then
> found = True
> End If
> Next
> Chemistry.Visible = found
>
> End Sub
>
>
> From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On
> Behalf Of Ted Koch
> Sent: Tuesday, December 11, 2012 10:42 AM
> To: vantage@yahoogroups.com
> Subject: Re: [Vantage] Customization - how do I set a tab visibile if
> user is a member of a group?
>
>
> Check out this example from Jose. Same idea but instead of disabling a
> button, hide the tab.
>
> http://www.usdoingstuff.com/2012/01/24/epicor-9-group-button-security/
>
> ________________________________
> From: Karen Schoenung <kschoenung@...<mailto:
> kschoenung%40fisher-barton.com>>
> To: vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com>
> Sent: Tuesday, December 11, 2012 10:45 AM
> Subject: [Vantage] Customization - how do I set a tab visibile if user
> is a member of a group?
>
> Hi,
>
> I have a customization that will set a tab to visible = false on load.
> However, I want the tab visible to certain groups. How do I set it
> after they enter a part for example? I have tried to use the after
> update and after exit edit mode, so far no success (just for a message
> box). The customization will be for Part Entry.
>
> TIA,
> Karen
>
> ------------------------------------
>
> 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/.<
> 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]
>
> [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]
>
>
> In Part Entry, a custom tab we made (new tab between Comments and
> Dimensions)
>
>
> -----Original Message-----
> From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
> Of Jose Gomez
> Sent: Tuesday, December 11, 2012 1:54 PM
> To: Vantage
> Subject: Re: [Vantage] Customization - how do I set a tab visibile if user
> is a member of a group?
>
> Karen,
> Sometimes the Epicor logic will flip a Tab to Visible. Where are you
> trying to do this? And which tab
>
> *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 Tue, Dec 11, 2012 at 2:46 PM, Karen Schoenung <
> kschoenung@...> wrote:
>
> > **
>
> >
> >
> > So, I am not sure what I am doing wrong, but I am always getting the
> > tab visible...My code compiles without error, but something is
> > incorrect in the logic. I am testing with one user who is a member of
> > the group and one who is not...The BAQ shows only one row (user who is
> > a member). I have the control property set visible to false. Any ideas?
> Code is below...
> >
> > Sub InitializeCustomCode()
> >
> > '// ** Wizard Insert Location - Do not delete 'Begin/End Wizard Added
> > Variable Intialization' lines ** '// Begin Wizard Added Variable
> > Intialization
> >
> > '// End Wizard Added Variable Intialization '// Begin Custom Method
> > Calls
> >
> > '// End Custom Method Calls
> > Dim Chemistry as EpiBasePanel =
> > CType(csm.GetNativeControlReference("b7ef62fe-8b9b-454d-b24e-85e4b10c5
> > a37"),EpiBasePanel) Dim _dq As New
> > DynamicQuery(DirectCast(oTrans.Session,
> > Session).ConnectionPool)
> > Dim ds As DataSet = _dq.ExecuteByID("TST-SecAdvTest") Dim found As
> > Boolean = False For Each dr As DataRow In ds.Tables(0).Rows If
> > dr("UserFile.DcdUserID").ToString().ToUpper().Equals(DirectCast(oTrans
> > .Session,
> > Session).UserID.ToUpper()) Then
> > found = True
> > End If
> > Next
> > Chemistry.Visible = found
> >
> > End Sub
> >
> >
> > From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On
> > Behalf Of Ted Koch
> > Sent: Tuesday, December 11, 2012 10:42 AM
> > To: vantage@yahoogroups.com
> > Subject: Re: [Vantage] Customization - how do I set a tab visibile if
> > user is a member of a group?
> >
> >
> > Check out this example from Jose. Same idea but instead of disabling a
> > button, hide the tab.
> >
> > http://www.usdoingstuff.com/2012/01/24/epicor-9-group-button-security/
> >
> > ________________________________
> > From: Karen Schoenung <kschoenung@...<mailto:
> > kschoenung%40fisher-barton.com>>
> > To: vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com>
> > Sent: Tuesday, December 11, 2012 10:45 AM
> > Subject: [Vantage] Customization - how do I set a tab visibile if user
> > is a member of a group?
> >
> > Hi,
> >
> > I have a customization that will set a tab to visible = false on load.
> > However, I want the tab visible to certain groups. How do I set it
> > after they enter a part for example? I have tried to use the after
> > update and after exit edit mode, so far no success (just for a message
> > box). The customization will be for Part Entry.
> >
> > TIA,
> > Karen
> >
> > ------------------------------------
> >
> > 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/.<
> > 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]
> >
> > [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
>
>
>
On Tue, Dec 11, 2012 at 3:00 PM, Karen Schoenung < kschoenung@...> wrote:
> **
>
>
> In Part Entry, a custom tab we made (new tab between Comments and
> Dimensions)
>
>
> -----Original Message-----
> From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On
> Behalf Of Jose Gomez
> Sent: Tuesday, December 11, 2012 1:54 PM
> To: Vantage
> Subject: Re: [Vantage] Customization - how do I set a tab visibile if
> user is a member of a group?
>
> Karen,
> Sometimes the Epicor logic will flip a Tab to Visible. Where are you
> trying to do this? And which tab
>
> *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 Tue, Dec 11, 2012 at 2:46 PM, Karen Schoenung <
> kschoenung@...> wrote:
>
> > **
>
> >
> >
> > So, I am not sure what I am doing wrong, but I am always getting the
> > tab visible...My code compiles without error, but something is
> > incorrect in the logic. I am testing with one user who is a member
> > of the group and one who is not...The BAQ shows only one row (user
> > who is a member). I have the control property set visible to false. Any ideas?
> Code is below...
> >
> > Sub InitializeCustomCode()
> >
> > '// ** Wizard Insert Location - Do not delete 'Begin/End Wizard
> > Added Variable Intialization' lines ** '// Begin Wizard Added
> > Variable Intialization
> >
> > '// End Wizard Added Variable Intialization '// Begin Custom Method
> > Calls
> >
> > '// End Custom Method Calls
> > Dim Chemistry as EpiBasePanel =
> > CType(csm.GetNativeControlReference("b7ef62fe-8b9b-454d-b24e-85e4b10
> > c5
> > a37"),EpiBasePanel) Dim _dq As New
> > DynamicQuery(DirectCast(oTrans.Session,
> > Session).ConnectionPool)
> > Dim ds As DataSet = _dq.ExecuteByID("TST-SecAdvTest") Dim found As
> > Boolean = False For Each dr As DataRow In ds.Tables(0).Rows If
> > dr("UserFile.DcdUserID").ToString().ToUpper().Equals(DirectCast(oTra
> > ns
> > .Session,
> > Session).UserID.ToUpper()) Then
> > found = True
> > End If
> > Next
> > Chemistry.Visible = found
> >
> > End Sub
> >
> >
> > From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On
> > Behalf Of Ted Koch
> > Sent: Tuesday, December 11, 2012 10:42 AM
> > To: vantage@yahoogroups.com
> > Subject: Re: [Vantage] Customization - how do I set a tab visibile
> > if user is a member of a group?
> >
> >
> > Check out this example from Jose. Same idea but instead of disabling
> > a button, hide the tab.
> >
> > http://www.usdoingstuff.com/2012/01/24/epicor-9-group-button-securit
> > y/
> >
> > ________________________________
> > From: Karen Schoenung <kschoenung@...<mailto:
> > kschoenung%40fisher-barton.com>>
> > To: vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com>
> > Sent: Tuesday, December 11, 2012 10:45 AM
> > Subject: [Vantage] Customization - how do I set a tab visibile if
> > user is a member of a group?
> >
> > Hi,
> >
> > I have a customization that will set a tab to visible = false on load.
> > However, I want the tab visible to certain groups. How do I set it
> > after they enter a part for example? I have tried to use the after
> > update and after exit edit mode, so far no success (just for a
> > message box). The customization will be for Part Entry.
> >
> > TIA,
> > Karen
> >
> > ------------------------------------
> >
> > 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/.<
> > 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]
> >
> > [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
On Thu, Dec 11, 2014 at 10:32 AM, tlester@... [vantage] <vantage@yahoogroups.com> wrote:Â<div> <p>I am working on something similar to this but Enable/Disable a ComboBox on a form. The link to usdoingstuff webpage is broken but I found the YouTube video and followed along - I am close but getting a reference error and hoping someone knows where the problem is.</p><div><br></div><div>First error is:Â The type or namespace name 'Datarow' could not be found (are you missing a using directive or an assembly reference?) and second error is: 'dr' is a 'variable' but is used like a 'method'</div><div><br></div><div>Not sure if Jose's YouTube video left out a reference and it was listed on the webpage - any suggestions would be helpful.</div><div><br></div><div>Thanks.</div><div><br></div><div>Tim Lester</div><div>Â </div><p></p> </div> <div style="color:#fff;min-height:0;"></div>