A Microsoft Office (Excel, Word) forum. OfficeFrustration

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.

Go Back   Home » OfficeFrustration forum » Microsoft Access » Using Forms
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Subform has headings but not Cells to enter data???



 
 
Thread Tools Display Modes
  #1  
Old December 23rd, 2006, 12:32 AM posted to microsoft.public.access.forms
EZ KEY
external usenet poster
 
Posts: 54
Default 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  
Old December 23rd, 2006, 12:50 AM posted to microsoft.public.access.forms
ruralguy via AccessMonster.com
external usenet poster
 
Posts: 1,172
Default 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  
Old December 23rd, 2006, 12:57 AM posted to microsoft.public.access.forms
John Vinson
external usenet poster
 
Posts: 4,033
Default 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  
Old December 23rd, 2006, 04:00 AM posted to microsoft.public.access.forms
EZ KEY
external usenet poster
 
Posts: 54
Default 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  
Old December 23rd, 2006, 04:03 AM posted to microsoft.public.access.forms
ezkey
external usenet poster
 
Posts: 1
Default 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  
Old December 23rd, 2006, 04:36 AM posted to microsoft.public.access.forms
John Vinson
external usenet poster
 
Posts: 4,033
Default 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  
Old December 23rd, 2006, 04:51 AM posted to microsoft.public.access.forms
EZ KEY
external usenet poster
 
Posts: 54
Default 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  
Old December 23rd, 2006, 05:21 AM posted to microsoft.public.access.forms
EZ KEY
external usenet poster
 
Posts: 54
Default 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  
Old December 23rd, 2006, 06:01 AM posted to microsoft.public.access.forms
John Vinson
external usenet poster
 
Posts: 4,033
Default 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

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 12:53 PM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.