How to change sheets automatically in Access point.

[mohammadkhatimi]

Hi everyone,

I want to change sheets automatically in Access point... I am able to do it in my desktop side.

Please suggest any solution which is successfully done.

Regards,

Mohammad

[Anonymous]

Can you please explain automatically with specific cases with which you want to this sheets to change ?

if would be great if you can put in qvw along with specific cases

[mohammadkhatimi]

Sheet will be changed after some specific time period.....

For e.g Sheet1 will be changed after 10 sec to Sheet 2.

Hope you understand the requirement.

Regards,

Mohammad

[Anonymous]

ok yup got it.

you will be opening the document at particular sheet right

say you have got 3 sheets

take down the now() in a variable say vStart

on open event set vActiveSheet=1

vActiveSheet=if(now()-vStart>=10 seconds AND now()-vStart<=20 seconds ,2,3)

you can keep add if statements in case you have more than 3 sheets

and on the sheet properties you can mention condition with the appropriate value of variable vActiveSheet

[mohammadkhatimi]

Have u tried on access point??

N Share me .qvw...

Regards

Mohammad

[Anonymous]

i have just given pseudo code, if you have qvw please share will try it

[#7]

GOTO TRIGGERS ADD ACTIONS SELECT SHEET IDS CLIK OK WILL AUTOMATICALLY CHANGE SHEETS AUTOMATICALLY USING VARIABLES ALSO

[#8]

using triggers we can automatically change sheets in access point goto sheet propertys triggers add actions select sheet id apply ok close document we can change sheets position.

[mohammadkhatimi]

PFA...

When u implement any logic kindly check whether its working on access point....

Regards

Mohammad

[mohammadkhatimi]

Hi...Mahammad

I want to change sheets automatically without any click....and within a specific period of time...

Please help me to solve this problem it little bit urgent...

Regards,

Mohammad