Open UI + scroll
Open UI + scroll
(OP)
Hello all
I would like to ask the professionals here in this group how to open up an accpac 5.1 form (e.g. PO Entry) and scroll it to a specific record (PO #) Using VB
Thanks in advance
Solomon
I would like to ask the professionals here in this group how to open up an accpac 5.1 form (e.g. PO Entry) and scroll it to a specific record (PO #) Using VB
Thanks in advance
Solomon
RE: Open UI + scroll
Create and open a session object. See Thread631-583563 and Thread631-538503 for examples.
Code will be basically as follows.
Dim myPOnumber as string
Dim POPOR As ACCPACXAPILib.xapiView
myPOnumber=???
Set POPOR = Session.OpenView("PO0620", "PO")
With POPOR
.Browse "PONUMBER = " & myPOnumber & "", True
If .Fetch Then
Debug.Print .Fields("PORHSEQ").value
Debug.Print .Fields("PONUMBER").value
Debug.Print .Fields("DATE").value
...
End If
.Cancel
End With
Set POPOR = Nothing
Thanks and Good Luck!
zemp
RE: Open UI + scroll
But what i need is to display the accpac UI and then scroll to the PO i want.
The code you wrote just opens the underlying dataset not the form
Solomon
RE: Open UI + scroll
Through the VB xAPI you would need to create your own form to display the information.
Thanks and Good Luck!
zemp
RE: Open UI + scroll
In this thread Thread631-660336, sixtyone provided sample codes for opening ACCPACCOMAPI sessions in VB.
Combining the two piece of information you should be able to do what you want in just a few lines of code.
------------
rvspy@nospam.htomail.com