Load Form?

[MacDermott]

The help file in Access 2000 has entries for Load and Show, suggesting a
usage similar to that in VB6.0.
But code like this fails:
Dim Frm as object
Set Frm=CurrentProj ect.AllForms(0)
Load Frm

with an error that the object can't be loaded or unloaded.

Anyone have any experience with this?

[Br@dley]

Re: Load Form?

MacDermott wrote:[color=blue]
> The help file in Access 2000 has entries for Load and Show,
> suggesting a usage similar to that in VB6.0.
> But code like this fails:
> Dim Frm as object
> Set Frm=CurrentProj ect.AllForms(0)
> Load Frm
>
> with an error that the object can't be loaded or unloaded.
>
> Anyone have any experience with this?[/color]


Load is a Visual Basic command, not Access.

This works...

Dim Frm As Object
Set Frm = CurrentProject. AllForms(0)
DoCmd.OpenForm Frm.Name

--
regards,

Bradley

A Christian Response

http://www.pastornet.net.au/response

[Lyle Fairfield]

Re: Load Form?

(I never can understand why people post simplistic answers in response
to someone who is experienced and knowlegeable and is discussing
his/her adventures with something new or not so well known.)

Load is also a VBA method. How to make it work? What we want, I think
or guess, is not a form object but a text manifestation of the form,
[similar to a .frm file in VB], which we can get with SaveAsText. We
can then copy the text into a Module, or LoadFromText it into a Module
(it's not going to be text as a form) and try Loading the Form from
that. It tries, but finds errors in the code/script/text. I'm assuming
if we could find what it wants in that text, we could modify our text
to comply and it would work.

Next question would be why? Answer: because it's there.

[Br@dley]

Re: Load Form?

Lyle Fairfield wrote:[color=blue]
> (I never can understand why people post simplistic answers in response
> to someone who is experienced and knowlegeable and is discussing
> his/her adventures with something new or not so well known.)[/color]

Yeah, good on ya Lyle.

<>
--
regards,

Bradley

A Christian Response

http://www.pastornet.net.au/response