link form from ext.mdb

[Guest]

hi,
I need to link one form from diferent database,
using one subform.. (from one mdb to another)
or make this efect ussing other object.

thanks for your help.

 

[John Vinson]

hi,
I need to link one form from diferent database,
using one subform.. (from one mdb to another)
or make this efect ussing other object.

thanks for your help.

You can't link Forms - you can link Tables, but a Form and a Subform
must reside within the same .mdb file. You can Import the form, but
note that any design changes in one database will apply only within
that database.

John W. Vinson[MVP]

 

[Guest]

Thanks for your last comment..

I try to run the the next code :

Function Update_Objet_OLE()
On Error GoTo Error_cmdOLEAuto_Click
With Me![OLEIndependient1]
.Enabled = True
.Locked = False
.OLETypeAllowed = acOLEEither
.Class = "Access.Application"
.SourceDoc = "C:\Access_Proyects\bd1.mdb"
.SourceItem = "Form1"
.Action = acOLECreateLink
.SizeMode = acOLESizeZoom
End With
Exit_cmdOLEAuto_Click:
Exit Function
Error_cmdOLEAuto_Click:
MsgBox CStr(Err) & " " & Err.Description
Resume Exit_cmdOLEAuto_Click
End Function

...that call from one button in the form ..
and i receive the next error :

2785 The OLE server can't open the object.

I find in examples from web pages about making
Ole objects from Word,Excel,P.Point, but
the Access object is very dificult to find.
(from the Access Application)

Can you help me with this error?

Thank for your help.

 

[John Vinson]

Can you help me with this error?

I'm sorry, I cannot - I've avoided Access automation as much as
possible!

I'd suggest reposting a new thread, mentioning your Access version and
posting the code; perhaps the Formscoding newsgroup would be better.


John W. Vinson[MVP]