By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,851 Members | 1,492 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,851 IT Pros & Developers. It's quick & easy.

can I access a form in an mdb from another mdb

P: n/a
I have 2 mdbs (one is a menu system - system.mdb, the second is an
inventory subsystem - inventory.mdb) and there will be more subsystems

the system.mdb knows what forms / reports / submenus / etc to display
and it displays its own objects

now I want to open and use forms in inventory.mdb without using
createObject(access.application..) which opens a separate copy of
inventory.mdb

so in system.mdb, I 'referenced' inventory.mdb and
in inventory.mdb, I created an openForm function that does
docmd.openform....

this works ok for simple forms like 'unit of measure' that have an id
& description

but if the form uses DLookup(), I get an error saying that the table
cannot be found... note... system.mdb does NOT have links to
inventory.mdb tables (and I don't really want to set them up, but...)

does anyone have any ideas on how else to do this ?
Nov 12 '05 #1
Share this Question
Share on Google+
1 Reply


P: n/a
On 5 Jan 2004 18:05:50 -0800, le*********@natpro.com (Roger) wrote:

If you don't like CreateObject, use GetObject. Then if GetObject
fails, you can fall back on CreateObject.

The accounting software UA is set up the way you are describing.

-Tom.

I have 2 mdbs (one is a menu system - system.mdb, the second is an
inventory subsystem - inventory.mdb) and there will be more subsystems

the system.mdb knows what forms / reports / submenus / etc to display
and it displays its own objects

now I want to open and use forms in inventory.mdb without using
createObject(access.application..) which opens a separate copy of
inventory.mdb

so in system.mdb, I 'referenced' inventory.mdb and
in inventory.mdb, I created an openForm function that does
docmd.openform....

this works ok for simple forms like 'unit of measure' that have an id
& description

but if the form uses DLookup(), I get an error saying that the table
cannot be found... note... system.mdb does NOT have links to
inventory.mdb tables (and I don't really want to set them up, but...)

does anyone have any ideas on how else to do this ?


Nov 12 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.