Opening System forms.

[Former Member]

Hi

With regards to my previous post: /community [original link is broken] i wud like to knw if it is possible to open system forms thru ur code?? Being more specific i have created a table of no object type. By default a form is created for this in B1. Now i m goin to add an entry to my combo "Define New". On selecting this option i wud like to open the system form created in B1.

Even if it is possible how do i determine the form number on creation of a table??

Please Help!!!!!

Regards

Aris

[Former Member · Accepted solution]

Hi,

Yes it is possible to open.

select View-->View System Information

go to Tools-->Usertables,When you are navigating through usertables.

at the left side bottom you can see the menu id,Get that menu id.

use this code to open that form SboApplication.ActivateMenuItem(Menu id of that table)

e.g SboApplication.ActivateMenuItem("51228")

if it helps reward points

Regards

Vishnu

[Former Member · Accepted solution]

Thank you Vishnu was very helpful.. But now this brings me to the next problem.. How can i ensure that the menu Id will remain the same?? This will mean that first i will have to run the Db Patch and then according to the menu Id created i will have to make the change in my code.. This value must definitely have been stored in the database.. Do u knw which table this is in??

[Former Member · Accepted solution]

Hi,

you can get menu id like this

dim strMenuId as string

oRecSet.ExecuteQuery("SELECT count(*) as count FROM OUTB WHERE TableName <= 'TABLENAME' "

strMenuid = 51200 + oRecSet.Fields.Item("count").Value

Sbo_apllication.Activatemenuitem(strMenuId)

Hope this helps

Regards

Vishnu

[Former Member · Accepted solution]

Thanks Vishnu.. It really helped but in this case im searchin for No object type Table and hence i have to put in that too.. But all the same thanks for takin the tym to atend to the problem