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
|
|||
|
|||
cannot create New Record (icons greyed out)
Hi
I am still pretty new to Access and had a form that worked fine until Friday when it disappeared in Form View. Over the weekend it seemed to resolve itself and reappeared - but... I cannot now add a new record. I am using Access 2007. All the icons on the Records section of the Home tab are greyed out apart from Refresh All. I had a go at creating an Add New Record button - just to see what happened. When I click this, I get the error message " You cannot go to the specified record". I have gone to Design View and looked at the various properties but nothing seems to suggest that I can't add/ edit anything. Any ideas gratefully received! |
#2
|
|||
|
|||
cannot create New Record (icons greyed out)
Kathryn,
It's actually the RecordSource of your form that is not allowing you to add new records. Have you reviewed that? The form only displays the RecordSource. Fix the query and you fix the issue. If the you think the query should be allowing new then post the SQL here for us to take a look. -- Gina Whipp 2010 Microsoft MVP (Access) "I feel I have been denied critical, need to know, information!" - Tremors II http://www.regina-whipp.com/index_files/TipList.htm "Kathryn" wrote in message ... Hi I am still pretty new to Access and had a form that worked fine until Friday when it disappeared in Form View. Over the weekend it seemed to resolve itself and reappeared - but... I cannot now add a new record. I am using Access 2007. All the icons on the Records section of the Home tab are greyed out apart from Refresh All. I had a go at creating an Add New Record button - just to see what happened. When I click this, I get the error message " You cannot go to the specified record". I have gone to Design View and looked at the various properties but nothing seems to suggest that I can't add/ edit anything. Any ideas gratefully received! |
#3
|
|||
|
|||
cannot create New Record (icons greyed out)
Thanks Gina
How do I access the RecordSource of the form? I have checked properties, etc. And if that doesn't work - how do I find the SQL?! Apologies - as I say, I am very new to this! "Gina Whipp" wrote: Kathryn, It's actually the RecordSource of your form that is not allowing you to add new records. Have you reviewed that? The form only displays the RecordSource. Fix the query and you fix the issue. If the you think the query should be allowing new then post the SQL here for us to take a look. -- Gina Whipp 2010 Microsoft MVP (Access) "I feel I have been denied critical, need to know, information!" - Tremors II http://www.regina-whipp.com/index_files/TipList.htm "Kathryn" wrote in message ... Hi I am still pretty new to Access and had a form that worked fine until Friday when it disappeared in Form View. Over the weekend it seemed to resolve itself and reappeared - but... I cannot now add a new record. I am using Access 2007. All the icons on the Records section of the Home tab are greyed out apart from Refresh All. I had a go at creating an Add New Record button - just to see what happened. When I click this, I get the error message " You cannot go to the specified record". I have gone to Design View and looked at the various properties but nothing seems to suggest that I can't add/ edit anything. Any ideas gratefully received! . |
#4
|
|||
|
|||
cannot create New Record (icons greyed out)
Kathryn,
Open the Form in Design View and then open the Properties window. Select the *All* tab and the very first line should say RecordSource. Click the Build or elipse button, [...], and then in the window that opens in the upper left hand corner, select SQL... copy and paste whatever is in that window here. -- Gina Whipp 2010 Microsoft MVP (Access) "I feel I have been denied critical, need to know, information!" - Tremors II http://www.regina-whipp.com/index_files/TipList.htm "Kathryn" wrote in message ... Thanks Gina How do I access the RecordSource of the form? I have checked properties, etc. And if that doesn't work - how do I find the SQL?! Apologies - as I say, I am very new to this! "Gina Whipp" wrote: Kathryn, It's actually the RecordSource of your form that is not allowing you to add new records. Have you reviewed that? The form only displays the RecordSource. Fix the query and you fix the issue. If the you think the query should be allowing new then post the SQL here for us to take a look. -- Gina Whipp 2010 Microsoft MVP (Access) "I feel I have been denied critical, need to know, information!" - Tremors II http://www.regina-whipp.com/index_files/TipList.htm "Kathryn" wrote in message ... Hi I am still pretty new to Access and had a form that worked fine until Friday when it disappeared in Form View. Over the weekend it seemed to resolve itself and reappeared - but... I cannot now add a new record. I am using Access 2007. All the icons on the Records section of the Home tab are greyed out apart from Refresh All. I had a go at creating an Add New Record button - just to see what happened. When I click this, I get the error message " You cannot go to the specified record". I have gone to Design View and looked at the various properties but nothing seems to suggest that I can't add/ edit anything. Any ideas gratefully received! . |
#5
|
|||
|
|||
cannot create New Record (icons greyed out)
Allen Browne explains the reasons for this as well as some workarounds"
http://allenbrowne.com/ser-61.html -- There's ALWAYS more than one way to skin a cat! Answers/posts based on Access 2000/2003 Message posted via AccessMonster.com http://www.accessmonster.com/Uwe/For...forms/201003/1 |
Thread Tools | |
Display Modes | |
|
|