View Single Post
  #7  
Old November 18th, 2009, 02:28 AM posted to microsoft.public.access.forms
.Len B
external usenet poster
 
Posts: 81
Default Data entry attempts cause beep.

I thought so, Gina. I didn't try changing existing data
but it looked like it would let me save new stuff. At least
it let me type stuff and move to the next field.

It doesn't matter now. Users have modified their requirements
and I have changed the query and it now works. See my reply
to Linq.

Thanks for your help. Keep your eye out for Linq's cat too.
You should easily recognize it.
--
Len
__________________________________________________ ____
remove nothing for valid email address.
"Gina Whipp" wrote in message
...
| Len,
|
| You may be able to launch the query but can you edit it? It sounds
like you
| can't. Fixing the query should fix your issue.
|
| --
| Gina Whipp
|
| "I feel I have been denied critical, need to know, information!" -
Tremors
| II
|
| http://www.regina-whipp.com/index_files/TipList.htm
|
| ".Len B" wrote in message
| ...
| I have a subform whose Record Source is a Select Query. It will not
| permit data entry either from the parent form or from the subform
itself.
| The status bar doesn't give an error message.
|
| AllowAdditions and DataEntry are 'Yes'. Dynaset RecordType, no
| RecordLocks. The AllowEdits and AllowDeletions were 'No' but
temporarily
| changing them to 'Yes' didn't help. Some of the fields are locked but
| enabled (eg Date (=Now) and WinUserName) but most are not locked. I
have
| gone through all the form's properties looking for something without
| success.
|
| I can launch the query in the query builder using [...] on
RecordSource
| item, switch to data view and add new records without issue.
|
| Now I'm asking can anyone point me at somewhere to look, please?
|
| --
| Len
| __________________________________________________ ____
| remove nothing for valid email address.
|
|
|
|