New User- Need help with Data Entry

[Nirav]

Hi All,

I am new use of access and first time created form using text boxes and
combo boxes. I am now ready to enter data but it does not allow me to do
that. Arrow and astrick at the bottom are not popping up and so need urgent
help.

I will really appreciate your great help

 

[Jeff Boyce]

Nirav

Is the form bound to a table (or to a query)?

When you say "does not allow me", what specifically is Access doing/saying?

Regards

Jeff Boyce
Microsoft Office/Access MVP

 

[Dirk Goldgar]

Hi All,

I am new use of access and first time created form using text boxes and
combo boxes. I am now ready to enter data but it does not allow me to do
that. Arrow and astrick at the bottom are not popping up and so need
urgent
help.

"Astrick"? Do you mean "asterisk"? I'm not sure what you mean by "not
popping up". If they don't appear at all, make sure you have the form's
Navigation Buttons property set to Yes. If you mean that the "new record"
button is disabled ("greyed out" and unclickable), then your form is not
allowing additions. This could be for any of the following reasons:

1. The form's AllowAdditions property is set to No. If that's the problem,
set it to Yes.

2. The database file is read-only, either directly or because it's in a
folder to which you don't have write access. This is unlikely, though, if
you created the database there.

3, The form is unbound -- that is, it is not based on any table or query, so
it has no power to navigate among records or create a new record.

4. The form is bound, but its record source is not updatable. This is the
most likely cause. If you created the form from fields of multiple tables,
then Access will have created a query to be the form's recordsource, and not
all queries are updatable. Please post the contents of the form's Record
Source property. It may be an SQL statement, or it may be the name of a
stored query. If it's the name of a stored query, please post the SQL View
of that query. Given the SQL, we should be able to see why it is not
updatable.

 

[Golfinray]

Your form is not editable because the table or query it is based on is not
editable. Check for arrow and asterisk on those.

 

[Dirk Goldgar]

Hi All,

I am new use of access and first time created form using text boxes and
combo boxes. I am now ready to enter data but it does not allow me to do
that. Arrow and astrick at the bottom are not popping up and so need
urgent
help.

[...]

3, The form is unbound -- that is, it is not based on any table or query,
so it has no power to navigate among records or create a new record.

From your lates reply in the other thread you started on this issue, it
looks like this is the cause of your problem. It seems you created your
form without first creating any table to hold the records the form would
display.

Forms don't hold records. Tables hold records. A form can be, and most
commonly is, bound to a table (or to a query, which is a selection of
records from one or more tables). A bound form allows you to view, edit,
delete, and add records to the underlying table. The table or query to
which a form is bound is known as its "Record Source" (or "recordsource").

A form can also be unbound, having no Record Source. In that case, the
form's record-handling features are disabled, because the form has no idea
what table(s) and fields should be updated.

When designing a database, start with the tables. Design them to represent
the entities the database will be concerned with, with fields in each table
to describe the attributes of that type of entity, and relationships between
them defining how the various types of entities may be related to each
other. After you've got the tables, create forms to display and edit them,
and bind the forms to the tables by setting the table as the form's Record
Source.