Tech or Treat! Write an article about your scariest tech disaster to win gadgets!Learn more

x
?
Solved

Polymorphism In Access

Posted on 2004-10-19
12
Medium Priority
?
321 Views
Last Modified: 2012-06-21
in want to use polymorphism in VBA

the thing i try is this

dim frm as form
set frm = Forms("a type of a form")
msgbox frm.MyFunction
set frm = Forms("another form")
msgbox frm.MyFunction

MyFunction is declared in the 2 custom form i created but I don't in the standard Form class
I also tried created frm as Variant or a Object but did'nt worked
0
Comment
Question by:numeriss
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 6
  • 3
  • 2
  • +1
12 Comments
 
LVL 10

Accepted Solution

by:
ALaRiva earned 900 total points
ID: 12351068
If the Function is to be called from another object outside of that form's scope, then you need to make sure that it's set to Public instead of Private.

i.e.
Public Function MyFunction()

instead of
Private Function MyFunction()

-Anthony
0
 

Author Comment

by:numeriss
ID: 12351088
this is the function i use in every form

Public Function MyFunction() As String
  MyFunction = "Administration"
End Function
0
 
LVL 10

Assisted Solution

by:ALaRiva
ALaRiva earned 900 total points
ID: 12351201
What's the purpose of the Function?  What do you use it for?  

If you are using the same thing in every form, then why not use one Public Function in a standard Module instead?

-Anthony

0
NFR key for Veeam Agent for Linux

Veeam is happy to provide a free NFR license for one year.  It allows for the non‑production use and valid for five workstations and two servers. Veeam Agent for Linux is a simple backup tool for your Linux installations, both on‑premises and in the public cloud.

 
LVL 51

Assisted Solution

by:Steve Bink
Steve Bink earned 600 total points
ID: 12351206
You also have to be sure the form is loaded (read as: opened) before referencing it.  The Forms collection only holds forms currently loaded by Access.
0
 

Author Comment

by:numeriss
ID: 12351446
I damnit I was mistyping the MyFunction and since intellisence don't show up on polymorphism I didn't noticied
0
 
LVL 10

Expert Comment

by:ALaRiva
ID: 12351475
Well, that'll do it to ya!!! LOL, Glad you got it sorted out.
0
 
LVL 10

Expert Comment

by:ALaRiva
ID: 12351486
What's with the B Grade?  

Not that Points or Grades matter to me, but I know that we were going through all of the standard protocols for answering a question like this, yet you gave us a B?
0
 
LVL 10

Expert Comment

by:ALaRiva
ID: 12351503
Definitely not trying to cause any trouble either, I'm just curious.   Is that a standard grade when you solve the issue yourself?

-Anthony
0
 
LVL 51

Expert Comment

by:Steve Bink
ID: 12351582
The 'standard' response would have been to PAQ/Refund or Delete/Refund the question.  But if the questionner wants to award points, I doubt very much any of us will stop them.  :)

numeriss:  If you would like to have your points refunded for this question, post a request in the Community Support TA.  Good luck with the rest of your project!
0
 
LVL 10

Expert Comment

by:ALaRiva
ID: 12351650
@routinet,
    Thanks for the clarification.  I wasn't sure, but I know that others get upset with B Grades so I figured I would ask what the reasoning and standard is.

-Anthony
0
 
LVL 51

Expert Comment

by:Steve Bink
ID: 12351814
It's all good.  If you are interested in seeing the suggested guidelines for grading questions, take a look at:

http://www.experts-exchange.com/help.jsp#hi73

Remove the "#hi73" to start at the beginning of the FAQ (or scroll up!)
0
 
LVL 1

Expert Comment

by:powlin
ID: 12352259
I'm grading depending on who the answer helped me if the answer was right i put excellent, if the answer was good but not the one i looked for but helped me finding the problem i give B and I think that B stand for good, that is a really positive grade, i'm happy when I get B on my school exam hehe
0

Featured Post

On Demand Webinar: Networking for the Cloud Era

Did you know SD-WANs can improve network connectivity? Check out this webinar to learn how an SD-WAN simplified, one-click tool can help you migrate and manage data in the cloud.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

You need to know the location of the Office templates folder, so that when you create new templates, they are saved to that location, and thus are available for selection when creating new documents.  The steps to find the Templates folder path are …
If you need a simple but flexible process for maintaining an audit trail of who created, edited, or deleted data from a table, or multiple tables, and you can do all of your work from within a form, this simple Audit Log will work for you.
What’s inside an Access Desktop Database. Will look at the basic interface, Navigation Pane (Database Container), Tables, Queries, Forms, Report, Macro’s, and VBA code.
Access reports are powerful and flexible. Learn how to create a query and then a grouped report using the wizard. Modify the report design after the wizard is done to make it look better. There will be another video to explain how to put the final p…

647 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question