how to pass form name to a module?
in [General]
|
Prev: Custom Popup toolbar
Next: thumbnail in field?
From: Jon on 19 May 2010 19:32 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 19 May 2010 19:51 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 19 May 2010 19:59 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 20 May 2010 03:47 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 20 May 2010 04:48
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!!! >> >> >> . >> |