Hi...Can i pay someone to help me?
- Thread starter pappu
- Start date
BobMcClellan
Giving Up Is Unacceptable
- Local time
- Today, 06:21
- Joined
- Aug 1, 2009
- Messages
- 104
what do you need help with pappu?
BobMcClellan
Giving Up Is Unacceptable
- Local time
- Today, 06:21
- Joined
- Aug 1, 2009
- Messages
- 104
May I suggest that you try posting some of the things you have questions on.... There is an abundance of people here that are willing to try and help if they can.
BobMcClellan
Giving Up Is Unacceptable
- Local time
- Today, 06:21
- Joined
- Aug 1, 2009
- Messages
- 104
Open the form in design view, and make the Recordsource for the form the new table you just created. Basic functionality will allow you to add and edit existing rows in that table.
- Local time
- Today, 06:21
- Joined
- Jan 23, 2006
- Messages
- 15,549
Perhaps, some general info would be helpful. A Form is a means of "seeing" data from one or more tables. Data is stored in tables. The address would be stored in a table, and displayed in a Form.
Could you tell us more of your environment and "in plain language" what exactly you are trying to do?
Could you tell us more of your environment and "in plain language" what exactly you are trying to do?
ok i have this purchase order form which is already made.
Now i need to add shipping information to this form, so i created a new table. The new table has information about the shipper and is called tableshipper
From table shipper, I need to add some fields to that existing form.
When I try to add a text box to link to that table...I dont see anyhting in the control source.
Now i need to add shipping information to this form, so i created a new table. The new table has information about the shipper and is called tableshipper
From table shipper, I need to add some fields to that existing form.
When I try to add a text box to link to that table...I dont see anyhting in the control source.
Matoco1
Registered User.
- Local time
- Today, 11:21
- Joined
- Jan 5, 2009
- Messages
- 32
It sounds like you need to set the relationships between the tables. Can I suggest that you have a look at Microsoft learning centre it will show you most of the basic features for your version of access. If your still stuck then post your DB file and we'll have a look
so i am adding new text to my existing form..
I added a new text box to that form and I want to link that text box to a table i just created. I managed to link that too.
But when I run the form. the value on the old tex box (which was already there) changed to #Name? It says I have a Invalid Control Propert: Control Source
I am not able to figure out what I am doing wrong
I added a new text box to that form and I want to link that text box to a table i just created. I managed to link that too.
But when I run the form. the value on the old tex box (which was already there) changed to #Name? It says I have a Invalid Control Propert: Control Source
I am not able to figure out what I am doing wrong
If this was a purchase order form, then presumably it was using a purchase orders table or query as its record source. Now it sounds like you've changed the record source to the shipper table, which might allow the new text box you added to work, but it is going to (as you've discovered) cause all of the other controls - that were bound to fields in the purchase order table - to error.
It's possible that all you need is simple combo box, but that's only if the purchase orders table has a foreign key field for storing the primary key of the shippers table.
For now you should do one of two things;
1) Attach your db here so someone can look at it (I doubt anyone is going to give you their e-mail address).
2) Post back with more details about the structure of your application including table and field names and how they are related.
It's possible that all you need is simple combo box, but that's only if the purchase orders table has a foreign key field for storing the primary key of the shippers table.
For now you should do one of two things;
1) Attach your db here so someone can look at it (I doubt anyone is going to give you their e-mail address).
2) Post back with more details about the structure of your application including table and field names and how they are related.
On frmPurchaseOrder1 I want the cutomer table from the (Address, City, State, Zip). It can be anywhere in the form.
I also want Shipping Charge from tblPurchaseOrder in the same form
How do i do it?
Thanks Beetle
I also want Shipping Charge from tblPurchaseOrder in the same form
How do i do it?
Thanks Beetle
Last edited:
OK, I took a look at your db. I didn't have time to look at it in depth but I took a look at the form in question. It looks like you used the wizard to create this form, so I'll try to explain this in those terms as best I can. Before we continue, I should point out that you seem to have some minor corruption issues with this form, so I would suggest that you Save after each of these steps along the way, or you may get all the way to the end only to find out that the form won't save.
When you created the form, the wizard created a query for you that is used as the record source of the form. If you open the property sheet for the form, select the data tab and look at the Record Source you will see;
SELECT tblPurchaseOrder. blah blah blah
If you click the elipse (...) to the right of this line it will open the design grid for this query. In the top section of the design grid there are two tables, tblVendors and tblPurchaseOrders. In tblPurchaseOrders double click on the fields Shipping Charge and ShipperID. This will add those two fields to your record source. Then close the query designer. When it asks you if you want to save the changes and update the property click Yes.
Next, add a new text box to your form. Open the properties sheet of the this text box, select the data tab and set the Control Source of this text box to Shipping Charge. Now, add a combo box to your form. When you do this, the combo box wizard should start. In the wizard, do the following;
1) Select "I want to look up the values in a table or query"
2) On the next page select tblShipper.
3) Next, add all of the fields from tblShipper to the Selected Fields list.
4) On the next page select Shipper Name in the first sort box.
5) The next page is where you choose which columns you want to display in your combo box. Make sure that the Hide Key Column box is checked, then take all of the columns (address, city, etc.) except for the Name column and drag the width down to zero, so that the only column you see is the Name column.
6) On the next page select "Store the value in this field:" and select the ShipperID field from the drop down.
7) On the last page put cboShipper in the name box, then click finish (if you don't name it cboShipper then the following steps won't work).
Now add two more text boxes to your form right under the combo box. In the Control Source of the first text box put;
=cboShipper.Column(2)
in the Control Source of the second text box put;
=cboShipper.Column(3) & ", " & cboShipper.Column(4) & " " & cboShipper.Column(5)
Now when you select a shipper from the combo box it should display the Address and the City, State Zip in those two combo boxes.
The reason for doing it this way is that the only Shipper related field available in your form's Record Source is the ShipperID (which is how it should be). All the other Shipper related fields (Name, Address, etc.) are simply displayed on the form via the combo box. Those other fields are not (and should not be) stored in this form's Record Source. Only the ShipperID is. So when you make a selection in the combo box, it stores the selected ShipperID in tblPurchaseOrders and displays all the related shipper info on the form.
When you created the form, the wizard created a query for you that is used as the record source of the form. If you open the property sheet for the form, select the data tab and look at the Record Source you will see;
SELECT tblPurchaseOrder. blah blah blah
If you click the elipse (...) to the right of this line it will open the design grid for this query. In the top section of the design grid there are two tables, tblVendors and tblPurchaseOrders. In tblPurchaseOrders double click on the fields Shipping Charge and ShipperID. This will add those two fields to your record source. Then close the query designer. When it asks you if you want to save the changes and update the property click Yes.
Next, add a new text box to your form. Open the properties sheet of the this text box, select the data tab and set the Control Source of this text box to Shipping Charge. Now, add a combo box to your form. When you do this, the combo box wizard should start. In the wizard, do the following;
1) Select "I want to look up the values in a table or query"
2) On the next page select tblShipper.
3) Next, add all of the fields from tblShipper to the Selected Fields list.
4) On the next page select Shipper Name in the first sort box.
5) The next page is where you choose which columns you want to display in your combo box. Make sure that the Hide Key Column box is checked, then take all of the columns (address, city, etc.) except for the Name column and drag the width down to zero, so that the only column you see is the Name column.
6) On the next page select "Store the value in this field:" and select the ShipperID field from the drop down.
7) On the last page put cboShipper in the name box, then click finish (if you don't name it cboShipper then the following steps won't work).
Now add two more text boxes to your form right under the combo box. In the Control Source of the first text box put;
=cboShipper.Column(2)
in the Control Source of the second text box put;
=cboShipper.Column(3) & ", " & cboShipper.Column(4) & " " & cboShipper.Column(5)
Now when you select a shipper from the combo box it should display the Address and the City, State Zip in those two combo boxes.
The reason for doing it this way is that the only Shipper related field available in your form's Record Source is the ShipperID (which is how it should be). All the other Shipper related fields (Name, Address, etc.) are simply displayed on the form via the combo box. Those other fields are not (and should not be) stored in this form's Record Source. Only the ShipperID is. So when you make a selection in the combo box, it stores the selected ShipperID in tblPurchaseOrders and displays all the related shipper info on the form.
