Do you know about UserForms in Access?
UserForms seems to me to be just like VB Forms, or Excel UserForms.
They are not Access objects and have little or nothing to do with
Access forms. In the Project Explorer that appear in a Forms folder,
far removed from Microsoft Access Class Objects. They have a very full
set of editable properties, code modules, controls etc.
They can be created in Access 2003.
That's about all I know. I've created them, put controls on them (not
data controls of course, but, for example, command buttons).
Now I have only two problems.
The first is that creating them totally and AFAICT irrevocably corrupts
the VBA project of the Access database and by extension anything at all
of the db that has to to do with VBA (which is why I haven't told you
how I created them; if you're going to cook your DB then you should
come up with the recipe yourself). One more time; THEY HAVE ALWAYS
TRASHED MY DB, SO I STRONGLY SUGGEST YOU USE ONLY A THROW_AWAY_COPY IF
YOU EXPERIMENT. Some people will think of this as a negative.
and
I can't open them.
I don't find references to these in Google or in MSDN but myabe I'm not
recognizing these when I see them.
Would they be good for anything? I'm not sure.
Why did I fool with these. A few weeks ago someone in here asked about
the VBA Load Sub. It seemed to be related to a VBA form and not an
Access form. So I wanted to see if I could create a VBA form.And yes,
one can.
I thought one might need the VBA Extensibility reference to do this,
but it nows seems (75%) that I do not.
So, any experience, opinion, reference about these?
UserForms seems to me to be just like VB Forms, or Excel UserForms.
They are not Access objects and have little or nothing to do with
Access forms. In the Project Explorer that appear in a Forms folder,
far removed from Microsoft Access Class Objects. They have a very full
set of editable properties, code modules, controls etc.
They can be created in Access 2003.
That's about all I know. I've created them, put controls on them (not
data controls of course, but, for example, command buttons).
Now I have only two problems.
The first is that creating them totally and AFAICT irrevocably corrupts
the VBA project of the Access database and by extension anything at all
of the db that has to to do with VBA (which is why I haven't told you
how I created them; if you're going to cook your DB then you should
come up with the recipe yourself). One more time; THEY HAVE ALWAYS
TRASHED MY DB, SO I STRONGLY SUGGEST YOU USE ONLY A THROW_AWAY_COPY IF
YOU EXPERIMENT. Some people will think of this as a negative.
and
I can't open them.
I don't find references to these in Google or in MSDN but myabe I'm not
recognizing these when I see them.
Would they be good for anything? I'm not sure.
Why did I fool with these. A few weeks ago someone in here asked about
the VBA Load Sub. It seemed to be related to a VBA form and not an
Access form. So I wanted to see if I could create a VBA form.And yes,
one can.
I thought one might need the VBA Extensibility reference to do this,
but it nows seems (75%) that I do not.
So, any experience, opinion, reference about these?
Comment