Details area on Form does not display...??

  • Thread starter Thread starter Jan :\)
  • Start date Start date
J

Jan :\)

Hi all :-) Access 2007 - Vista Ultimate x86

I have created a new form in to use for data entry. The problem is that the
Header portion displays as it should, but, the details area does not. I have
created several forms in the Access 2007 before and have not seen this
issue. I have checked in the properties and as far as I can tell all looks
as it should. I have allow data entry Yes, single form view, etc., so I am
not sure what I might look for next that could be causing the problem.

Any suggestions would be very much appreciated.

Jan :)
 
Jan :) said:
Hi all :-) Access 2007 - Vista Ultimate x86

I have created a new form in to use for data entry. The problem is that
the Header portion displays as it should, but, the details area does not.
I have created several forms in the Access 2007 before and have not seen
this issue. I have checked in the properties and as far as I can tell all
looks as it should. I have allow data entry Yes, single form view, etc.,
so I am not sure what I might look for next that could be causing the
problem.

Any suggestions would be very much appreciated.
Click to expand...

Hi, Jan -

Check the form's recordsource query (or table) to make sure that it is
updatable. If you open the recordsource directly, as a datasheet, can you
edit or add records? If not, that's the cause of your problem -- a form's
detail section will be blank if there are no records to display and no
records can be added.

If that is your problem, and the recordsource is a query (whether a stored
query or an in-line SQL statement), you may want to search the help file for
keywords such as "updatable", "updateable", "update data", etc. There used
to be a good help topic titled "When can I update data from a query?", but I
don't know if it still exists in A2007. One quick thing to check about your
query is whether its SQL includes either the DISTINCT keyword or the GROUP
BY clause. Such queries are never updatable.
 
Hi Dirk! :-) In line below..

Dirk Goldgar said:
Hi, Jan -

Check the form's recordsource query (or table) to make sure that it is
updatable. If you open the recordsource directly, as a datasheet, can you
edit or add records? If not, that's the cause of your problem -- a form's
detail section will be blank if there are no records to display and no
records can be added.
Click to expand...

Yes, I can enter the data into the recordsource table, but, nothing is
showing in the query datasheet view.
If that is your problem, and the recordsource is a query (whether a stored
query or an in-line SQL statement), you may want to search the help file
for keywords such as "updatable", "updateable", "update data", etc. There
used to be a good help topic titled "When can I update data from a
query?", but I don't know if it still exists in A2007. One quick thing to
check about your query is whether its SQL includes either the DISTINCT
keyword or the GROUP BY clause. Such queries are never updatable
Click to expand...

Here is the SQL for the query the form is based on:

SELECT tblBookNames.BookName, tblBookNames.BookISBN,
tblBookNames.ObtainedFrom, tblAuthorName.AuthorLastName,
tblAuthorName.AuthortFirstName, tblAuthorName.AuthorMiddleName,
tblAuthorName.AuthorNotes, tbProgram.ProgramName, tbProgram.ProgramNotes,
tblProgramOwner.OwnerName, tblPublisher.PublisherName
FROM tblAuthorName, tblBookNames, tblProgramOwner, tblPublisher, tbProgram;

As you can see, I have used several tables to create the query, as I want to
be able to enter the data into each table using the one form, so that each
book only has top be handled once. It has been a while since I did a joint
query and I could have forgotten something. All tables are set up in the
Relationships, which I think are correct.

Thanks, Dirk!

Jan :)
 
Jan :) said:
Yes, I can enter the data into the recordsource table, but, nothing is
showing in the query datasheet view.

Here is the SQL for the query the form is based on:

SELECT tblBookNames.BookName, tblBookNames.BookISBN,
tblBookNames.ObtainedFrom, tblAuthorName.AuthorLastName,
tblAuthorName.AuthortFirstName, tblAuthorName.AuthorMiddleName,
tblAuthorName.AuthorNotes, tbProgram.ProgramName, tbProgram.ProgramNotes,
tblProgramOwner.OwnerName, tblPublisher.PublisherName
FROM tblAuthorName, tblBookNames, tblProgramOwner, tblPublisher,
tbProgram;

As you can see, I have used several tables to create the query, as I want
to be able to enter the data into each table using the one form, so that
each book only has top be handled once. It has been a while since I did a
joint query and I could have forgotten something. All tables are set up in
the Relationships, which I think are correct.
Click to expand...


Your query doesn't join any of the tables together, so what you end up with
is a "cross-product" of all the records in all the tables. Such a query
will not be updatable, because there's nothing in the query to relate one
record to another. Even though you may have specified relationships among
the tables in the Relationships window, your query doesn't use them.

In the design view of your query, you need to draw join lines between the
various tables as appropriate to their relationships. You also need to
decide whether each join should be an inner join, left join, or right join,
according to what you want the query to return when a related record doesn't
exist.

All that said, joining 5 tables in one query, for the purpose of updating
them all from one form, is likely to be problematic. You may well want to
use a form/subform arrangement for some of these relationships.
 
Dirk Goldgar said:
Hi, Jan -

Check the form's recordsource query (or table) to make sure that it is
updatable. If you open the recordsource directly, as a datasheet, can you
edit or add records? If not, that's the cause of your problem -- a form's
detail section will be blank if there are no records to display and no
records can be added.

If that is your problem, and the recordsource is a query (whether a stored
query or an in-line SQL statement), you may want to search the help file
for keywords such as "updatable", "updateable", "update data", etc. There
used to be a good help topic titled "When can I update data from a
query?", but I don't know if it still exists in A2007. One quick thing to
check about your query is whether its SQL includes either the DISTINCT
keyword or the GROUP BY clause. Such queries are never updatable.
Click to expand...

The problem appears to be related to the query. I have entered inforamtion
for several books into the tables in order to test the query, and nothing
displays. So, I obviously am not doing something right in that area. So I
guess the form will work ok once the recordsource is working.

Thank you very much for your time and help. :-)

Jan :)
 
Dirk Goldgar said:
Your query doesn't join any of the tables together, so what you end up
with is a "cross-product" of all the records in all the tables. Such a
query will not be updatable, because there's nothing in the query to
relate one record to another. Even though you may have specified
relationships among the tables in the Relationships window, your query
doesn't use them.

In the design view of your query, you need to draw join lines between the
various tables as appropriate to their relationships. You also need to
decide whether each join should be an inner join, left join, or right
join, according to what you want the query to return when a related record
doesn't exist.

All that said, joining 5 tables in one query, for the purpose of updating
them all from one form, is likely to be problematic. You may well want to
use a form/subform arrangement for some of these relationships.
Click to expand...

Yes, there were some problems with the query, getting the joins corrected,
and I have finally got that squared away, so will use subforms to work with
the data entry.

Thanks, Dirk. :-)

Jan :)
 
Dirk Goldgar said:
Your query doesn't join any of the tables together, so what you end up
with is a "cross-product" of all the records in all the tables. Such a
query will not be updatable, because there's nothing in the query to
relate one record to another. Even though you may have specified
relationships among the tables in the Relationships window, your query
doesn't use them.

In the design view of your query, you need to draw join lines between the
various tables as appropriate to their relationships. You also need to
decide whether each join should be an inner join, left join, or right
join, according to what you want the query to return when a related record
doesn't exist.

All that said, joining 5 tables in one query, for the purpose of updating
them all from one form, is likely to be problematic. You may well want to
use a form/subform arrangement for some of these relationships.
Click to expand...


I have now gotten the query sorted out and data is now displaying, and I
will use some subforms for some of the tables.

Thank you very much for your time and help,

Jan :)
 
Back
Top