Add a Customer from table

  • Thread starter Thread starter Amelia
  • Start date Start date
A

Amelia

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!
 
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!
Click to expand...

Is your "contact list" an Access table, or are you referring to your Outlook
contacts?
 
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.
 
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!
Click to expand...

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?
 
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
 
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 said:
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 said:
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?
Click to expand...
Click to expand...
 
Back
Top