G
Guest
If I want to set up two forms that have basically the same information is
there a way to copy one to set up the other without recreating a whole new
form?
there a way to copy one to set up the other without recreating a whole new
form?
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
J
Joan Wild
In the database window, select the form; hit Ctrl-C and then Ctrl-V,
providing a new name for the second form. Then open it in design view and
modify the Record Source property.
OK, that's how to do it, but why do you want to do this? You could change
the record source at runtime, or use filters/where clauses to filter what's
displayed to the user.
providing a new name for the second form. Then open it in design view and
modify the Record Source property.
OK, that's how to do it, but why do you want to do this? You could change
the record source at runtime, or use filters/where clauses to filter what's
displayed to the user.
G
Guest
That helps! But honestly, I don't know what you mean. I am so new to Access
and I am using two different books to help me along as I build this database
and it is kicking my rear! Every time I think I have it down I go to repeat
a step and can't remember what I did the last time. It is going to be a very
basic database to keep track of hard copy files and their locations
(Contracts, reference materials, etc.) I have just never done this before.
Sincerely, UGH Tammy
and I am using two different books to help me along as I build this database
and it is kicking my rear! Every time I think I have it down I go to repeat
a step and can't remember what I did the last time. It is going to be a very
basic database to keep track of hard copy files and their locations
(Contracts, reference materials, etc.) I have just never done this before.
Sincerely, UGH Tammy
J
Joan Wild
You may find that one of the templates at
http://office.microsoft.com/en-us/templates/CT011366831033.aspx
will suit what you need. Any of the collections databases (music, book,
video).
http://office.microsoft.com/en-us/templates/CT011366831033.aspx
will suit what you need. Any of the collections databases (music, book,
video).
G
Guest
Ms Wild, I am little unsure of how to make the template "my own" so to speak.
Any helpful suggestions? Should I just transfer the tables and data from
the one I started to the template or totally recreate the names and data in
the template to match what I need it to say?
I really appreciate your help!!!
Any helpful suggestions? Should I just transfer the tables and data from
the one I started to the template or totally recreate the names and data in
the template to match what I need it to say?
I really appreciate your help!!!
J
Joan Wild
I was thinking that you'd start with the template, and modify the names it
uses. Only if the template will give you what you want.
Otherwise, why don't you post what you have in your mdb i.e. names of the
tables; how they're related.
uses. Only if the template will give you what you want.
Otherwise, why don't you post what you have in your mdb i.e. names of the
tables; how they're related.