Re: Accessing forms properties
- From: "peterDavey" <peter.davey@xxxxxxxxxxxxx>
- Date: Fri, 12 Aug 2005 09:01:40 +1000
Ron,
Thanks for your reply. I had thought of developing a 'user interface'
module in the database sometime in the future. I was looking to use the
tags as a 'quick and dirty' short time solution. On reflection I might go
with the table because, as the number of forms increases, I'll want to
categorize them but the biggest advantage will be that using a query I'll be
able to easily sort the list.
cheers
peterD
"Ron Weiner" <weinNoSpam1@xxxxxxxxxxxxxx> wrote in message
news:eWhQ60nnFHA.3036@xxxxxxxxxxxxxxxxxxxxxxx
> 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
> > >
> > >
> >
> >
>
>
.
- References:
- Accessing forms properties
- From: peterDavey
- Re: Accessing forms properties
- From: peterDavey
- Re: Accessing forms properties
- From: Ron Weiner
- Accessing forms properties
- Prev by Date: Calcuate Start Date
- Next by Date: Limit ability to resize grid columns
- Previous by thread: Re: Accessing forms properties
- Next by thread: Keeping Form view in Proportion
- Index(es):
Relevant Pages
|
