Memo Field - Won't allow type

  • Thread starter Thread starter ShawnaZ
  • Start date Start date
S

ShawnaZ

I have a memo field that will allow me to type into the field in the table or
a simple query but when I create a query using two tables the memo field will
not allow me to enter data into it.

I do not get an error. the computer bings and my keyboard is inoperative.

Any suggestions
 
Certain queries are not updatable. If you open the query by itself and you
can't update data the same thing will happen if you base a form on that
query.

Solution is to create a query that is updatable and then base the form on
that query.

hard to help in other ways without more detail (try posting the sql of the
query),
Mark
 
Please post the SQL of the query. Under various circumstances, queries become
read-only when the data comes from multiple sources, such as when there is a
Group By in the query.
 
Some queries cannot update the data on which they are based. Search Access
help for "edit data in a query"
-TedMi
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Memo Field - allow user to insert hard return (enter) 4
Memo type field size 7
Is it possible to link memo fields? 3
#DELETED shows up in memo field in local table 3
Write to a Memo Field 1
SQL Join 3
Strange Asian looking characters in output 3
Memo Field in Table Truncated in query results and in report 1

Back
Top