cannot create New Record (icons greyed out)

[Kathryn]

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!

 

[Gina Whipp]

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

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!

 

[Kathryn]

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]

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

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!

 

[Linq Adams via AccessMonster.com]

Allen Browne explains the reasons for this as well as some workarounds"

http://allenbrowne.com/ser-61.html

 

[Jovia Ambrose]

I am having a similar problem. I am pulling a combo box from a linked table mdb1 in a query with another table in mdb2. The combo box shows employee data, but does not function as a looking list, and form does not allow new entries, although the table does. Suggestions please.

The SQL code in the query is:
SELECT [Employee Roster].[Emp #], [Employee Roster].[Last Name], [Employee Roster].[First Name], [Employee Roster].SUPER, [Employee Roster].POSITION, [Employee Roster].Inactive, INCIDENT_TABLE.ID, INCIDENT_TABLE.NUMBER, INCIDENT_TABLE.ACCIDENT, INCIDENT_TABLE.INCIDENT, INCIDENT_TABLE.PROPERTYDAMAGE, INCIDENT_TABLE.CLAIM, INCIDENT_TABLE.CASE, INCIDENT_TABLE.REPORTDATE, INCIDENT_TABLE.INCIDENTDATE, INCIDENT_TABLE.INVESTIGATOR, INCIDENT_TABLE.INCIDENTLOCATION, INCIDENT_TABLE.PROPERTYDESCRIPTION, INCIDENT_TABLE.REPORTCODE, INCIDENT_TABLE.CODECHANGE, INCIDENT_TABLE.INJURYTYPE, INCIDENT_TABLE.ACTIVITYDESCRIPTION, INCIDENT_TABLE.CAUSATION, INCIDENT_TABLE.OSHAREPORTABLE, INCIDENT_TABLE.REASON, INCIDENT_TABLE.DATECOMPLETED, INCIDENT_TABLE.DATECORRECTED, INCIDENT_TABLE.CONTROLMETHODS, INCIDENT_TABLE.ACTIVE, INCIDENT_TABLE.CATEGORY
FROM [Employee Roster], INCIDENT_TABLE
WHERE ((([Employee Roster].Inactive)=No))
ORDER BY [Employee Roster].[Last Name];

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 cannot add/ edit anything.

Any ideas gratefully received!

On Tuesday, March 16, 2010 12:10 PM Gina Whipp wrote:
Kathryn,

it is 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

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 cannot add/ edit anything.

Any ideas gratefully received!

On Wednesday, March 17, 2010 4:19 PM Gina Whipp wrote:
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

Thanks Gina
How do I access the RecordSource of the form? I have checked properties,
etc.
And if that does not work - how do I find the SQL?!

Apologies - as I say, I am very new to this!


"Gina Whipp" wrote:

 

[John W. Vinson]

I am having a similar problem. I am pulling a combo box from a linked table mdb1 in a query with another table in mdb2. The combo box shows employee data, but does not function as a looking list, and form does not allow new entries, although the table does. Suggestions please.

The SQL code in the query is:
SELECT [Employee Roster].[Emp #], [Employee Roster].[Last Name], [Employee Roster].[First Name], [Employee Roster].SUPER, [Employee Roster].POSITION, [Employee Roster].Inactive, INCIDENT_TABLE.ID, INCIDENT_TABLE.NUMBER, INCIDENT_TABLE.ACCIDENT, INCIDENT_TABLE.INCIDENT, INCIDENT_TABLE.PROPERTYDAMAGE, INCIDENT_TABLE.CLAIM, INCIDENT_TABLE.CASE, INCIDENT_TABLE.REPORTDATE, INCIDENT_TABLE.INCIDENTDATE, INCIDENT_TABLE.INVESTIGATOR, INCIDENT_TABLE.INCIDENTLOCATION, INCIDENT_TABLE.PROPERTYDESCRIPTION, INCIDENT_TABLE.REPORTCODE, INCIDENT_TABLE.CODECHANGE, INCIDENT_TABLE.INJURYTYPE, INCIDENT_TABLE.ACTIVITYDESCRIPTION, INCIDENT_TABLE.CAUSATION, INCIDENT_TABLE.OSHAREPORTABLE, INCIDENT_TABLE.REASON, INCIDENT_TABLE.DATECOMPLETED, INCIDENT_TABLE.DATECORRECTED, INCIDENT_TABLE.CONTROLMETHODS, INCIDENT_TABLE.ACTIVE, INCIDENT_TABLE.CATEGORY
FROM [Employee Roster], INCIDENT_TABLE
WHERE ((([Employee Roster].Inactive)=No))
ORDER BY [Employee Roster].[Last Name];

You don't have a JOIN in this query: as written it will retrieve every item in
the Employee Roster paired with every item in the INCIDENT_TABLE. If there are
100 employees and 20 incidents, you'll get all 2000 possible pairings! Not
what you want I suspect!

Even WITH a join, you won't be able to update a query that spans two different
..mdb files.

How (if at all) is the Incident_Table related to the Employee table? Is this
query the Recordsource for the form, or the RowSource for the combo box? What
fields are you trying to update on the form, and what role is the combo box
intended to play?
--

John W. Vinson [MVP]
Microsoft's replacements for these newsgroups:
http://social.msdn.microsoft.com/Forums/en-US/accessdev/
http://social.answers.microsoft.com/Forums/en-US/addbuz/
and see also http://www.utteraccess.com