Is there any way of customizing Accpac Forms?

[mejiaks]

I am new to Accpac, using 5.3A. My customer wants me to add another parameter to an existant report. Is there any way of adding this to the form, instead of developing a program or macro, and build a whole new one?

 

[Jay Converse]

Edit the report in Crystal reports, and add the parameter.

 

[ettienne]

No, you cannot edit Accpac forms, or screens to be more specific. You can drop the screen OCX on a VB/VBA form and do some magic.

 

[mejiaks]

So, let's see if i understand, every screen in accpac is an insertable ocx (ActiveX control) I can insert into a object support language such as VB, .Net, Delphi, VFP, etc and it will ac just the same as the regular screen, with the diference i can add more controls?

or should i set connections to tables and everything once I add the ocx to my program?

 

[Jay Converse]

1. Yes.
2. Sort of. You set connections to Views, not tables. This enforces the business logic.

 

[mejiaks]

I just drop the ocx on VFP and it seems to be working justa as i was on the accpac environment.
Now the next question. How do I access the controls withing the ocx? if I want to change the behavior of the print button for example?

 

[Jay Converse]

With the .GetControl method. Or, use .MacroVisible = False, and add your own button.

 

[mejiaks]

could you post the code like if I have to set the button invisible ?

keep in mind that I donot know what is the name of the control

 

[ettienne]

To find the control names open the form in Accpac (you must be logged in as ADMIN) and click File, Customize (you must setup a UI profile), from here you can get all the control names.

 

[Jay Converse]

You find the names of the controls with the U.I. Info utility in the Sage Accpac tools folder.

This is one I did for AP Payment Batch customization:

With Me.AccpacAP3000UICtrl1
.UIAppControls("btnpost").MacroVisibleFlag = False
.UIAppControls("btnopen").MacroVisibleFlag = False
end with

Then in the Form Resize subroutine, something like this for my cmdOpen button:

Me.cmdOpen.Top = .UIAppControls("btnopen").Top
Me.cmdOpen.Left = .UIAppControls("btnopen").Left
Me.cmdOpen.Width = .UIAppControls("btnopen").Width
Me.cmdOpen.Height = .UIAppControls("btnopen").Height

So the users don't know the difference

 

[mejiaks]

ok, here is my last question, at least for the moment.
would you guys be so kind and post an example of what you guys have achive customizing an accpac form?

Just for me to see what libraries i have to call, and what views i need to open? this woul be very useful for me in order to start using VB macros andaccpac. best regards

 

[Jay Converse]

Sorry, that's way too much to post, plus these are VB objects, not just text code.

Just record a macro, that's how everyone learns what views to use.

 

[mejiaks]

ok. I see what you mean. I just took a look at some macros and saw some tip to start the work.

best regards