Access Database

[Guest]

I'm newbie when comes to Access. I have a database with series of tables and
querys and form sheet to enter the data. when I enter data for each record
everything seems to be fine. But when I close it the database and open it
again all the records disappears! When I look the tables in the tables the
information is there but I can't get it show in the forms fields.

 

[John W. Vinson]

I'm newbie when comes to Access. I have a database with series of tables and
querys and form sheet to enter the data. when I enter data for each record
everything seems to be fine. But when I close it the database and open it
again all the records disappears! When I look the tables in the tables the
information is there but I can't get it show in the forms fields.

Open the Form that does this in design view, and view its Properties. My guess
is that you have the "Data Entry" property set to Yes. This property does just
this - shows you only the new record, and lets you enter data, but conceals
existing records.

Set the property to No and you'll see all the existing data, and still be able
to use the *> navigation button to go to the new record and add new data; or
you can use a tiny bit of code to automatically jump to the new record.



John W. Vinson [MVP]

 

[Guest]

-- This seems to be able to solve my problem but I can not find where I am
to change the Data Entry Prop to No. Is it menu or toolbar?
rasjoy of operations

 

[fredg]

-- This seems to be able to solve my problem but I can not find where I am
to change the Data Entry Prop to No. Is it menu or toolbar?
rasjoy of operations

Open the Form in Design View.
Display the Form's property sheet.
Click on the Data tab.
Set the DataEntry property to No.
Set the AllowEdits to Yes.
Set the AllowDeletions to Yes.
Set the AllowAdditions to Yes.

 

[Guest]

This was helpful-thanks!