Why are these txtboxes empty?

[Lou_Reed]

I see you point, but you mentioned nothing about setting any un-editable queries to editable. I need a reference on the DtaEntry option. I have read many things about MS Access 2010, but I do not remember that one.



You have a valid point about the email address combo box, I just want to make sure each email address is associated with the right name. It really does not need to be there, it is just there only for giving me a warm fuzzy that everything is shaking hands.

Respectfully,

Lou Reed

[Lou_Reed]

DataEntry set to Yes does confuse me. Should not show existing records. Maybe because the query is not editable Access ignores the DataEntry Yes setting. Cannot edit any fields, whereas in the first database you posted, some fields are editable in the query. Never encountered a form based on a non-editable query so never really thought about this, but makes sense.

I still do not see how to change this. By only making dataentry yes? That means a blanket command that allows the entire query to be editable? What about making the uneditable query fields editable?

Allow setting dataentry is not enough, one must also set the allowedits property, should we not?

Respectfully,

Lou Reed

[Lou_Reed]

I think that I understand dataentry property, but I am very confused about an editable query and an editable query field. That just is something that i do not know. Please explain or at least give me a website. I know to change dataentry to no. But does that take care making the query and it fields editable?

Any help appreciated. Thanks in advance.

Lou Reed

[Lou_Reed]

I must ask again. I am totally confused by idea of editing a query field as you put it. I assume that editing a query is done by changing dataentry property to no or yes. However, what do you do to edit a field in a query? That one just throws me. I am at a loss. Please explain.

Thanks in advance.

Respectfully,

Lou Reed

[June7]

Basic Access functionality. A table or editable/updatable query can be opened and data input directly by typing/entering into a field. Or a form can be bound to table/query and data input through form controls bound to fields. Forms have more properties to help control user interaction. One of those is DataEntry. DataEntry set to Yes should cause the form to open only to a new record row and not retrieve existing records. But apparently if the form is bound to a non-updatable query this setting is ignored and the form displays existing records.

An aggregate query is one type of query that is never updatable. Also, as in your 'working' form, some combinations of joined tables/queries can result in a non-updatable query.

Other pertinent form properties:

AllowAdditions - prevent or allow new record
AllowDeletions - prevent or allow record deletion
AllowEdits - prevent or allow data edits to existing records

[Lou_Reed]

Okay, but you said some query fields were editable and some were not in both db's that I gave you. How did you tell that? I just do not see it. The two db's that I gave you had one db with frmEmail that did not work and the other had a frmEmail that did work. You said on each of these frmEmail's that some query fields were editable and some were not. I do see how you can tell if a query fields is editable. I know about the form dataentry - yes/no command.

I now want to go in a particular field in a query and edit it.

Also, when you said to get the one db changed so it worked there was nothing about changing the query fields only the dataentry from yes to no.

So what do I change in a query's fields?

Why was this not discussed in the first post of yours that I read this morning that listed the 4 things to do to get frmEmail to work. It was just not discussed.

It seemed in your previous posts to be a big deal.

Any help appreciated. Thanks in advance.

Respectfully,

Lou Reed

[June7]

No, post 10 is referring to the 'working' db in post 9. I said the query was NOT updatable (could NOT edit data in any field). Hence, DataEntry Yes was ignored and existing records retrieved, new record row NOT available.

The query for the 'non-working' form is updatable (could edit data in some fields). Hence, DataEntry Yes was obeyed, form opens only to new record row.

I could tell because I opened queries and tried to do data edits.

And in post 3 I did speak about the DataEntry property as well as entering values in the ysnMeetingID field, which are exactly items 1 and 2 in post 15.

Nowhere do I state you need to change the queries. I said you need to change DataEntry property of form and enter data into ysnMeetingID field of tblAttendance.

You have enough info to make the 'non-working' form function. Perhaps you should re-read the thread from the beginning.

[Lou_Reed]

Okay, I am just curious as to how one edit the query fields. That is all. I would like to see how that is done.

I am not even sure how to access the query properties. I know how to access the form properties and control properties. I do not know how to access the query field in particular. That is all. You said that the query fields were editable for some fields and not editable for other fields for the two db that I gave you.

I just want to know how you find that out. It something that I am not familiar with.

Thanks in advance.

Respectfully,

Lou Reed

[June7]

I have been talking about editing data, not editing design of query. Open query in Datasheet view and type a value into a field. If the input is allowed then this is an editable/updatable query, otherwise it is not.

[Lou_Reed]

Okay, that is the only way that you can tell? I remember that you said some fields were editable and some were not. You cannot tell that without opening the datasheet for each query and checking each field. There is no way to check without going through the procedure you described with the datasheet?

Any help appreciated.

Respectfully,

Lou Reed

[June7]

Any aggregate query (uses GROUP BY and/or an aggregate function or is a CROSSTAB) or any UNION query, any query without a JOIN clause (called a Cartesian relationship) - all will not be updatable.

Otherwise, unless you can tell just by looking at the query structure in Design view, trying entering data and see what happens.

[Lou_Reed]

The link below contains a question that might be better handled here.

https://www.accessforums.net/showthr...t=65898&page=3

As it says, I have four employees and 14 meetings, so why am only getting only four records, not 56.
Each employee can or cannot receive a meeting invite and each employee can or cannot attend a meeting.

That makes for me 56 possibilities, not four.

I am just wondering where I went wrong. Also each meeting can have more than one employee attending it.

So what is wrong with the logic?

Any help appreciated. Thanks in advance.

Respectfully,

Lou Reed

[June7]

I will respond in that other thread.