Prev: Insert data into Combo
Next: Networked Database
From: Kathryn on 16 Mar 2010 11:46
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!
From: Gina Whipp on 16 Mar 2010 12:10
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" <Kathryn(a)discussions.microsoft.com> wrote in message
news:2BC91AB6-C1C1-4B7D-93B8-AFEC530BCBD2(a)microsoft.com...
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!

From: Kathryn on 17 Mar 2010 09:23
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" <Kathryn(a)discussions.microsoft.com> wrote in message
> news:2BC91AB6-C1C1-4B7D-93B8-AFEC530BCBD2(a)microsoft.com...
> 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!
>
> .
>
From: Gina Whipp on 17 Mar 2010 16:19
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" <Kathryn(a)discussions.microsoft.com> wrote in message
news:3988255D-234E-4D26-998B-D626334E97AB(a)microsoft.com...
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" <Kathryn(a)discussions.microsoft.com> wrote in message
> news:2BC91AB6-C1C1-4B7D-93B8-AFEC530BCBD2(a)microsoft.com...
> 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!
>
> .
>
From: Linq Adams via AccessMonster.com on 17 Mar 2010 19:29
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/Forums.aspx/access-forms/201003/1

 | 
Pages: 1
Prev: Insert data into Combo
Next: Networked Database