Prev: Is there a way to duplicate a linked table locally with onlya front end
Next: Need help for Append Only feature in Access 2007
From: Truman - USW Local 985 Webmaster Truman - USW Local 985 on 21 Jun 2008 19:32
Okay, I have created my table with information and I created a form that I
can access when i open the whole program. At a previous job, I would click on
a file and it would just open the form only and I could search through the
records by typing the persons name at the top of the form. I want to be able
to do this with my database but I dont know how. I am using access 2007 and
lost. Dont know what I'm doing. Can anyone please help and give me idea's -
Thanks so much
From: bhicks11 via AccessMonster.com on 21 Jun 2008 22:29
Hi Truman,

You could put a combobox control that you type in/look up the person's name
and when you tab off the control it populates the other controls. Or if you
want to work in the actual data, just use the combobox to select which record
to set focus on.

Post more details if you need more help.

Bonnie

http://www.dataplus-svc.com



Truman - USW Local 985 Webmaster wrote:
>Okay, I have created my table with information and I created a form that I
>can access when i open the whole program. At a previous job, I would click on
>a file and it would just open the form only and I could search through the
>records by typing the persons name at the top of the form. I want to be able
>to do this with my database but I dont know how. I am using access 2007 and
>lost. Dont know what I'm doing. Can anyone please help and give me idea's -
>Thanks so much

--
Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/Forums.aspx/access-gettingstarted/200806/1

From: JulieS on 22 Jun 2008 11:01
"Truman - USW Local 985 Webmaster" <Truman - USW Local 985
Webmaster(a)discussions.microsoft.com> wrote in message
news:6ADA6DF0-3896-4776-81CD-0EA1F62D8F10(a)microsoft.com...
> Okay, I have created my table with information and I created a form
> that I
> can access when i open the whole program. At a previous job, I would
> click on
> a file and it would just open the form only and I could search
> through the
> records by typing the persons name at the top of the form. I want to
> be able
> to do this with my database but I dont know how. I am using access
> 2007 and
> lost. Dont know what I'm doing. Can anyone please help and give me
> idea's -
> Thanks so much

Truman,

To show the form you've created when you first open the database
you'll need to set that form to display when the database is opened.
Click the Office button and select Access Options at the lower right
edge.
Click the "Current Database" listing on the right.
Under Application Options, select your form from the Display form
list.

To add the box at the top of the form to find a specific record, show
your form in design view. Click the Design tab and in the Controls
section, make sure the Use Controls Wizards is on.
In the Controls section, click the Combo Box control and when the
wizard starts, selection the option "Find a record on my form....."
the wizard will step you through the rest.

I hope this helps.

Julie


 | 
Pages: 1
Prev: Is there a way to duplicate a linked table locally with onlya front end
Next: Need help for Append Only feature in Access 2007