Open a form with subform in MDE

[Illya Havsiyevych]

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

[Illya Havsiyevych]

Hello again

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

illya

"Illya Havsiyevych" <ga***@ukr.net> wrote in message
news:bl***********@news.wnet.ua...

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

[Illya Havsiyevych]

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" <ga***@ukr.net> wrote in message
news:bl***********@news.wnet.ua...

Hello again

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

illya

"Illya Havsiyevych" <ga***@ukr.net> wrote in message
news:bl***********@news.wnet.ua...

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

[Illya Havsiyevych]

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" <ga***@ukr.net> wrote in message
news:bl***********@news.wnet.ua...

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" <ga***@ukr.net> wrote in message
news:bl***********@news.wnet.ua...

Hello again

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

illya

"Illya Havsiyevych" <ga***@ukr.net> wrote in message
news:bl***********@news.wnet.ua...

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