Re: Accessing forms properties

PeterDavey

Here is another way to do this.

In that Access is a database why not use its inherent database capability to
create a Table of Forms, and keep all of the information about each form in
your application there. After all this is the way Access manages itself
(have a look at the system tables). You might have columns for user
friendly short names, verbose names, and the actual form names that the user
never sees. Need to add security later? Now you have a way to keep the
list of forms shown in your List Box synchronized to the users rights, by
simply adding a new column to the table.

This system would be no harder to maintain that an entry into the forms Tag
property or a custom property. This way the record source for the combo
becomes a Sql statement (also a very Access way of doing things). I believe
this is a more flexible and extensible way to manage the list of forms that
the user interacts with.

Good luck with your project.
--
Ron W
www.WorksRite.com
"peterDavey" <peter.davey@xxxxxxxxxxxxx> wrote in message
news:Ouw$MAjnFHA.4056@xxxxxxxxxxxxxxxxxxxxxxx
> Thanks Allen and Marsh for your replies. The Container().Documents...
> solution looks like the way to go - much better than using the Tag
property.
> cheers
> peterD
>
> "peterDavey" <peter.davey@xxxxxxxxxxxxx> wrote in message
> news:uxZSoMhnFHA.1996@xxxxxxxxxxxxxxxxxxxxxxx
> > G'day,
> > I'm pretty new to Access but have Excel VBA experience.
> >
> > I have an Access 2000 application with a number of forms and sub-forms.
> At
> > startup I display a form with a list box listing the forms I may want to
> > use. At the moment the form names are hard coded into the list boxe's
> > DataSource property.
> >
> > What I want to do is use the Tag property of each form to flag the forms
> > that I want listed in the list box. When the 'menu' form opens I need
the
> > code to loop through all forms and, where the tag property doesn't = 0,
> add
> > it to the list box.
> >
> > I've found that using the AllForms collection gives me access to all the
> > forms however I haven't been able to successfully access the Tag
property
> > using the Properties collection. Using the code:
> >
> > MsgBox
> > Application.CurrentProject.AllForms("Wards").Properties("Tag").Value
> >
> > generates an error: 'you entered an expression that has an invalid
> reference
> > to the tag property'
> >
> > Not sure what I'm doing wrong.
> >
> > cheers
> > peterDavey
> > Melbourne
> >
> >
>
>


.

Relevant Pages

  • Re: Accessing forms properties
    ... module in the database sometime in the future. ... > Ron W ... >> solution looks like the way to go - much better than using the Tag ...
    (microsoft.public.access.formscoding)
  • Reading Tag value of Forms
    ... Does anyone know if it is possible to read the 'tag' property of all forms ... using the AllForms collection? ... Dim strObjectList As String ... Dim obj As AccessObject ...
    (microsoft.public.access.formscoding)
Loading