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

On Tue, 2 Feb 2010 10:21:01 -0800, gh05
wrote:

>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?
 >> Stay informed about: Information in 'form view' not displaying in 'table view'? 

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
"Arvin Meyer [MVP]" wrote:

> 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.
> --
> Arvin Meyer, MCP, MVP
> [URL="http://www.datastrat.com"]http://www.datastrat.com[/URL]
> [URL="http://www.mvps.org/access"]http://www.mvps.org/access[/URL]
> [URL="http://www.accessmvp.com"]http://www.accessmvp.com[/URL]
>
>
> "gh05" wrote in message
>
> > 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.
>
>
> .
>
 >> Stay informed about: Information in 'form view' not displaying in 'table view'? 

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" wrote:

> On Tue, 2 Feb 2010 10:21:01 -0800, gh05 wrote:
>
> >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?
> --
>
> John W. Vinson [MVP]
> .
>
 >> Stay informed about: Information in 'form view' not displaying in 'table view'? 

On Wed, 3 Feb 2010 02:44:03 -0800, gh05
wrote:

>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.
 >> Stay informed about: Information in 'form view' not displaying in 'table view'? 

The first thing I'd try is to either double the row height or increase the
column width.
 >> Stay informed about: Information in 'form view' not displaying in 'table view'?