Oct 18, 2004 #1 secmachine MIS Joined Aug 11, 2004 Messages 7 Location CA I am coding a macro and was just wondering if there was a tool in ACCPAC that will list the fiscal year information when a drop down box is clicked?
I am coding a macro and was just wondering if there was a tool in ACCPAC that will list the fiscal year information when a drop down box is clicked?
Oct 18, 2004 #2 jayconverse MIS Joined Jul 23, 2002 Messages 779 Location US Sure, it's the AccpacPeriodPicker control. Drop it on your form, then initialize like this: Set Me.pdPick.DBLink = mDBLinkCmpRW mDBLinkCmpRW.GetFiscalCalendar.GetPeriod Date, sCurPer, sCurYear Me.pdPick.SetValueByDate mDBLinkCmpRW.Session.SessionDate Jay Converse IT Director Systemlink, Inc. Upvote 0 Downvote
Sure, it's the AccpacPeriodPicker control. Drop it on your form, then initialize like this: Set Me.pdPick.DBLink = mDBLinkCmpRW mDBLinkCmpRW.GetFiscalCalendar.GetPeriod Date, sCurPer, sCurYear Me.pdPick.SetValueByDate mDBLinkCmpRW.Session.SessionDate Jay Converse IT Director Systemlink, Inc.
Oct 19, 2004 Thread starter #3 secmachine MIS Joined Aug 11, 2004 Messages 7 Location CA Thanks Jay! Upvote 0 Downvote