Information in 'form view' not displaying in 'table view'?

[gh05]

Is this a common problem? Data in certain columns in my form view are not
diaplying when i change to 'table view'. I need to perform calculations on
the data in table view but can't access it.

Any ideas? Help will be much appreciated.

Thanks.

 

[Arvin Meyer [MVP]]

When you say table view, do you mean the form in datasheet view, or are you
actually talking about viewing data in the tables?

If the latter, Stop. Tables are for storing data. Queries are for form and
report record sources and may calculate that data. Forms and reports are for
viewing and manipulating data.

 

[John W. Vinson]

Is this a common problem? Data in certain columns in my form view are not
diaplying when i change to 'table view'. I need to perform calculations on
the data in table view but can't access it.

Any ideas? Help will be much appreciated.

Thanks.

That's odd. Answers to Arvin's questions will help; you might also want to
post the SQL view of the form's Recordsource. Does this happen on just one
form, or all forms? If you create a Query based on the table (all fields, no
criteria, no sorting) do you see the same oddity?

 

[gh05]

Hi Arvin,

Thanks for the reply. It is when I try to view the data in the tables,
basically half of the data within a column has dissapeared. When I view the
form in datasheet view then the correct information is there but if I run a
query to pull the information back then it is just showing me what is held
withing the table (i.e. not much!)

Hope that makes sense.

Cheers

GH

 

[gh05]

Hi John,

yes I get the same problem if I create a basic query based on the table. I
don't know about if it happens for other forms at the moment but will have a
look (the database was actually set up by a friend and it sounds like they
have even less knowledge of Access than myself!)

Unsure of how to post the SQL for a form. I thought that was only possible
for a query?

Thanks

GH

 

[John W. Vinson]

Hi John,

yes I get the same problem if I create a basic query based on the table. I
don't know about if it happens for other forms at the moment but will have a
look (the database was actually set up by a friend and it sounds like they
have even less knowledge of Access than myself!)

You might have some corrupt Indexes. Have you compacted and repaired the
database? Are these local tables or linked?

Unsure of how to post the SQL for a form. I thought that was only possible
for a query?

Most forms are based on Queries, either a query built by the developer or a
hidden query created by Access. Open the form in design view and look at its
Properties. What's in the "Record Source" property? If it's the name of a
query or a SQL string, click the ... icon by it to open the query design grid;
select View... SQL to see the SQL.

 

[Arvin Meyer [MVP]]

The first thing I'd try is to either double the row height or increase the
column width.
--
Arvin Meyer, MCP, MVP
http://www.datastrat.com
http://www.mvps.org/access
http://www.accessmvp.com