how to add a new form

[Sarah]

Hi, I am really new to Access and dont know how to do alot of things, so
hoping someone could help me please? I am writing a Quoting database for my
manager, i have started with the Switchboard manager and have worked out how
to get new records on the first from when opened. The problem i have having
is with the other forms that are attached to the first form using a macro of
"next" (which connects to the next form to be filled in). I am trying to get
them to all open as a "new form" but it keeps leaving the information i have
entered when i go back into it. I have tried docmd.gotorecord,,acnewrec and
also DoCmd.GoToRecord acDataForm, Me.Name, acNewRec and neither of these are
working for me. Could someone please help?
Thanks Sarah

 

[John W. Vinson]

Hi, I am really new to Access and dont know how to do alot of things, so
hoping someone could help me please? I am writing a Quoting database for my
manager, i have started with the Switchboard manager and have worked out how
to get new records on the first from when opened. The problem i have having
is with the other forms that are attached to the first form using a macro of
"next" (which connects to the next form to be filled in). I am trying to get
them to all open as a "new form" but it keeps leaving the information i have
entered when i go back into it. I have tried docmd.gotorecord,,acnewrec and
also DoCmd.GoToRecord acDataForm, Me.Name, acNewRec and neither of these are
working for me. Could someone please help?
Thanks Sarah

STOP.

You're making a very common mistake: starting with Forms.

Forms are very much SECONDARY. A form is just a tool, a window, a way to let
you manage data in Tables. The tables and their relationships are the
*essential basis* of your database.

If you're trying to copy data from one form into another form... you are on
the wrong track!

See the following resources, especially the tutorials:

Jeff Conrad's resources page:
http://www.accessmvp.com/JConrad/accessjunkie/resources.html

The Access Web resources page:
http://www.mvps.org/access/resources/index.html

Roger Carlson's tutorials, samples and tips:
http://www.rogersaccesslibrary.com/

A free tutorial written by Crystal:
http://allenbrowne.com/casu-22.html

A video how-to series by Crystal:
http://www.YouTube.com/user/LearnAccessByCrystal

MVP Allen Browne's tutorials:
http://allenbrowne.com/links.html#Tutorials

 

[Sarah]

Hi John,

I am not trying to copy data from one form to another, they all have
different information on them. for example, one form is for "consumables"
one for "valves", "Engineering Costs" etc. my plan is go through all the
forms and pick what is required then end up with a report at the end (which
works at the moment) with a total cost of how much the job will cost to do
(quote). I dont know much about tablees and have sent another question
regarding how i get them all conected via a Primary Key, as all the forms /
tables have nothing in common with each other.
Thanks Sarah

 

[Gina Whipp]

Sarah,

I see you are asking here about forms and John has given you the same answer
I have given you. You are hanging the curtains and the foundation is
crumbling. You don't connect forms or reports and the way you have your
tables presently set up you will find it difficult if not impossible to get
what you want, the way you want.

--
Gina Whipp

"I feel I have been denied critical, need to know, information!" - Tremors
II

http://www.regina-whipp.com/index_files/TipList.htm

 

[John W. Vinson]

for example, one form is for "consumables"
one for "valves", "Engineering Costs" etc. my plan is go through all the
forms and pick what is required then end up with a report at the end (which
works at the moment) with a total cost of how much the job will cost to do
(quote). I dont know much about tablees and have sent another question
regarding how i get them all conected via a Primary Key, as all the forms /
tables have nothing in common with each other.
Thanks Sarah

I agree with Gina. You're on the wrong track, and you'll find that working
with Access will be exceedingly frustrating if you keep down it!

For one thing, reports are NOT based on forms. You will use Forms to enter
data into (properly normalized) Tables, and then base Reports on those same
Tables: forms to get stuff into the tables, reports to get stuff out.

Do look at Crystal's video, or her tutorial, or the other tutorials. Access is
an incredibly powerful and useful program if you work with it; it can be a
nightmarish swamp if you struggle against it.

 

[Sarah]

Hi John,

Thanks for your help, didnt want it to be true that i have done it all
wrong....... Really appreciate all your help.
Cheers
Sarah