Text box will not allow typing

[Cameron]

I have what seems to be a very basic problem. I have a
text box that will not allow me to type in it. With each
keystroke the computer beeps, but no text is added.

I have checked the following:

In the form's properties;
Allow Edits, Additions, Deletions: All Yes
The field's properties;
Enabled: Yes, Locked: No

The field is on a popup form. Both forms have the same
table as their record source and the popup form opens to
the same record using openargs.

Today was the first time that I have run into this
problem. If there was text in the field prior to today I
can eidt/delete with no problem. The problem arises when
the field was previously empty and now the user is going
to update it.

Any help that anyone could give me would be greatly
appreciated.

Cameron
(e-mail address removed)(dot)com

 

[Jeff Boyce]

Cameron

If an existing record allows edits, but a data entry/new record situation
does not, it seems like one possibility might be that the underlying data
source is a query that does not include the primary key of the table to
which the form is bound. That might be one explanation -- Access could be
telling you, "Where do you want me to stick this?" because it doesn't have a
primary key to work with.

Any chance the status bar flashes a message about the "recordset not
updateable"?

Good luck

Jeff Boyce
<Access MVP>

 

[Cameron]

-----Original Message-----
Cameron

If an existing record allows edits, but a data entry/new record situation
does not, it seems like one possibility might be that the underlying data
source is a query that does not include the primary key of the table to
which the form is bound. That might be one explanation - - Access could be
telling you, "Where do you want me to stick this?" because it doesn't have a
primary key to work with.

Any chance the status bar flashes a message about the "recordset not
updateable"?

Good luck

Jeff Boyce
<Access MVP>

Jeff

I wish that I could say that that was the cause. Nothing
on the status bar when I press a key just a beep. FYI,
the recordset for each form is a table, the same one in
fact.

Cameron

 

[Naresh Nichani MVP]

Hi:

Could the record be locked?

To do this make sure form had "RecordSelectors" = Yes and run the form. If
you see a Lock icon in the left that means that record is locked and hence
you cannot edit.

Regards,

Naresh Nichani
Microsoft Access MVP

 

[Jeff Boyce]

Cameron

Now I'm confused. You said that the "same" table is the underlying source
of both your main form and your popup?

You've been describing "how" you are trying to do something. Consider
posting more information about "what" you want to accomplish, leaving out
any description of the mechanism/technology -- put it in "user" terms, like
"I want to be able to add a new record".

Good luck

Jeff Boyce
<Access MVP>

 

[Graham R Seach]

Cameron,

What is the textbox's ControlSource? Is it a calculated field?

Regards,
Graham R Seach
Microsoft Access MVP
Sydney, Australia

 

[Cameron]

All,

Thank you so much for a thriving discussion on how I
might solve this problem.

I have a table (tblActivity)in my database that tracks
all information related to activities. I have one main
form (frmActivity) in the database that allows me to
imput and schedule different types of activities. The
popup form (fsubActivityComplete) I am refering to is an
activity completion form. After the user clicks on a
button, (cmdComplete) code timestamps the completion time
with the now function, and the pop up form opens where
the user can type in some completion notes. There really
shouldn't be a problem because both forms are based on
the same table (tblActivity) and essentially the user is
just typing in a different field on the same record, but
on a different form. Hope that this helps in the
diagnosis.

Cameron

 

[Cameron]

Naresh Nichani,

I turned the record selector on on the popup form and
when I attempted to type a circle with a line through it
appeared. I don't know if that means it is locked but it
must be something. Can you tell me what it is saying and
how I might fix the problem?

Cameron

 

[Cameron Piper]

Graham, Jeff, Naresh, and others,

Thank you all for your help on this matter. After much
reading and searching, I was able to implement a solution
to the problem that I was having.

I think what was causing the problem was that when the
pop up form opened, the main form did not close. Having
two instances of the same record open was causing the
second to be unlocked. The fix was simple in that I
added the following command to the end of the sub, and
all was well in my database again.

DoCmd.Close acForm, "frmActivity", acSaveYes

Thanks again,

Cameron Piper

 

[John Vinson]

There really
shouldn't be a problem because both forms are based on
the same table (tblActivity) and essentially the user is
just typing in a different field on the same record, but
on a different form.

That really IS a problem.

As far as Access can tell, you have two forms, both of which have a
record open for editing; there's no way to know that the two forms
might be making conflicting changes to the record.

The way this is handled is that the first form to open the record
locks that record; the second form will receive an error message, to
the effect that "this record is currently locked by another user".

I suspect that at some point you've done a DoCmd.SetWarnings False or
otherwise turned off warning messages; hence you're getting just a
beep.