Microsoft Access Form creation?

Question

I need to create a form in Microsoft access. The books that I have are showing me how to create a form, but it's not working for what I need. I basically need to be able to have a form where I can type in a persons name, and the form will recognize this as a record from a current table. I then need to add data to this name (hours on the phone) and have the form write this to a separate table to store the combined info for pulling reports later on. Does this make sense?? Anyone have a few clear steps to take in this direction, or know of a freebie website to help?
Thanks!!

Answer 1

I assume you want several hours entered for each person, so this could get involved.

Make two tables.
Table1: Create a field for Name - I used Person, click the Yellow Key to make it the primary key.
Table2: Create a field for the name, I called my Person, don't make it a primary key, but Indexed, Duplicates OK.
Then put Date, data type date/time and then Hours data time Number

Now the forms:
New Form, Design View
Click Properties on the form and change Default view to Datasheet. In record source choose table2. Drag two fields onto the form, Date and Hours. Save the form, and use a name with 'Sub' in it, this will be the sub form for the entry form.

New Form, Design View (again)
Properties, Data, Record Source Table1 Drag the field onto the form. In the tool box click Subform. It is near an icon that looks like a file folder and near one that looks like a diagonal line (I'm in version 2000) Drag open a big box for the subform
Choose use existing form. (the one you name with "Sub")
Define link fields, Choose Person from Form Fields and link it to Person in subform fields. Next, Finish

When you open the form your cursor will be in the Person field, Click the binoculars to find the name of a person that is entered or enter a name for a new record.

Answer 2

In Access, there is a sample database called Northwind Traders (or the like). Pull it up & test how the forms work. You'll see there can be several tables used by a form. You can have a table of customers linked to a table containing their orders, for example. The "link" is the customer name or number that appears in both tables. You need a common field in order to link the tables together.

If you set up your tables properly, (and if I understand the question properly) you should be able to do what you describe.

The form itself, is secondary to setting up the tables and the links between tables. Hope this helps!

Answer 3

No problem..

1) create the table first
2) click on forms, create new one using the wizard
3) pick the table
4) select all the fields you want
5) Choose to do a justified form
6) Scoot the fields and labels where you want them
7) save and start using
8) revise as you want

Answer 4

Go to "Tool" and then "Relationships" to see if you have everything linked correctly.

Microsoft offers free technical support at their website. Just go into the technical help site for your particular version of Access.

Answer 5

Try importing a primary key.

Answer 6

u got ur answer already,,, thanx pals,,,,,,