Hello All

I have splitted my MDB into MDE and data MDB.
In old whole MDB I have next piece of code to
create an instance of a form with subform.

.....
Dim objForm As New Form_frmParentFormWithSubForm

objEditForms.Add objForm
With objForm
.FillValues
.Visible = True
End With
.....


When I save it as MDE this code opens only a parent form.
I have next ideas, Please comment


- It comes from that form in MDE is not visible outside
- it can be fixed, I need ....
- it can not be fixed

- I need use special naming with usign Namespaces like MDE module name

- I need create sub form by new as well and assign subform to
subform/subreport property
- it can not be done because subform/subreport property is readonly
- it can be done by "special" SysCmd or etc

- How DoCmd.OpenForm works ? Because without creating an instances I can
open
form with subform outside MDE
- I need to call DoCmd.OpenForm by special way
- It will not help

- I need to write C/C++ DLL to write special version of DoCmd.OpenForm

- I need use MS Forms

- I need to use third company's OCX

- Any other



Thank You
illya

Hello again

Also I tryed to use "table.tableName" as SourceObject of SubForm/SubReport
- no success

illya

"Illya Havsiyevych" <gavsi@ukr.net> wrote in message
news:blsfpj$2vol$1@news.wnet.ua...[color=blue]
> Hello All
>
> I have splitted my MDB into MDE and data MDB.
> In old whole MDB I have next piece of code to
> create an instance of a form with subform.
>
> ....
> Dim objForm As New Form_frmParentFormWithSubForm
>
> objEditForms.Add objForm
> With objForm
> .FillValues
> .Visible = True
> End With
> ....
>
>
> When I save it as MDE this code opens only a parent form.
> I have next ideas, Please comment
>
>
> - It comes from that form in MDE is not visible outside
> - it can be fixed, I need ....
> - it can not be fixed
>
> - I need use special naming with usign Namespaces like MDE module name
>
> - I need create sub form by new as well and assign subform to
> subform/subreport property
> - it can not be done because subform/subreport property is readonly
> - it can be done by "special" SysCmd or etc
>
> - How DoCmd.OpenForm works ? Because without creating an instances I can
> open
> form with subform outside MDE
> - I need to call DoCmd.OpenForm by special way
> - It will not help
>
> - I need to write C/C++ DLL to write special version of DoCmd.OpenForm
>
> - I need use MS Forms
>
> - I need to use third company's OCX
>
> - Any other
>
>
>
> Thank You
> illya
>
>[/color]

Hi

Maybe that because of MDE hasn't also own system tables
and opening of form uses them
Don't know :(

Any idea ?

illya


"Illya Havsiyevych" <gavsi@ukr.net> wrote in message
news:blv2gb$1h62$1@news.wnet.ua...[color=blue]
> Hello again
>
> Also I tryed to use "table.tableName" as SourceObject of SubForm/SubReport
> - no success
>
> illya
>
> "Illya Havsiyevych" <gavsi@ukr.net> wrote in message
> news:blsfpj$2vol$1@news.wnet.ua...[color=green]
> > Hello All
> >
> > I have splitted my MDB into MDE and data MDB.
> > In old whole MDB I have next piece of code to
> > create an instance of a form with subform.
> >
> > ....
> > Dim objForm As New Form_frmParentFormWithSubForm
> >
> > objEditForms.Add objForm
> > With objForm
> > .FillValues
> > .Visible = True
> > End With
> > ....
> >
> >
> > When I save it as MDE this code opens only a parent form.
> > I have next ideas, Please comment
> >
> >
> > - It comes from that form in MDE is not visible outside
> > - it can be fixed, I need ....
> > - it can not be fixed
> >
> > - I need use special naming with usign Namespaces like MDE module name
> >
> > - I need create sub form by new as well and assign subform to
> > subform/subreport property
> > - it can not be done because subform/subreport property is readonly
> > - it can be done by "special" SysCmd or etc
> >
> > - How DoCmd.OpenForm works ? Because without creating an instances I can
> > open
> > form with subform outside MDE
> > - I need to call DoCmd.OpenForm by special way
> > - It will not help
> >
> > - I need to write C/C++ DLL to write special version of DoCmd.OpenForm
> >
> > - I need use MS Forms
> >
> > - I need to use third company's OCX
> >
> > - Any other
> >
> >
> >
> > Thank You
> > illya
> >
> >[/color]
>
>[/color]

I'm sorry very much,
Just subform work Ok
The subform with bound data table gives error

I created recordset by VBA and bound it at Form_Load time
and became Ok

Thank You again

"Illya Havsiyevych" <gavsi@ukr.net> wrote in message
news:blv3f2$1hpn$1@news.wnet.ua...[color=blue]
> Hi
>
> Maybe that because of MDE hasn't also own system tables
> and opening of form uses them
> Don't know :(
>
> Any idea ?
>
> illya
>
>
> "Illya Havsiyevych" <gavsi@ukr.net> wrote in message
> news:blv2gb$1h62$1@news.wnet.ua...[color=green]
> > Hello again
> >
> > Also I tryed to use "table.tableName" as SourceObject of[/color][/color]
SubForm/SubReport[color=blue][color=green]
> > - no success
> >
> > illya
> >
> > "Illya Havsiyevych" <gavsi@ukr.net> wrote in message
> > news:blsfpj$2vol$1@news.wnet.ua...[color=darkred]
> > > Hello All
> > >
> > > I have splitted my MDB into MDE and data MDB.
> > > In old whole MDB I have next piece of code to
> > > create an instance of a form with subform.
> > >
> > > ....
> > > Dim objForm As New Form_frmParentFormWithSubForm
> > >
> > > objEditForms.Add objForm
> > > With objForm
> > > .FillValues
> > > .Visible = True
> > > End With
> > > ....
> > >
> > >
> > > When I save it as MDE this code opens only a parent form.
> > > I have next ideas, Please comment
> > >
> > >
> > > - It comes from that form in MDE is not visible outside
> > > - it can be fixed, I need ....
> > > - it can not be fixed
> > >
> > > - I need use special naming with usign Namespaces like MDE module name
> > >
> > > - I need create sub form by new as well and assign subform to
> > > subform/subreport property
> > > - it can not be done because subform/subreport property is readonly
> > > - it can be done by "special" SysCmd or etc
> > >
> > > - How DoCmd.OpenForm works ? Because without creating an instances I[/color][/color][/color]
can[color=blue][color=green][color=darkred]
> > > open
> > > form with subform outside MDE
> > > - I need to call DoCmd.OpenForm by special way
> > > - It will not help
> > >
> > > - I need to write C/C++ DLL to write special version of DoCmd.OpenForm
> > >
> > > - I need use MS Forms
> > >
> > > - I need to use third company's OCX
> > >
> > > - Any other
> > >
> > >
> > >
> > > Thank You
> > > illya
> > >
> > >[/color]
> >
> >[/color]
>
>[/color]