Where did my records go?

[Guest]

I created an database using Access 2007. It's a fairly simple call monitoring
database that creates 1 record per every phone call that is supervised. On
the switchboard, I created two icons - one to "add" a new record and another
to "edit/browse" records that have already been saved. There are currently a
little over 500 records.

My problem is that today, all of a sudden, when you click on the
"edit/browse option" the status bar on the bottom reads "Record 1 of 1"
instead of what it used to read, "Record 1 of 519". I checked and the records
have NOT been deleted. Help!!

--Franklin

 

[Guest]

Open the form that is giving you the "Record 1 of 1" in design view. Click
on menu VIEW - Properties. See if the 'Data Entry' property is set to Yes.
If so, then this is the problem.

 

[Guest]

Changing this to either "yes" or "no" didnt change anything. It still reads
record 1 of 1. What is odd to me is that yesterday, it displayed all the
records and no settings/properties have been changed.

I checked with the switchboard manager, and the icon settings to Edit/Browse
a record are accurate - the command is set to 'open form in Edit mode' and I
have it pulling from the my call monitoring form. Its just doesn't seem to
want to display the records. Is there a limit perhaps? It wont show more than
520 records?

Help, again!

--Franklin

 

[Guest]

No limits.
Can you pull records with the query that is the source for your 'call
monitoring form'?

 

[Guest]

Running queries does pull records from the source. I have preset queries and
have run new ones to double-check - they all come up with relevant records.

 

[Guest]

The best I know how is to build a new form.

 

[Guest]

Is there any other option/alternative?

The best I know how is to build a new form.

 

[Dirk Goldgar]

In

Running queries does pull records from the source. I have preset
queries and have run new ones to double-check - they all come up with
relevant records.

Did you specifically check what's in the form's RecordSource property?

Is it possible that a filter or where-condition is being applied to the
form?

 

[John W. Vinson]

My problem is that today, all of a sudden, when you click on the
"edit/browse option" the status bar on the bottom reads "Record 1 of 1"
instead of what it used to read, "Record 1 of 519". I checked and the records
have NOT been deleted. Help!!

If you have the navigation buttons enabled on the form try clicking the >>
icon to move to the last record. Often a form will (initially) display 1 of 1
until Access has traversed the entire recordset. If it's important to show the
number of records onscreen, you can also put code in the form's Load event:

Private Sub Form_Load(Cancel as Integer)
DoCmd.GoToRecord acForm, Me.Name, acLastRecord
End Sub

John W. Vinson [MVP]

 

[Guest]

I've checked the form's RecordSource and it's set properly.

There are no filter or where-conditions being applied to the
form.

When clicking on the >> icon it only stays on the one record. The odd thing
is that is it a blank record. In essence it is not pulling up any of the
saved records at all, nor showing any indication that they exist. Like I
said, I have checked the table containing the records and they are all
intact. I have even created a sample record and then tried looking to
browse/edit it and it did not come up.

 

[Rick Brandt]

I've checked the form's RecordSource and it's set properly.

There are no filter or where-conditions being applied to the
form.

When clicking on the >> icon it only stays on the one record. The odd
thing is that is it a blank record. In essence it is not pulling up
any of the saved records at all, nor showing any indication that they
exist.

Then your form IS in DataEntry mode or it has a filter applied with no matching
records (same thing really).

 

[Dirk Goldgar]

In

Then your form IS in DataEntry mode or it has a filter applied with
no matching records (same thing really).

Is it possible that the form's Data Entry property, in design view, is
set to No, but that it is being opened from a command button that is
explicitly telling it to open in Data Entry mode?