From: Jon on
Greeting,
I want to display the current form name when clicke on a button in the form,
but I want to use a module for that? any help please!!!
From: Jeff Boyce on
Jon

Something like (untested):

YourFunction(strName as String)
...


and to call it from within a form, on a button click, you could use:

Call YourFunction(Me.Name)

Good luck!

Regards

Jeff Boyce
Microsoft Access MVP

--
Disclaimer: This author may have received products and services mentioned
in this post. Mention and/or description of a product or service herein
does not constitute endorsement thereof.

Any code or pseudocode included in this post is offered "as is", with no
guarantee as to suitability.

You can thank the FTC of the USA for making this disclaimer
possible/necessary.

"Jon" <Jon(a)discussions.microsoft.com> wrote in message
news:C9497691-E686-4E3B-98B8-23358826251B(a)microsoft.com...
> Greeting,
> I want to display the current form name when clicke on a button in the
> form,
> but I want to use a module for that? any help please!!!


From: Dorian on
Call the function in your OnClick event.
Pass the form name as a parameter to your procedure or function.
Call DisplayFormName("formname")
-- Dorian
"Give someone a fish and they eat for a day; teach someone to fish and they
eat for a lifetime".


"Jon" wrote:

> Greeting,
> I want to display the current form name when clicke on a button in the form,
> but I want to use a module for that? any help please!!!
From: Jon on
Thank you all,
but could you please provide full code? also, I want to to display the form
name in msgbox please?

"Jeff Boyce" wrote:

> Jon
>
> Something like (untested):
>
> YourFunction(strName as String)
> ...
>
>
> and to call it from within a form, on a button click, you could use:
>
> Call YourFunction(Me.Name)
>
> Good luck!
>
> Regards
>
> Jeff Boyce
> Microsoft Access MVP
>
> --
> Disclaimer: This author may have received products and services mentioned
> in this post. Mention and/or description of a product or service herein
> does not constitute endorsement thereof.
>
> Any code or pseudocode included in this post is offered "as is", with no
> guarantee as to suitability.
>
> You can thank the FTC of the USA for making this disclaimer
> possible/necessary.
>
> "Jon" <Jon(a)discussions.microsoft.com> wrote in message
> news:C9497691-E686-4E3B-98B8-23358826251B(a)microsoft.com...
> > Greeting,
> > I want to display the current form name when clicke on a button in the
> > form,
> > but I want to use a module for that? any help please!!!
>
>
> .
>
From: Alexander Achenbach on
Public Function MyFunction()
On Error Resume Next
MsgBox Screen.ActiveForm.Name
On Error Goto 0
MyFunction=0
End Function



"Jon" <Jon(a)discussions.microsoft.com> schrieb im Newsbeitrag
news:A6F9AF78-F434-42FC-88A8-825441B2D4D7(a)microsoft.com...
> Thank you all,
> but could you please provide full code? also, I want to to display the
> form
> name in msgbox please?
>
> "Jeff Boyce" wrote:
>
>> Jon
>>
>> Something like (untested):
>>
>> YourFunction(strName as String)
>> ...
>>
>>
>> and to call it from within a form, on a button click, you could use:
>>
>> Call YourFunction(Me.Name)
>>
>> Good luck!
>>
>> Regards
>>
>> Jeff Boyce
>> Microsoft Access MVP
>>
>> --
>> Disclaimer: This author may have received products and services mentioned
>> in this post. Mention and/or description of a product or service herein
>> does not constitute endorsement thereof.
>>
>> Any code or pseudocode included in this post is offered "as is", with no
>> guarantee as to suitability.
>>
>> You can thank the FTC of the USA for making this disclaimer
>> possible/necessary.
>>
>> "Jon" <Jon(a)discussions.microsoft.com> wrote in message
>> news:C9497691-E686-4E3B-98B8-23358826251B(a)microsoft.com...
>> > Greeting,
>> > I want to display the current form name when clicke on a button in the
>> > form,
>> > but I want to use a module for that? any help please!!!
>>
>>
>> .
>>

 |  Next  |  Last
Pages: 1 2
Prev: Custom Popup toolbar
Next: thumbnail in field?