I want to be able to add a customer from my contact list onto a form. How
would I do this? I have a button and want to "on click" open the contact form
and then be able to choose the contact and have it add it to the form. If
anyone can help me that would be great!

On Mon, 20 Jul 2009 08:16:01 -0700, Amelia <(E-Mail Removed)>
wrote:

>I want to be able to add a customer from my contact list onto a form. How
>would I do this? I have a button and want to "on click" open the contact form
>and then be able to choose the contact and have it add it to the form. If
>anyone can help me that would be great!

Is your "contact list" an Access table, or are you referring to your Outlook
contacts?
--

John W. Vinson [MVP]

There is a table with contacts.

"Software-Matters via AccessMonster.com" wrote:

> Are they adding the customer just to the form (unbound control) or are they
> adding the customer to a table as well?
>
> Amelia wrote:
> >I want to be able to add a customer from my contact list onto a form. How
> >would I do this? I have a button and want to "on click" open the contact form
> >and then be able to choose the contact and have it add it to the form. If
> >anyone can help me that would be great!
>
> --
> http://www.software-matters.co.uk/be...se-design.html
> Bespoke Access Database Development
> Software Matters
> Straightforward solutions that work
>
> Message posted via AccessMonster.com
> http://www.accessmonster.com/Uwe/For...dules/200907/1
>
>

Contacts are in a contact table within Access that we can add contacts to or
import them from our address book. I am actually using the Contact management
template from Microsoft and am trying to add my own things to it.

"John W. Vinson" wrote:

> On Mon, 20 Jul 2009 08:16:01 -0700, Amelia <(E-Mail Removed)>
> wrote:
>
> >I want to be able to add a customer from my contact list onto a form. How
> >would I do this? I have a button and want to "on click" open the contact form
> >and then be able to choose the contact and have it add it to the form. If
> >anyone can help me that would be great!
>
> Is your "contact list" an Access table, or are you referring to your Outlook
> contacts?
> --
>
> John W. Vinson [MVP]
>

On Mon, 20 Jul 2009 08:16:01 -0700, Amelia <(E-Mail Removed)>
wrote:

>I want to be able to add a customer from my contact list onto a form. How
>would I do this? I have a button and want to "on click" open the contact form
>and then be able to choose the contact and have it add it to the form. If
>anyone can help me that would be great!

You can't "add a contact to a form" - a form does not contain data, it's just
a window to view data in a table.

What is the structure of your table? (I don't have the Microsoft Contacts
template downloaded at present). What is the Recordsource of the form? What
exactly do you want to do with the contact when you select it?
--

John W. Vinson [MVP]

Maybe this makes more sense...I have a form to add data to an invoice table.
I want to add a customer to the invoice from the contact table. So how do I
create a button and then have it ask for a customer name and then it would
pull the information from the contact table to the [Customer Name] field in
the form (could either be the PID number or the actual name). Then when I
want to print the invoice I want the report to print all the information from
the contact table.

Here is another possiblity, someone before me created a combo box in a
different database and they have the company name, address, and phone number
all in one field. So when they pull the field information all the information
pulls from one field. I tried this, but when I try to input the name, address
and phone number it does not let me format it how I want

(so it looks like this:

first name, last name
company name
address
city, state, zip) instead if moves all of these around. Do I use a "memo"
field for this ? I will keep playing with this since I know it has been done,
unless you have a solution for doing it the other way.

Thanks for the help!


Phone

"John W. Vinson" wrote:

> On Mon, 20 Jul 2009 08:16:01 -0700, Amelia <(E-Mail Removed)>
> wrote:
>
> >I want to be able to add a customer from my contact list onto a form. How
> >would I do this? I have a button and want to "on click" open the contact form
> >and then be able to choose the contact and have it add it to the form. If
> >anyone can help me that would be great!
>
> You can't "add a contact to a form" - a form does not contain data, it's just
> a window to view data in a table.
>
> What is the structure of your table? (I don't have the Microsoft Contacts
> template downloaded at present). What is the Recordsource of the form? What
> exactly do you want to do with the contact when you select it?
> --
>
> John W. Vinson [MVP]
>

Okay, I added a customer list table, and created a form to update the table.
I then added the field to my invoice form. I got it to work! But then I went
to create an invoice and now my other fields on my invoice are not working!!
It is telling me that "the value cannot be added to this new row until the
row has been commited. Commit the row first, and then try adding the value."

I have no idea what this means, and all of the other fields were working
perfectly until I added this customer field from the customer list table. Any
idea on how to get the other form controls to update? They are coming from an
invoice table.

Thanks again.
"Amelia" wrote:

> Maybe this makes more sense...I have a form to add data to an invoice table.
> I want to add a customer to the invoice from the contact table. So how do I
> create a button and then have it ask for a customer name and then it would
> pull the information from the contact table to the [Customer Name] field in
> the form (could either be the PID number or the actual name). Then when I
> want to print the invoice I want the report to print all the information from
> the contact table.
>
> Here is another possiblity, someone before me created a combo box in a
> different database and they have the company name, address, and phone number
> all in one field. So when they pull the field information all the information
> pulls from one field. I tried this, but when I try to input the name, address
> and phone number it does not let me format it how I want
>
> (so it looks like this:
>
> first name, last name
> company name
> address
> city, state, zip) instead if moves all of these around. Do I use a "memo"
> field for this ? I will keep playing with this since I know it has been done,
> unless you have a solution for doing it the other way.
>
> Thanks for the help!
>
>
> Phone
>
> "John W. Vinson" wrote:
>
> > On Mon, 20 Jul 2009 08:16:01 -0700, Amelia <(E-Mail Removed)>
> > wrote:
> >
> > >I want to be able to add a customer from my contact list onto a form. How
> > >would I do this? I have a button and want to "on click" open the contact form
> > >and then be able to choose the contact and have it add it to the form. If
> > >anyone can help me that would be great!
> >
> > You can't "add a contact to a form" - a form does not contain data, it's just
> > a window to view data in a table.
> >
> > What is the structure of your table? (I don't have the Microsoft Contacts
> > template downloaded at present). What is the Recordsource of the form? What
> > exactly do you want to do with the contact when you select it?
> > --
> >
> > John W. Vinson [MVP]
> >