Microsoft Freebies

Microsoft Access Form creation?

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!!

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.

Xbox 360 Monster GameLink Fiber Optic Cable $3.99 The easiest way to upgrade your system to maximum digital audio performance – The GameLink 360 Fiber Optic Cable delivers 5.1 Dobly Digital Surround Sound And PCM Digital Stereo. HexMeshTM protective jacket provides greater durability and easier installation; compliments the high-tech look of your Xbox 360.Extra low-loss optical fiber provides low dispersion and higher signal strength. InsuLightTM…

Casino Island To Go [Download] $6.99 Play island versions of your favorite casino games in a cool tropical resort as you earn power-ups, comps and freebies galore! Step up to the game table for non-stop casino action, where the odds are in your favor! Play Texas Hold ‘em Poker, Video Poker, Vaults of Atlantis Slots, Blackjack, and Ride the Tide! Fill your bonus spin meter to earn power-ups, specific to each game! The fun has just beg…

Casino Island To Go (POGO) (Jewel Case) $0.99 custom casino favorites / Powerups for power payoffs / Earn cool comps as you play / Jewel Box Packaging…