Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations sizbut on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

If I have another Access object defined, how do I call its functions

Status
Not open for further replies.
WantsToLearn

WantsToLearn

Programmer
Feb 15, 2003
147
US
Lets say I have an Access object named dbs which is currently opened to another database named Database2 which has a function named Function1 which returns a string value.

Can I do anything like the following:

strText = dbs.somequalification.Function1

I have gotten it to work with dbs.Eval("function1") but that seems to be pretty slow. Is there a better way!

Thank you!
 
Status
Not open for further replies.

Similar threads

morechocolate
  • Locked
  • Question
run-tune error 3704 operation is not allowed when the object is codes: I don't think so.
Replies
7
Views
998
morechocolate
morechocolate
IcarusHallsorts
  • Locked
  • Question
I have a column of data in Column A
Replies
3
Views
365
Andrzejek
Andrzejek
remeng
  • Locked
  • Solved
Run-time error '429': ActiveX component can't create object From Excel to Word
Replies
9
Views
1K
remeng
remeng
office365
  • Locked
  • Question
i have a problem with a button sele 2
Replies
15
Views
576
combo
combo
remeng
  • Locked
  • Question
If obsolete - deactivate all but one macro
Replies
6
Views
399
mintjulep
M

Part and Inventory Search

Sponsor

Back
Top