Ribbon (1 Viewer)

R

ryetee

Registered User.

Local time

Today, 04:30

Joined

Jul 30, 2013

Messages

952

• May 22, 2018

• #1

I'm using a ribbon and everything is working fine.
The user can open forms using the ribbon. Is there anyway I can mass over a parameter this way. Can't find anything on google to say I can. I want to be able to use me.openargs in the called program. Note the form to be opened is done so from the ribbon, I know how to pass a parameter from within VBA when opening a form.

 

MarkK

bit cruncher

Local time

Yesterday, 20:30

Joined

Mar 17, 2004

Messages

8,181

• May 22, 2018

• #2

ryetee said:

The user can open forms using the ribbon.

Click to expand...

What is the code for this? Why can't you amend to code that does this to pass OpenArgs to the form?
Mark

 

R

ryetee

Registered User.

Local time

Today, 04:30

Joined

Jul 30, 2013

Messages

952

• May 22, 2018

• #3

MarkK said:

What is the code for this? Why can't you amend to code that does this to pass OpenArgs to the form?
Mark

Click to expand...

It's some form of XML that is stored in SYSRIBBON a system table you can edit. I have code such as

<button id="ButtonClassification" size="large" label="Classifications"
onAction="=OpenAForm('Classifications')"/>
Classifications is the name of a form. I can't see how to pass openargs to it.

 

C

CJ_London

Super Moderator

Staff member

Local time

Today, 04:30

Joined

Feb 19, 2013

Messages

16,610

• May 22, 2018

• #4

suggest store your openargs in a tempvar or global variable and in the form open event reference the variables rather than openargs

 

R

ryetee

Registered User.

Local time

Today, 04:30

Joined

Jul 30, 2013

Messages

952

• May 22, 2018

• #5

CJ_London said:

suggest store your openargs in a tempvar or global variable and in the form open event reference the variables rather than openargs

Click to expand...

I can't. There are 4 options on the ribbon which call the same form. I want to pass a parameter which then governs which rows are displayed on the form

 

MarkK

bit cruncher

Local time

Yesterday, 20:30

Joined

Mar 17, 2004

Messages

8,181

• May 23, 2018

• #6

ryetee said:

<button id="ButtonClassification" size="large" label="Classifications"
onAction="=OpenAForm('Classifications')"/>

Click to expand...

This is the ribbon XML. The onAction element indicates that clicking this button on the ribbon calls a VBA function called OpenAForm(), which takes the form name as a parameter. What is the code for that Function? You can specify OpenArgs in that function.
Mark