If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Subform has headings but not Cells to enter data???
I've created an Orders Form similar to that in Northwind, and have been
trying to learn by duplication. My Problem Is: I finally managed to get my subform to insert into my Orders form in a Dataview, however, the field heads show up but I'm not able to enter anything into the fields? There are no "white cells" for information. What am I missing? I've been over and over it and have referred to Northwind alot but to no success. Could really use some help. |
#2
|
|||
|
|||
Subform has headings but not Cells to enter data???
Do you have Allow Additions set to YES?
EZ KEY wrote: I've created an Orders Form similar to that in Northwind, and have been trying to learn by duplication. My Problem Is: I finally managed to get my subform to insert into my Orders form in a Dataview, however, the field heads show up but I'm not able to enter anything into the fields? There are no "white cells" for information. What am I missing? I've been over and over it and have referred to Northwind alot but to no success. Could really use some help. -- HTH - RuralGuy (RG for short) acXP WinXP Pro Please post back to this forum so all may benefit. Message posted via http://www.accessmonster.com |
#3
|
|||
|
|||
Subform has headings but not Cells to enter data???
On Fri, 22 Dec 2006 15:32:00 -0800, EZ KEY
wrote: I've created an Orders Form similar to that in Northwind, and have been trying to learn by duplication. My Problem Is: I finally managed to get my subform to insert into my Orders form in a Dataview, however, the field heads show up but I'm not able to enter anything into the fields? There are no "white cells" for information. What am I missing? I've been over and over it and have referred to Northwind alot but to no success. Could really use some help. My guess is that the Subform is based on a query that is not updateable. What is its Recordsource? If it's a query, and you open that query in datasheet view, is it updateable? If not, post the SQL view of the query here and someone may be able to explain why and fix it. John W. Vinson[MVP] |
#4
|
|||
|
|||
Subform has headings but not Cells to enter data???
Yes, it is a form based upon a query. Now that you mentioned that, it makes
sense that it isn't update able. The reason I did it that way was so I could select a product with a Lookup function and have its price pop up accordingly. I haven't been able to figure out how to do it otherwise, even using the Comprehensive Access Guide by Shelly Cashman. This is just the query SQL, and I made it into form and inserted it into my Orders Form (similar to Northwind) manually through the wizard. Here is the SQL SELECT [Order Details].[Product ID], [Product Services Table].[Product Price] FROM [Product Services Table] INNER JOIN [Order Details] ON [Product Services Table].[Product ID] = [Order Details].[Product ID] ORDER BY [Order Details].[Product ID]; Any help would be appreciated. I'm trying to get this project done as a Christmas Gift for a friend, and this is the only thing holding me up. Thanks! "John Vinson" wrote: On Fri, 22 Dec 2006 15:32:00 -0800, EZ KEY wrote: I've created an Orders Form similar to that in Northwind, and have been trying to learn by duplication. My Problem Is: I finally managed to get my subform to insert into my Orders form in a Dataview, however, the field heads show up but I'm not able to enter anything into the fields? There are no "white cells" for information. What am I missing? I've been over and over it and have referred to Northwind alot but to no success. Could really use some help. My guess is that the Subform is based on a query that is not updateable. What is its Recordsource? If it's a query, and you open that query in datasheet view, is it updateable? If not, post the SQL view of the query here and someone may be able to explain why and fix it. John W. Vinson[MVP] |
#5
|
|||
|
|||
Subform has headings but not Cells to enter data???
Yes, it is a form based upon a query. Now that you mentioned that, it makes
sense that it isn't update able. The reason I did it that way was so I could select a product with a Lookup function and have its price pop up accordingly. I haven't been able to figure out how to do it otherwise, even using the Comprehensive Access Guide by Shelly Cashman. This is just the query SQL, and I made it into form and inserted it into my Orders Form (similar to Northwind) manually through the wizard. Here is the SQL SELECT [Order Details].[Product ID], [Product Services Table].[Product Price] FROM [Product Services Table] INNER JOIN [Order Details] ON [Product Services Table].[Product ID] = [Order Details].[Product ID] ORDER BY [Order Details].[Product ID]; Any help would be appreciated. I'm trying to get this project done as a Christmas Gift for a friend, and this is the only thing holding me up. Thanks! John Vinson wrote: I've created an Orders Form similar to that in Northwind, and have been trying to learn by duplication. My Problem Is: [quoted text clipped - 6 lines] I've been over and over it and have referred to Northwind alot but to no success. Could really use some help. My guess is that the Subform is based on a query that is not updateable. What is its Recordsource? If it's a query, and you open that query in datasheet view, is it updateable? If not, post the SQL view of the query here and someone may be able to explain why and fix it. John W. Vinson[MVP] |
#6
|
|||
|
|||
Subform has headings but not Cells to enter data???
On Fri, 22 Dec 2006 19:00:00 -0800, EZ KEY
wrote: Yes, it is a form based upon a query. Now that you mentioned that, it makes sense that it isn't update able. The reason I did it that way was so I could select a product with a Lookup function and have its price pop up accordingly. I haven't been able to figure out how to do it otherwise, even using the Comprehensive Access Guide by Shelly Cashman. This is just the query SQL, and I made it into form and inserted it into my Orders Form (similar to Northwind) manually through the wizard. Here is the SQL SELECT [Order Details].[Product ID], [Product Services Table].[Product Price] FROM [Product Services Table] INNER JOIN [Order Details] ON [Product Services Table].[Product ID] = [Order Details].[Product ID] ORDER BY [Order Details].[Product ID]; Any help would be appreciated. I'm trying to get this project done as a Christmas Gift for a friend, and this is the only thing holding me up. Base the Form directly on the OrderDetails table. Put a Combo Box (let's call it cboProduct) on the form bound to the ProductID field, based on a query selecting the ProductID, product name, and product price from the the Product Services Table. On the Form put an unbound text box; set its Control Source to =cboProduct.Column(2) to display the third (it's zero based) field in the query, that is, the price. John W. Vinson[MVP] |
#7
|
|||
|
|||
Subform has headings but not Cells to enter data???
Hi John! Thanks for your help.
Okay, a little naive, but let me reiterate. Are you saying to create a new Orders form with this control box with a text box that will display the information? or... Are you saying to do this to this all as a Subform in the Orders form? Sorry to be stupid. I've been working on this for a week and a half and it is very late. Thanks! "John Vinson" wrote: On Fri, 22 Dec 2006 19:00:00 -0800, EZ KEY wrote: Yes, it is a form based upon a query. Now that you mentioned that, it makes sense that it isn't update able. The reason I did it that way was so I could select a product with a Lookup function and have its price pop up accordingly. I haven't been able to figure out how to do it otherwise, even using the Comprehensive Access Guide by Shelly Cashman. This is just the query SQL, and I made it into form and inserted it into my Orders Form (similar to Northwind) manually through the wizard. Here is the SQL SELECT [Order Details].[Product ID], [Product Services Table].[Product Price] FROM [Product Services Table] INNER JOIN [Order Details] ON [Product Services Table].[Product ID] = [Order Details].[Product ID] ORDER BY [Order Details].[Product ID]; Any help would be appreciated. I'm trying to get this project done as a Christmas Gift for a friend, and this is the only thing holding me up. Base the Form directly on the OrderDetails table. Put a Combo Box (let's call it cboProduct) on the form bound to the ProductID field, based on a query selecting the ProductID, product name, and product price from the the Product Services Table. On the Form put an unbound text box; set its Control Source to =cboProduct.Column(2) to display the third (it's zero based) field in the query, that is, the price. John W. Vinson[MVP] |
#8
|
|||
|
|||
Subform has headings but not Cells to enter data???
WooHoo John! Yes, a little excited, but I got it to work. Apparently you
meant the subform. You don't know how much... well, maybe you do... how much a relief this is. It also helped me understand a little more database lingo too. Have a Merry Christmas! Thanks again! "John Vinson" wrote: On Fri, 22 Dec 2006 19:00:00 -0800, EZ KEY wrote: Yes, it is a form based upon a query. Now that you mentioned that, it makes sense that it isn't update able. The reason I did it that way was so I could select a product with a Lookup function and have its price pop up accordingly. I haven't been able to figure out how to do it otherwise, even using the Comprehensive Access Guide by Shelly Cashman. This is just the query SQL, and I made it into form and inserted it into my Orders Form (similar to Northwind) manually through the wizard. Here is the SQL SELECT [Order Details].[Product ID], [Product Services Table].[Product Price] FROM [Product Services Table] INNER JOIN [Order Details] ON [Product Services Table].[Product ID] = [Order Details].[Product ID] ORDER BY [Order Details].[Product ID]; Any help would be appreciated. I'm trying to get this project done as a Christmas Gift for a friend, and this is the only thing holding me up. Base the Form directly on the OrderDetails table. Put a Combo Box (let's call it cboProduct) on the form bound to the ProductID field, based on a query selecting the ProductID, product name, and product price from the the Product Services Table. On the Form put an unbound text box; set its Control Source to =cboProduct.Column(2) to display the third (it's zero based) field in the query, that is, the price. John W. Vinson[MVP] |
#9
|
|||
|
|||
Subform has headings but not Cells to enter data???
On Fri, 22 Dec 2006 20:21:01 -0800, EZ KEY
wrote: WooHoo John! Yes, a little excited, but I got it to work. Apparently you meant the subform. You don't know how much... well, maybe you do... how much a relief this is. I do know the feeling... and I do (very much!) appreciate the feedback, and I'm glad I was able to help. It also helped me understand a little more database lingo too. Have a Merry Christmas! Thanks again! A merry Christmas to you, and to the friend who's getting the database - glad I was able to "tie the bow on the package" for you! John W. Vinson[MVP] |
Thread Tools | |
Display Modes | |
|
|