MS Access questions

[Megan]

I am not that good at Access and don't know much about it, so I have a
few questions for anyone who knows Access very well. First off, I
should mention that the company I work for uses Access as a Rolodex
for names, addresses, and phone numbers of clients.

Okay, first question: When I open Access and click on Enter/View
Contacts, how do I get it to open to a blank entry not the first one
on the list?

Second question: What is a Contact ID and how can I get rid of/change
it? We don't want to sort by Contact ID because we don't know what it
is.

Third question: What are the Contact Types? Is there a way to sort by
Contact Type?

Fourth question: How do I get it to make two lines in the address box?
Does it do it automatically?

Fifth question: How can I get it to search with just part of a
description instead of needing the whole name, business, etc..?

Thanks so much for any help I can get.

[Salad]

Megan wrote:

I am not that good at Access and don't know much about it, so I have a
few questions for anyone who knows Access very well. First off, I
should mention that the company I work for uses Access as a Rolodex
for names, addresses, and phone numbers of clients.

Okay, first question: When I open Access and click on Enter/View
Contacts, how do I get it to open to a blank entry not the first one
on the list?
Two things. You can open the form in design mode, open up the property
sheet for the form, click on the data tab, and select DataEntry = Yes.

Another option would be to open the form to a bogus contact. Let's say
your table has the fields ContactID (number) and ContactName. In the
OnOpen event you could enter something like
Me.Filter = "ContactID = 0"
Me.FilterOn = True
And when a contact is selected, enter something like
Me.Filter = ""
Me.FilterOn = False
if you want to remove the filter, otherwise simply change the Me.Filter
to equal the contact id selected.

Second question: What is a Contact ID and how can I get rid of/change
it? We don't want to sort by Contact ID because we don't know what it
is.
Most likely it is the "key" to the table. Go to the database window and
select Tables and open up the table. Most likely it is an Autonumber
field. Autonumbers generate the key when a record is created. Keys are
used to link tables together. You don't want to get rid of it, you
really want to hid it. Open up the form in design mode, double-click on
the contactid field to pull up the property sheet, select Format tab,
then change Visible to False.
Third question: What are the Contact Types? Is there a way to sort by
Contact Type?
If you look at your menu bar when the form is open, is there an AZ/ZA?
If so, click in the contactTypes field and presss on or the other?
Contact types could be customer, supplier, co-worker, etc.
Fourth question: How do I get it to make two lines in the address box?
Does it do it automatically?
That depends. Open up your contacts table in design mode. Are there
tow address fields? If not, click on the row for the current address,
see it is set up, the type, format, etc. Then in the first blank row
create a field called Address2 and duplicate the same info and save the
table. Open up the contact form in design mode. On of the graphical
elements on the menu/toolbar is something called FieldPicker. Click on
that and drag Address2 onto the form and place it where you want. Close
and save the changes.
Fifth question: How can I get it to search with just part of a
description instead of needing the whole name, business, etc..?
Do you have the Binoculars available in the toolbar when the form is
open. If so, use that to search. One of the options is any part of the
field.
Thanks so much for any help I can get.

[Megan]

Salad <oi*@vinegar.co m> wrote in message news:<Sf******* *********@newsr ead2.news.pas.e arthlink.net>.. .

Another option would be to open the form to a bogus contact. Let's say
your table has the fields ContactID (number) and ContactName. In the
OnOpen event you could enter something like
Me.Filter = "ContactID = 0"
Me.FilterOn = True
And when a contact is selected, enter something like
Me.Filter = ""
Me.FilterOn = False
if you want to remove the filter, otherwise simply change the Me.Filter
to equal the contact id selected.

What is "Me"? I tried using it and it didn't work. Thanks!

[Rick Brandt]

"Megan" <gc**********@h otmail.com> wrote in message
news:62******** *************** ***@posting.goo gle.com...

Salad <oi*@vinegar.co m> wrote in message

news:<Sf******* *********@newsr ead2.news.pas.e arthlink.net>.. .

Another option would be to open the form to a bogus contact. Let's say
your table has the fields ContactID (number) and ContactName. In the
OnOpen event you could enter something like
Me.Filter = "ContactID = 0"
Me.FilterOn = True
And when a contact is selected, enter something like
Me.Filter = ""
Me.FilterOn = False
if you want to remove the filter, otherwise simply change the Me.Filter
to equal the contact id selected.

What is "Me"? I tried using it and it didn't work. Thanks!

Where are you running the code?

Me is a shorthand reference to the parent object running the code; i.e., if
you run the code in a form's module then "Me" is a reference to the form
object, if in a report then it refers to the report.

It is nice because you can copy code or change the name of the form/report
and the code still works.

--
I don't check the Email account attached
to this message. Send instead to...
RBrandt at Hunter dot com