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  

cannot create New Record (icons greyed out)



 
 
Thread Tools Display Modes
  #1  
Old March 16th, 2010, 04:46 PM posted to microsoft.public.access.forms
Kathryn
external usenet poster
 
Posts: 108
Default 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  
Old March 16th, 2010, 05:10 PM posted to microsoft.public.access.forms
Gina Whipp
external usenet poster
 
Posts: 3,500
Default 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  
Old March 17th, 2010, 02:23 PM posted to microsoft.public.access.forms
Kathryn
external usenet poster
 
Posts: 108
Default 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  
Old March 17th, 2010, 09:19 PM posted to microsoft.public.access.forms
Gina Whipp
external usenet poster
 
Posts: 3,500
Default 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  
Old March 18th, 2010, 12:29 AM posted to microsoft.public.access.forms
Linq Adams via AccessMonster.com
external usenet poster
 
Posts: 1,474
Default 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

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 07:25 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.