By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,687 Members | 2,065 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,687 IT Pros & Developers. It's quick & easy.

Using Checkboxes on a Form

P: n/a
Hello everyone!

I am in the process of setting up a client contact database for my
office and I have run into a bit of a snag. The database I have allows
for one address per client but some of our clients have two that we
will use - one for home and one for work.
Problem #1 where do I add in the fields for a second address - in the
Contacts Table that is already established or a separate Table?

We also would like to use these addresses to send out Christmas cards,
but some cards we would send to the home address and some we would
want to send to the work address. Instead of creating a separate
database for the Christmas card labels I would really love to just use
what I have.
Problem #2 If I have the fields available on one form to enter two
addresses, I would like to use a checkbox so that whoever is entering
the data can check off which address should be printed on labels for
our cards.

Problem #3 If I have checkboxes on the form, how do create a query
that would pull the address information that was checked off?

Problem #4 How do I create labels if I have two fields for Names,
addresses, city, state, etc...??

I am basically a beginner at Access, but I have taken some courses and
know my way around somewhat. If you have an answer for me I would just
ask that you be as specific as possible. I hope I have asked my
question as specific as possible, but if you need more info, please
ask me!!

Thanks in advance for all your help!!

Jun 15 '07 #1
Share this Question
Share on Google+
3 Replies


P: n/a
you need a second table for the addresses, that way you can have as many
addresses as you want for a contact, your other option is to add alternate
address fields to your first table giving you the option to have one or two
addresses for a contact. The first option is definetly the correct way to
handle it.

"aaa2876" <am*****@hotmail.comwrote in message
news:11**********************@p77g2000hsh.googlegr oups.com...
Hello everyone!

I am in the process of setting up a client contact database for my
office and I have run into a bit of a snag. The database I have allows
for one address per client but some of our clients have two that we
will use - one for home and one for work.
Problem #1 where do I add in the fields for a second address - in the
Contacts Table that is already established or a separate Table?

We also would like to use these addresses to send out Christmas cards,
but some cards we would send to the home address and some we would
want to send to the work address. Instead of creating a separate
database for the Christmas card labels I would really love to just use
what I have.
Problem #2 If I have the fields available on one form to enter two
addresses, I would like to use a checkbox so that whoever is entering
the data can check off which address should be printed on labels for
our cards.

Problem #3 If I have checkboxes on the form, how do create a query
that would pull the address information that was checked off?

Problem #4 How do I create labels if I have two fields for Names,
addresses, city, state, etc...??

I am basically a beginner at Access, but I have taken some courses and
know my way around somewhat. If you have an answer for me I would just
ask that you be as specific as possible. I hope I have asked my
question as specific as possible, but if you need more info, please
ask me!!

Thanks in advance for all your help!!

Jun 15 '07 #2

P: n/a
Add a field called Address2 as well as City2, State2, ZIP2 or something
similar to the Contacts table and add another field that is a Yes/No to the
table and call it something like UseAddress2.
Add these fields to your form and place the UseAddress2 near the new Address2
data and label it "Use this address for Christmas card labels .
In a query for the labels create a field with Addr:IIf(UseAddress2=-1,
[Address2],Address) in the Field space and CityState:IIf(UseAddress2=-1,
[City2] & ", " & [State2] & " " & [ZIP2],[City] & ", " & [State] & " " &
[ZIP]) assuming that the current address in the table is named Address, City,
State, ZIP
When you have a checkbox a -1 is the value returned for Yes and a 0 is for No.

Hope this helps,
Bob
aaa2876 wrote:
>Hello everyone!

I am in the process of setting up a client contact database for my
office and I have run into a bit of a snag. The database I have allows
for one address per client but some of our clients have two that we
will use - one for home and one for work.
Problem #1 where do I add in the fields for a second address - in the
Contacts Table that is already established or a separate Table?

We also would like to use these addresses to send out Christmas cards,
but some cards we would send to the home address and some we would
want to send to the work address. Instead of creating a separate
database for the Christmas card labels I would really love to just use
what I have.
Problem #2 If I have the fields available on one form to enter two
addresses, I would like to use a checkbox so that whoever is entering
the data can check off which address should be printed on labels for
our cards.

Problem #3 If I have checkboxes on the form, how do create a query
that would pull the address information that was checked off?

Problem #4 How do I create labels if I have two fields for Names,
addresses, city, state, etc...??

I am basically a beginner at Access, but I have taken some courses and
know my way around somewhat. If you have an answer for me I would just
ask that you be as specific as possible. I hope I have asked my
question as specific as possible, but if you need more info, please
ask me!!

Thanks in advance for all your help!!
--
Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/For...ccess/200706/1

Jun 15 '07 #3

P: n/a
Answers in-line
aaa2876 <am*****@hotmail.comwrote in
news:11**********************@p77g2000hsh.googlegr oups.com:
Hello everyone!

I am in the process of setting up a client contact database
for my office and I have run into a bit of a snag. The
database I have allows for one address per client but some of
our clients have two that we will use - one for home and one
for work. Problem #1 where do I add in the fields for a second
address - in the Contacts Table that is already established or
a separate Table?
You make a separate table for all addresses, and move the ones
already in the existing table. Some people also have in addition
to home and office, a ski chalet and summer cottage. You will
need the client id, direct address fields and a field to store
the addresstype 1=office, 2=home,3=whatever.

You should also break the phone numbers and emails into separate
tables. I have 5 phone numbers (office via switchboard, office
direct, home, cel, and fax. And seven email addresses.
>
We also would like to use these addresses to send out
Christmas cards, but some cards we would send to the home
address and some we would want to send to the work address.
Instead of creating a separate database for the Christmas card
labels I would really love to just use what I have.
Problem #2 If I have the fields available on one form to enter
two addresses, I would like to use a checkbox so that whoever
is entering the data can check off which address should be
printed on labels for our cards.
Again in your client table, save the addresstype number as a
which. I'd have the addresstype and addresstypeDescription in a
combobox, so people dont need to remember wether home is 1 or 2.

Problem #3 If I have checkboxes on the form, how do create a
query that would pull the address information that was checked
off?
again just filter on the addresstype.
>
Problem #4 How do I create labels if I have two fields for
Names, addresses, city, state, etc...??
You create a subform embedded in your main form. That takes care
of the label issue, This is because each address has an
addresstype so you can build the subform to show "home address"
or "office address" against the relevant row.

I am basically a beginner at Access, but I have taken some
courses and know my way around somewhat. If you have an answer
for me I would just ask that you be as specific as possible. I
hope I have asked my question as specific as possible, but if
you need more info, please ask me!!

Thanks in advance for all your help!!
Good luck.

--
Bob Quintal

PA is y I've altered my email address.

--
Posted via a free Usenet account from http://www.teranews.com

Jun 16 '07 #4

This discussion thread is closed

Replies have been disabled for this discussion.