default form and format

  • Thread starter Thread starter m ary
  • Start date Start date
M

m ary

Hello -
I wanted to make a standard format for any db I create so
my forms look unison and control flow is similar - how
can I set the form as a default. ( and set a standard
group of macros I move from db to db)
and is there a way to run a qry but use the same form
without having to create a form for each qry - I know
that is basic design idea - but can someone please tell
me how - it would save so much time because often I need
to modify a form.
thanks in advance.
oh yes, another question -- in the existing db I am
working on there are extra qrys that were used in design
but really should be removed from the db file -- is there
a way to find out which qrys I can remove ?
Again, thank thank thank you
 
Reply shown below.

m ary said:
Hello -
I wanted to make a standard format for any db I create so
my forms look unison and control flow is similar - how
can I set the form as a default. ( and set a standard
group of macros I move from db to db)
Click to expand...

Why not just create a database with just the objects you want then copy the
database for each new one you want to create.
and is there a way to run a qry but use the same form
without having to create a form for each qry - I know
that is basic design idea - but can someone please tell
me how - it would save so much time because often I need
to modify a form.
Click to expand...

You can change the source for a form using code, however, the text boxes on
the form are linked to a specific name. Unless all your queries have the
same field names, this won't work. You can always change the source for
each text box too, but that will require a lot of coding. If you really
want to do this I would sugegst modifying your queries so that all the
fields have the same names, then you can code the source for the form when
you need them.
thanks in advance.
oh yes, another question -- in the existing db I am
working on there are extra qrys that were used in design
but really should be removed from the db file -- is there
a way to find out which qrys I can remove ?
Again, thank thank thank you
Click to expand...
I don't know about this one. There might be a 3rd party program, but I
don't know of any way to do this through Access. Good luck on the rest.

Kelvin
 
Back
Top