|
security
newsgroups
|
|||||||||||||||||||||||
|
|||||||||||||||||||||||
from mdb how to openForm a form in a referenced mde fileFrom an mdb file I can call procedures and functions from a referenced mde
file, but I cannot figure out how to open forms or reports that are in the mde file. my mdb file Code: docmd.openForm "Form1" The Form1 is in the mde file, yet I get the error, "the form name Form1 is mispelled or referes to an object that does not exist" Is prefixing required, or am I missing simething else? Thanks, -- Jay Jay wrote:
> From an mdb file I can call procedures and functions from a Not positive, but I believe you will need a public function in the MDE that > referenced mde file, but I cannot figure out how to open forms or > reports that are in the mde file. > my mdb file Code: > docmd.openForm "Form1" > The Form1 is in the mde file, yet I get the error, > "the form name Form1 is mispelled or referes to an object that does > not exist" Is prefixing required, or am I missing simething else? > Thanks, opens the form for you. You can make this generic so that you can pass the form name as an argument and then you only need to build one function. -- Rick Brandt, Microsoft Access MVP Email (as appropriate) to... RBrandt at Hunter dot com Rick,
Thanks, the public procedure in the mde file worked. -- Show quoteHide quoteJay "Rick Brandt" wrote: > Jay wrote: > > From an mdb file I can call procedures and functions from a > > referenced mde file, but I cannot figure out how to open forms or > > reports that are in the mde file. > > my mdb file Code: > > docmd.openForm "Form1" > > The Form1 is in the mde file, yet I get the error, > > "the form name Form1 is mispelled or referes to an object that does > > not exist" Is prefixing required, or am I missing simething else? > > Thanks, > > Not positive, but I believe you will need a public function in the MDE that > opens the form for you. You can make this generic so that you can pass the > form name as an argument and then you only need to build one function. > > -- > Rick Brandt, Microsoft Access MVP > Email (as appropriate) to... > RBrandt at Hunter dot com > > > This feature of A95 was disabled in a service pack. There was a well
known work around that enabled you to alter your forms so that they could be opened, and that was disabled in A2003. For compatibility with A2003, you will have to use a public function to open your forms. (david) Show quoteHide quote "Jay" <gunderj@ommunity.nospam> wrote in message news:B4CE61ED-3B29-4E7E-9FF6-6F6EF82402A5@microsoft.com... > From an mdb file I can call procedures and functions from a referenced mde > file, but I cannot figure out how to open forms or reports that are in the > mde file. > my mdb file Code: > docmd.openForm "Form1" > The Form1 is in the mde file, yet I get the error, > "the form name Form1 is mispelled or referes to an object that does not exist" > Is prefixing required, or am I missing simething else? > Thanks, > -- > Jay 
Other interesting topics
Workgroup locks database even when all users are shut down.
Security restrictions and table linking Allow Help Desk to Reset Passwords Without Full Admins Permissions Necessary Permissions secured database Login in dynamically Drop Down on Table Access Database Security Remove Security from Access Lost My Permissions |
|||||||||||||||||||||||
