Microsoft Access Form creation?

Question

Microsoft Access Form creation?

Answer 1

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 2

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 3

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

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

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.