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

  • Thread starter Thread starter gh05
  • Start date Start date
G

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.
 
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.
 
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.
Click to expand...

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?
 
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
 
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
 
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!)
Click to expand...

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?
Click to expand...

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.
 
Back
Top