A Microsoft Office (Excel, Word) forum. OfficeFrustration

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.

Go Back   Home » OfficeFrustration forum » Microsoft Access » Using Forms
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Data entry attempts cause beep.



 
 
Thread Tools Display Modes
  #1  
Old November 12th, 2009, 02:31 AM posted to microsoft.public.access.forms
.Len B
external usenet poster
 
Posts: 81
Default 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  
Old November 15th, 2009, 02:09 PM posted to microsoft.public.access.forms
roy
external usenet poster
 
Posts: 2
Default 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  
Old November 15th, 2009, 02:09 PM posted to microsoft.public.access.forms
roy
external usenet poster
 
Posts: 2
Default 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  
Old November 16th, 2009, 01:20 AM posted to microsoft.public.access.forms
Linq Adams via AccessMonster.com
external usenet poster
 
Posts: 1,474
Default 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  
Old November 16th, 2009, 03:28 AM posted to microsoft.public.access.forms
Gina Whipp
external usenet poster
 
Posts: 3,500
Default 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  
Old November 18th, 2009, 03:22 AM posted to microsoft.public.access.forms
.Len B
external usenet poster
 
Posts: 81
Default 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  
Old November 18th, 2009, 03: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.
|
|
|
|


 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 12:45 PM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.