PageName to Textbox

[Guest]

Hi!

I have a form with pages in TabCtl0.
Is possible to paste each PageName of this pages to textboxes in same form,
type:

Textbox1
Me!txtPageName = Forms!F_FormName!TabCtl0!PageName1

Textbox2
Me!txtPageName = Forms!F_FormName!TabCtl0!PageName2

Thanks in advance.
an

 

[Ken Snell \(MVP\)]

Try these:

Me!txtPageName = Forms!F_FormName!TabCtl0!Page(0).Name

Me!txtPageName = Forms!F_FormName!TabCtl0!Page(1).Name

 

[Ken Snell \(MVP\)]

Typo in first post:

Try these:

Me!txtPageName = Forms!F_FormName!TabCtl0!Pages(0).Name

Me!txtPageName = Forms!F_FormName!TabCtl0!Pages(1).Name

 

[ruralguy via AccessMonster.com]

Try:
Me!txtPageName = Me.TabCtl0.Pages(Me.TabCtl0).Name

 

[Guest]

Return:
#Name?

Try:
Me!txtPageName = Me.TabCtl0.Pages(Me.TabCtl0).Name


--
HTH - RuralGuy (RG for short) acXP WinXP Pro
Please post back to this forum so all may benefit.

Message posted via AccessMonster.com

 

[Guest]

Return:
#Name?

Typo in first post:

Try these:

Me!txtPageName = Forms!F_FormName!TabCtl0!Pages(0).Name

Me!txtPageName = Forms!F_FormName!TabCtl0!Pages(1).Name

 

[ruralguy via AccessMonster.com]

Either you TabCtl is not named TabCtl0 or the TextBox is not named
txtPageName

Return:
#Name?

Try:
Me!txtPageName = Me.TabCtl0.Pages(Me.TabCtl0).Name

[quoted text clipped - 13 lines]

 

[Guest]

Sorry, but are both correct.
They had been written with Copy/paste…
(?)
Thanks.

Either you TabCtl is not named TabCtl0 or the TextBox is not named
txtPageName

Return:
#Name?

Try:
Me!txtPageName = Me.TabCtl0.Pages(Me.TabCtl0).Name

[quoted text clipped - 13 lines]

Thanks in advance.
an

 

[ruralguy via AccessMonster.com]

Type the line using periods "." rather than the bang "!" and let the
Intellisense supply the control name. See if it comes up with the same names
as you have supplied.

Sorry, but are both correct.
They had been written with Copy/paste…
(?)
Thanks.

Either you TabCtl is not named TabCtl0 or the TextBox is not named
txtPageName

[quoted text clipped - 7 lines]

 

[Ken Snell \(MVP\)]

Suggests that
1) You don't have a form named "F_FormName".
or
2) A form named "F_FormName" is not open when your code runs.
or
3) You want to read the name from a different form than "F_FormName".

You'll need to tell us more about your setup ...

 

[Ken Snell \(MVP\)]

Sorry -- try this:

Me!txtPageName = Forms!F_FormName!TabCtl0.Pages(0).Name

Me!txtPageName = Forms!F_FormName!TabCtl0.Pages(1).Name

 

[Guest]

Sorry my ignorance.
What is Intellisense, please?

Type the line using periods "." rather than the bang "!" and let the
Intellisense supply the control name. See if it comes up with the same names
as you have supplied.

Sorry, but are both correct.
They had been written with Copy/paste…
(?)
Thanks.

Either you TabCtl is not named TabCtl0 or the TextBox is not named
txtPageName

[quoted text clipped - 7 lines]

Thanks in advance.
an

 

[ruralguy via AccessMonster.com]

After you type Me. a list pops up to select the next choice.

Sorry my ignorance.
What is Intellisense, please?

Type the line using periods "." rather than the bang "!" and let the
Intellisense supply the control name. See if it comes up with the same names

[quoted text clipped - 10 lines]

 

[Guest]

Sorry, but:

1) Already renamed the form exactly to F_FormName
2) The F_FormName is open when code runs
3) I read in F_FormName

4) Your expession is in Control Source of the F_FormName

In adition, I erase all in this form, except Tab Control with Name TabCtl0

:-(

Thanks

 

[ruralguy via AccessMonster.com]

Put the code in the OnCurrent event of the form as a test.

Sorry, but:

1) Already renamed the form exactly to F_FormName
2) The F_FormName is open when code runs
3) I read in F_FormName

4) Your expession is in Control Source of the F_FormName

In adition, I erase all in this form, except Tab Control with Name TabCtl0

:-(

Thanks

Sorry -- try this:

[quoted text clipped - 27 lines]

 

[Guest]

When open the form:

Run-time error '2448':
"You can't a value to this object"

After open the form, the textbox:
#Name?

Put the code in the OnCurrent event of the form as a test.

Sorry, but:

1) Already renamed the form exactly to F_FormName
2) The F_FormName is open when code runs
3) I read in F_FormName

4) Your expession is in Control Source of the F_FormName

In adition, I erase all in this form, except Tab Control with Name TabCtl0

:-(

Thanks

Sorry -- try this:

[quoted text clipped - 27 lines]

Thanks in advance.
an

--
HTH - RuralGuy (RG for short) acXP WinXP Pro
Please post back to this forum so all may benefit.

Message posted via AccessMonster.com

 

[Ken Snell \(MVP\)]

The Control Source expression should be this:

= Forms!F_FormName!TabCtl0.Pages(0).Name

 

[Guest]

YEEESSS!!!

Thank you very much for your help.
(04H05, I go to sleep)
A good weekend for you!
an