|
| 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
December 1st, 2009, 10:13 PM
posted to microsoft.public.access.queries
|
|||
|
|||
'new record' grayed out in query
Hello friends,
I recently added a calcuation field to a query (in Access 2007 in a file saved to be compatible to Access 2003), and it even works. But now, the 'new record' field is greyed out in both the query and, of course, the attached form. But I can create a new field in the table. Help? The calculation field I added, in case it matters, is an Expression, titled 'FigureTax: ([PricePaid]*0.0876)' thanks so much - Mary -- Thanks for sharing your knowledge. 
|
|
#2
December 2nd, 2009, 04:11 AM
posted to microsoft.public.access.queries
|
|||
|
|||
|
'new record' grayed out in query
Please provide the SQL view of the query.
-- Duane Hookom Microsoft Access MVP "Mary" wrote: Hello friends, I recently added a calcuation field to a query (in Access 2007 in a file saved to be compatible to Access 2003), and it even works. But now, the 'new record' field is greyed out in both the query and, of course, the attached form. But I can create a new field in the table. Help? The calculation field I added, in case it matters, is an Expression, titled 'FigureTax: ([PricePaid]*0.0876)' thanks so much - Mary -- Thanks for sharing your knowledge.
|
|
#3
December 2nd, 2009, 04:11 AM
posted to microsoft.public.access.queries
|
|||
|
|||
|
'new record' grayed out in query
Please provide the SQL view of the query.
-- Duane Hookom Microsoft Access MVP "Mary" wrote: Hello friends, I recently added a calcuation field to a query (in Access 2007 in a file saved to be compatible to Access 2003), and it even works. But now, the 'new record' field is greyed out in both the query and, of course, the attached form. But I can create a new field in the table. Help? The calculation field I added, in case it matters, is an Expression, titled 'FigureTax: ([PricePaid]*0.0876)' thanks so much - Mary -- Thanks for sharing your knowledge.
|
|
#4
December 2nd, 2009, 04:11 AM
posted to microsoft.public.access.queries
|
|||
|
|||
|
'new record' grayed out in query
Please provide the SQL view of the query.
-- Duane Hookom Microsoft Access MVP "Mary" wrote: Hello friends, I recently added a calcuation field to a query (in Access 2007 in a file saved to be compatible to Access 2003), and it even works. But now, the 'new record' field is greyed out in both the query and, of course, the attached form. But I can create a new field in the table. Help? The calculation field I added, in case it matters, is an Expression, titled 'FigureTax: ([PricePaid]*0.0876)' thanks so much - Mary -- Thanks for sharing your knowledge.
|
|
#5
December 2nd, 2009, 02:36 PM
posted to microsoft.public.access.queries
|
|||
|
|||
|
'new record' grayed out in query
Something like a calculated field could cause a query to be unupdateable.
There are many other things. See the link below. http://support.microsoft.com/?kbid=328828 -- Jerry Whittle, Microsoft Access MVP Light. Strong. Cheap. Pick two. Keith Bontrager - Bicycle Builder. "Mary" wrote: Hello friends, I recently added a calcuation field to a query (in Access 2007 in a file saved to be compatible to Access 2003), and it even works. But now, the 'new record' field is greyed out in both the query and, of course, the attached form. But I can create a new field in the table. Help? The calculation field I added, in case it matters, is an Expression, titled 'FigureTax: ([PricePaid]*0.0876)' thanks so much - Mary -- Thanks for sharing your knowledge.
|
|
#6
December 2nd, 2009, 02:36 PM
posted to microsoft.public.access.queries
|
|||
|
|||
|
'new record' grayed out in query
Something like a calculated field could cause a query to be unupdateable.
There are many other things. See the link below. http://support.microsoft.com/?kbid=328828 -- Jerry Whittle, Microsoft Access MVP Light. Strong. Cheap. Pick two. Keith Bontrager - Bicycle Builder. "Mary" wrote: Hello friends, I recently added a calcuation field to a query (in Access 2007 in a file saved to be compatible to Access 2003), and it even works. But now, the 'new record' field is greyed out in both the query and, of course, the attached form. But I can create a new field in the table. Help? The calculation field I added, in case it matters, is an Expression, titled 'FigureTax: ([PricePaid]*0.0876)' thanks so much - Mary -- Thanks for sharing your knowledge.
|
|
#7
December 2nd, 2009, 02:36 PM
posted to microsoft.public.access.queries
|
|||
|
|||
|
'new record' grayed out in query
Something like a calculated field could cause a query to be unupdateable.
There are many other things. See the link below. http://support.microsoft.com/?kbid=328828 -- Jerry Whittle, Microsoft Access MVP Light. Strong. Cheap. Pick two. Keith Bontrager - Bicycle Builder. "Mary" wrote: Hello friends, I recently added a calcuation field to a query (in Access 2007 in a file saved to be compatible to Access 2003), and it even works. But now, the 'new record' field is greyed out in both the query and, of course, the attached form. But I can create a new field in the table. Help? The calculation field I added, in case it matters, is an Expression, titled 'FigureTax: ([PricePaid]*0.0876)' thanks so much - Mary -- Thanks for sharing your knowledge.
|
| Thread Tools | |
| Display Modes | |
|
|
Linear Mode
