If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Data entry attempts cause beep.
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. |
#2
|
|||
|
|||
Data entry attempts cause beep.
".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. |
#3
|
|||
|
|||
Data entry attempts cause beep.
... 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. |
#4
|
|||
|
|||
Data entry attempts cause beep.
I'm not exactly sure what you mean by
"It will not permit data entry either from the parent form or from the subform itself." Can you add/edit data on the main form? If the main form is Read-Only you won't be able to Add/Edit records in the subform. -- There's ALWAYS more than one way to skin a cat! Answers/posts based on Access 2000/2003 Message posted via AccessMonster.com http://www.accessmonster.com/Uwe/For...forms/200911/1 |
#5
|
|||
|
|||
Data entry attempts cause beep.
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. |
#6
|
|||
|
|||
Data entry attempts cause beep.
"Linq Adams via AccessMonster.com" u28780@uwe wrote in message
news:9f2ccd955cfda@uwe... | I'm not exactly sure what you mean by | | "It will not permit data entry either from the parent form or from the | subform itself." | | Can you add/edit data on the main form? If the main form is Read-Only you | won't be able to Add/Edit records in the subform. | | -- | There's ALWAYS more than one way to skin a cat! | | Answers/posts based on Access 2000/2003 | | Message posted via AccessMonster.com | http://www.accessmonster.com/Uwe/For...forms/200911/1 | What I meant was: When trying to type in any field of the subform, either by having opened the parent form or just the subform itself, I received a beep and the cursor didn't move or change. I then opened the query builder from within the subform as I have said. I could see the records. I proceeded to the new record row and began typing dummy data. No objections or beeps and the cursor jumped to the next field as expected. I didn't try to save the dummy data but I was allowed to enter it. I have since had to add fields to underlying tables and I created a new lookup table as well. I also had to add controls to the subform. That's when I opened the query from the database window. I removed one join from the query and added the new one for the lookup. Now it works. It appears that somehow the join I deleted was making the data unupdatabe. Thanks for your help, Linq. I'll keep my eye out for your cat. -- Len __________________________________________________ ____ remove nothing for valid email address. |
#7
|
|||
|
|||
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. | | | | |
Thread Tools | |
Display Modes | |
|
|