error message: Control can't be edited; it's bound to the expressi

[NSpring]

I have a database of bibliographic references. There is a table, a form, and
a query that drives a report, by opening a dialog box that asks for a
category (which has a corresponding field in the form).

Following setting up the query and dialog box, I can no longer edit the memo
field of the form. When I try, I get the error message
Control can't be edited; it's bound to the expression 'FirstOfSummary'

where FirstOfSummary is the name for the memo field that is one of the
fields included in the report. This field is denoted by First in the Total
row of the Select query, whereas the other fields are denoted Group By or are
not included in the Select query. (I did this to solve a truncated memo field
problem).

I want to be albe to edit this memo field. And really I don't need any
fields to be locked for editing. The Properties box for each field on the
form has the correct unlocked and enabled options, including the memo field.
I have copied and pasted code from for locking and unlocking editing through
a command button. It works for every field except the memo field.

 

[Jeanette Cunningham]

NSpring,
in access, queries using group by or totals can not be edited.
Usually, select queries give a results set that can be edited.

Jeanette Cunningham -- Melbourne Victoria Australia

 

[NSpring]

Is there a way to uncouple the query from the form? I would like to be able
to go into the form and enter new records and edit old records. In a separate
action, I would like to create a report based upon the query I mentioned
earlier.

Thank you

 

[John W. Vinson]

Is there a way to uncouple the query from the form? I would like to be able
to go into the form and enter new records and edit old records. In a separate
action, I would like to create a report based upon the query I mentioned
earlier.

Thank you

Of course. The data is not stored in the form, or the query; it's stored in
the table. You can base the Form directly on the table, or on a Select query
based on the table (and updateable query); the Report can and should be based
on a different query. So long as the two queries are based on the same table,
you can enter data into the table using the Form, and pull data from the table
using the Query.

 

[NSpring]

The object dependencies view indicates that the form is not dependent on the
query.

I know very little about Access. Do the following terms in the Properties
window for the Query mean anything pertinent to my problem?
Source Database (current)
Source Connect Str [it is blank here]

thanks

 

[John W. Vinson]

The object dependencies view indicates that the form is not dependent on the
query.

Open the Form in design view; view its Properties. The Form draws its data
from its Recordsource. What is in that property?

I know very little about Access. Do the following terms in the Properties
window for the Query mean anything pertinent to my problem?
Source Database (current)
Source Connect Str [it is blank here]

No. That just means that the query is in your database, not in some external
database - but you knew that already.

 

[NSpring]

Open the Form in design view; view its Properties. The Form draws its data
from its Recordsource. What is in that property?

Recordsource tblLibraryRecords
[that is the name of my table]

as it stands now, the db has 4 obvious components

1) a table of references, including one long field that is essentially an
abstract

2) a form that has each reference on a different page, and a blank page for
creating a new record. There is a functioning Lock/unlock button except that
it won't unlock the memo field

3) a query for generating a report where the search term (one particular
field only) is entered in a dialog box and treated as surrounded by wild card
characters. The total row of the query four fields with the group by and one
field (the memo field)with First.

4) the report that uses the query

i would welcome any further suggestions

 

[John W. Vinson]

Recordsource tblLibraryRecords
[that is the name of my table]

as it stands now, the db has 4 obvious components

1) a table of references, including one long field that is essentially an
abstract

What are the fields (fieldnames and datatypes) in tblLibraryRecords?

2) a form that has each reference on a different page, and a blank page for
creating a new record. There is a functioning Lock/unlock button except that
it won't unlock the memo field

Not sure what you mean by "a page" - is this just the usual single form
displaying one record, with navigation buttons which let you move from record
to record (including the blank "new record")?

3) a query for generating a report where the search term (one particular
field only) is entered in a dialog box and treated as surrounded by wild card
characters. The total row of the query four fields with the group by and one
field (the memo field)with First.

Please open the query in SQL view and post it here. If you Group By the memo
field, it will truncate it to 255 bytes - why do you need a totals query at
all, with just four records?

 

[NSpring]

Recordsource tblLibraryRecords
[that is the name of my table]

as it stands now, the db has 4 obvious components

1) a table of references, including one long field that is essentially an
abstract

What are the fields (fieldnames and datatypes) in tblLibraryRecords?

ID Number AutoNumber
Title Text
Author Text
Reference Text
Category Text
Keywords Text
FirstOf Summary Memo
Date Date/Time
Name Memo
Image OLE Object

Not sure what you mean by "a page" - is this just the usual single form
displaying one record, with navigation buttons which let you move from record
to record (including the blank "new record")? YES

Please open the query in SQL view and post it here. If you Group By the memo
field, it will truncate it to 255 bytes - why do you need a totals query at
all, with just four records?

I don't know whether I need the total row. Replacing Group by for the
summary field with First was what I did to prevent the 255 truncation.PARAMETERS [Enter Name] Text ( 255 );
SELECT tblLibraryRecords.Name, tblLibraryRecords.Category,
tblLibraryRecords.Reference, tblLibraryRecords.Title,
First(tblLibraryRecords.FirstOfSummary) AS FirstOfFirstOfSummary
FROM tblLibraryRecords
GROUP BY tblLibraryRecords.Name, tblLibraryRecords.Category,
tblLibraryRecords.Reference, tblLibraryRecords.Title
HAVING (((tblLibraryRecords.Name) Like "*" & [Enter Name] & "*"));

 

[John W. Vinson]

I don't know whether I need the total row. Replacing Group by for the
summary field with First was what I did to prevent the 255 truncation.PARAMETERS [Enter Name] Text ( 255 );
SELECT tblLibraryRecords.Name, tblLibraryRecords.Category,
tblLibraryRecords.Reference, tblLibraryRecords.Title,
First(tblLibraryRecords.FirstOfSummary) AS FirstOfFirstOfSummary
FROM tblLibraryRecords
GROUP BY tblLibraryRecords.Name, tblLibraryRecords.Category,
tblLibraryRecords.Reference, tblLibraryRecords.Title
HAVING (((tblLibraryRecords.Name) Like "*" & [Enter Name] & "*"));

AGAIN:

WHY are you using the totals feature?

You don't need it.

Simply turn off the Greek Sigma icon and make it a simple select query. If
you're not summing, or counting, or averaging, then making it into a totals
query is just interfering.

The fact that your *table* fieldname is FirstOfSummary is suspicious: is this
really a Table or is it, itself, a query? or was it derived from a pervious
totals query?

Note that Name is a reserved word - you might want to change the Name of Name
to LibraryName or some other appropriate Name, so Access won't get confused.

 

[NSpring]

I don't know enough about MSaccess to set up the select query properly. I
have created the kind of search result product that I was trying to get with
the report by using a filter form.

Thank you.

I don't know whether I need the total row. Replacing Group by for the
summary field with First was what I did to prevent the 255 truncation.PARAMETERS [Enter Name] Text ( 255 );
SELECT tblLibraryRecords.Name, tblLibraryRecords.Category,
tblLibraryRecords.Reference, tblLibraryRecords.Title,
First(tblLibraryRecords.FirstOfSummary) AS FirstOfFirstOfSummary
FROM tblLibraryRecords
GROUP BY tblLibraryRecords.Name, tblLibraryRecords.Category,
tblLibraryRecords.Reference, tblLibraryRecords.Title
HAVING (((tblLibraryRecords.Name) Like "*" & [Enter Name] & "*"));

AGAIN:

WHY are you using the totals feature?

You don't need it.

Simply turn off the Greek Sigma icon and make it a simple select query. If
you're not summing, or counting, or averaging, then making it into a totals
query is just interfering.

The fact that your *table* fieldname is FirstOfSummary is suspicious: is this
really a Table or is it, itself, a query? or was it derived from a pervious
totals query?

Note that Name is a reserved word - you might want to change the Name of Name
to LibraryName or some other appropriate Name, so Access won't get confused.