HELP with problem showing info in forms: DB corrupt?

S

scubadiver

I posted the following in the forms section but probably wasnt the right
section.

I have two forms with a table as the record source. The table contains
records for all 52 weeks of this year and there is additional information
that goes with these weeks since the beginning of the year until last week.
When I open the forms I get no records at all and, although the field for the
week has the same formatting, it has disappeared. For a third form, the
records only go up to last week. Every week from this week onwards doesn't
appear at all even though they are in the table.

This has only just happened. I have tried copying all the elements into a
new database but the problem still happens.

Any ideas?

cheers
 
6

'69 Camaro

Hi.
When I open the forms I get no records at all
Click to expand...

Open these forms in Design View and then open the Properties window. Select
the Data tab and ensure that the name of the table (or better yet, a query,
for more flexibility and control) shows for the Record Source Property, the
Filter Property is blank, and the Data Entry Property is set to No.
For a third form, the
records only go up to last week. Every week from this week onwards doesn't
appear at all even though they are in the table.
Click to expand...

Ensure that the form's Filter Property is blank and it's using the correct
Record Source.

HTH.
Gunny

See http://www.QBuilt.com for all your database needs.
See http://www.Access.QBuilt.com for Microsoft Access tips and tutorials.
Blog: http://DataDevilDog.BlogSpot.com
http://www.Access.QBuilt.com/html/expert_contributors2.html for contact
info.
 
J

John W. Vinson

I posted the following in the forms section but probably wasnt the right
section.

I have two forms with a table as the record source. The table contains
records for all 52 weeks of this year and there is additional information
that goes with these weeks since the beginning of the year until last week.
When I open the forms I get no records at all and, although the field for the
week has the same formatting, it has disappeared. For a third form, the
records only go up to last week. Every week from this week onwards doesn't
appear at all even though they are in the table.

This has only just happened. I have tried copying all the elements into a
new database but the problem still happens.

Any ideas?

cheers
Click to expand...

What is the Recordsource of the form? The table, or a query? If it's a query,
please post the SQL of the query.

Also, check the Data Entry property of the form. If it is set to Yes you will
see only the blank new record, not any existing records.

As you say, it could be a corrupt form. Does Tools... Database Utilities...
Compact and Repair do anything?

John W. Vinson [MVP]
 
S

scubadiver

Thanks for the reply.

For two of the forms, I changed the "data entry" property to "no" and it has
worked.

For the third form, the recordsource is a query and when I try to enter a
record it says the recordset is not updateable but this hasn't happened. All
my "data" tab allowances are set to "yes" and the "data entry" property is
set to "no".
 
J

John W. Vinson

For the third form, the recordsource is a query and when I try to enter a
record it says the recordset is not updateable but this hasn't happened. All
my "data" tab allowances are set to "yes" and the "data entry" property is
set to "no".
Click to expand...

If the underlying query isn't updateable then the form certainly cannot make
it so.

Search the online help for "updateable" and see if the query can be fixed. I'm
leaving on a trip shortly, but if you start a new thread and post the SQL of
the query someone should be able to help.

John W. Vinson [MVP]
 
Top