RE: Adding Customer Inactive check box to National Accounts form.
To run this code you need to add a reference. Mark a reference to a Microsoft Active X Data Object Library in the VBA editor. 1. Open up the VBA editor and go to Tools | References.2. Scroll down until you see the Microsoft Active X Data Object Library. 3.Create a local check box field on Grid.
Screen shots below.
Public objcon As ADODB.Connection
Dim Rs As New ADODB.Recordset
Dim Ssql1 As String
Public Sub Opencon()
Set objcon = UserInfoGet.CreateADOConnection
objcon.DefaultDatabase = UserInfoGet.IntercompanyID
Private Sub Customization_Start()
Public Sub Grid_BeforeLinePopulate(RejectLine As Boolean)
If CustomerNumber.Value <> “” Then
Ssql1 = “select inactive from RM00101 where CUSTNMBR='” + CustomerNumber.Value + “‘”
If Rs.State = 1 Then Rs.Close
Rs.Open Ssql1, objcon, adOpenDynamic, adLockOptimistic
acb.Value = (Rs.Fields(0))
Filed under: Code Snippit, Dynamics GP, dynamics-gp, Customer National Account Window., Dynamics GP, Grid, VBA for Dynamics GP
September 26, 2012 • 10:57 am
If you are a dexterity developer then avoid using Ctrl+S. Sometimes it happened we start scripting and when try to compile the code got message
of unknown identifier and usually do Ctrl+S, then add the missing identifiers (filed,table etc) and forget to compile the script. So script is there but not compiled. IMHO whole dictionary should be complied before creating a chunk for deployment otherwise below error will occur.
“FP: Script not found errors”.
Filed under: Dexterity Development, Dynamics GP, dynamics-gp, chunk, dexterity, Dynamics GP, FP: Script not found errors, Microsoft Dynamics Error, Script Error, Script Not Found