Groups | Search | Server Info | Keyboard shortcuts | Login | Register [http] [https] [nntp] [nntps]


Groups > comp.databases.ms-access > #11267

Re: Referenced database

From "Phil" <phil@stantonfamily.co.uk>
Newsgroups comp.databases.ms-access
Subject Re: Referenced database
Date 2015-10-29 17:28 +0000
Organization Aioe.org NNTP Server
Message-ID <n0tkv8$ro1$1@speranza.aioe.org> (permalink)
References <n0t22n$cnk$1@speranza.aioe.org> <464c8f76-12f8-480c-9366-7e8c2390167e@googlegroups.com>

Show all headers | View raw


On 29/10/2015 13:57:47, Patrick Finucane wrote:
> On Thursday, October 29, 2015 at 8:05:53 AM UTC-4, Phil wrote:
>> I have a main database, let's call it Main with a function in it
>> Public Function TestMsg()
>>      Msgbox "Test"
>> End Function
>>
>> I have a referenced database called Utilities.Accdb
>> From this I want to call the TestMsg function.
>> Call TestMsg    gives error Sub or Function not defined
>> Call CurrentProject.testmsg gives Object doesn't support this property or
>> method
>>
>> Any ideas please
>>
>> Phil
> 
> If I understand you correctly, this should help.
> https://msdn.microsoft.com/en-us/library/office/ff193559.aspx
> 

Thanks Patrick worked a treat

Phil

Back to comp.databases.ms-access | Previous | Next — Previous in thread | Next in thread | Find similar | Unroll thread


Thread

Referenced database "Phil" <phil@stantonfamily.co.uk> - 2015-10-29 12:05 +0000
  Re: Referenced database Patrick Finucane <patrickfinucanetx@gmail.com> - 2015-10-29 06:57 -0700
    Re: Referenced database "Phil" <phil@stantonfamily.co.uk> - 2015-10-29 17:28 +0000
      Re: Referenced database Sky <Sky@NoSpam.com> - 2015-11-01 11:18 -0500

csiph-web