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

Open a form with subform in MDE

P: n/a
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
Nov 12 '05 #1
Share this Question
Share on Google+
3 Replies


P: n/a
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

Nov 12 '05 #2

P: n/a
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


Nov 12 '05 #3

P: n/a
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



Nov 12 '05 #4

This discussion thread is closed

Replies have been disabled for this discussion.