No lines at all in Query results

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Someone asked me the following question, and I have been unable to duplicate
the problem. Anyone have an idea as to what could be causing this?

I'm building a database and have created a query which includes most fields
from each of the db tables. This query has been designed to allow me to build
an input form for the db.
When I run the query, the results are blank. What I mean by this is the
resulting query in sheetview only shows column headings. There is not even
the normal one blank record when no results are returned.
How can I correct?

Thanks in advance

tj
 
tjtjjtjt said:
Someone asked me the following question, and I have been unable to
duplicate the problem. Anyone have an idea as to what could be
causing this?

I'm building a database and have created a query which includes most
fields from each of the db tables. This query has been designed to
allow me to build an input form for the db.
When I run the query, the results are blank. What I mean by this is
the resulting query in sheetview only shows column headings. There is
not even the normal one blank record when no results are returned.
How can I correct?

Thanks in advance

tj
Click to expand...


a) There are no records in the tables

b) The joins you have created result in zero matching rows

c) The criteria applied (if any) result in zero rows

Multi-table queries are often non-editable which is why you don't get the blank
"New row".
 
Thanks, I'm testing this at home now, and I'm on Office 2003 here. With all
the Tables empty, with the default Join Type and any or no criteria, I always
get a blank line. It is not editable (as you pionted it out), but it is
there. I can't seem to force Access to give me only the Column Headings.

tj
 
tjtjjtjt said:
Thanks, I'm testing this at home now, and I'm on Office 2003 here. With all
the Tables empty, with the default Join Type and any or no criteria, I always
get a blank line. It is not editable (as you pionted it out), but it is
there. I can't seem to force Access to give me only the Column Headings.
Click to expand...

Doesn't make sense. An Access query datasheet will only give you the blank "new
line" display in a query that is editable. Are you sure you're not looking at a
record that just happens to contain no data?

Does the navigation button area display the "go to new record" button as grayed
out?
 
Well, I created this database by Importing Table Definitions. None of the
Tables have ever been opened or had anything typed into them via form or
query. There is no data.
I get a blank Record beneath the Column Headings.

tj
 
The new option is grayed out. As I mentioned before, the blank line is not
editable. What I'm curious about is why one computer displays only the Column
Heads when the Qurey runs, and my computer displays the Column Heads and a
blank, uneditable line.

tj
 
Thanks, I'm testing this at home now, and I'm on Office 2003 here. With all
the Tables empty, with the default Join Type and any or no criteria, I always
get a blank line. It is not editable (as you pionted it out), but it is
there. I can't seem to force Access to give me only the Column Headings.

tj
Click to expand...

You're going about this in the wrong way!

Building one massive Master Query with all the tables in your database
is - just possibly - ok for generating a Report. It is NOT a good way
to prepare for data entry.

Such multitable queries are generally non updateable; if they are
updateable they'll be confusing to the user, since the "one" table
data will be repeated multiple times, one for each "many" table row.

You're much better off designing input forms with Forms and Subforms,
so you can see a single "one" table record together with all the
matching "many" table records.

John W. Vinson[MVP]
 
Thank you for the reply, but if you read the original post, I posted the
question because of a question that was asked of me. The desing of the
database is out of my hands.
I was simply trying to recreate someone else's difficutly and could not. I
was hoping someone could explain why.
I'm starting to suspect it may just be a version difference.

tj
 
Thank you for the reply, but if you read the original post, I posted the
question because of a question that was asked of me. The desing of the
database is out of my hands.
I was simply trying to recreate someone else's difficutly and could not. I
was hoping someone could explain why.
I'm starting to suspect it may just be a version difference.

tj
 
tjtjjtjt said:
The new option is grayed out. As I mentioned before, the blank line is not
editable. What I'm curious about is why one computer displays only the Column
Heads when the Qurey runs, and my computer displays the Column Heads and a
blank, uneditable line.
Click to expand...

This last statement is the problem. You should either have a blank "new row"
line that IS editable or you should not have the line at all.

The fact that the line is there is so you can ADD records. If the query didn't
allow edits then the blank row would not be there.

Now, if this were a form datasheet then you can set them to allow additions, but
not edits. A query does not have this capability AFAIK and if that is what you
were seeing you would be able to type in the blank row.
 
Just to see what would happen, I opened a database that has data in it. I
opened a query and edited it so the criteria would return no results would be
returned. Same deal: a blank line that I can't edit (this query also goes
across multiple tables).
For a single table query, I can edit the blank line (as expected).

tj
 
tjtjjtjt said:
Thanks, I'm testing this at home now, and I'm on Office 2003 here. With all
the Tables empty, with the default Join Type and any or no criteria, I always
get a blank line. It is not editable (as you pionted it out), but it is
there. I can't seem to force Access to give me only the Column Headings.

tj
Click to expand...

tjtjjtjt,

May I what difference this makes?

If there is no data in the source tables, why do you care about
whether the Query's "datasheet" view has a blank line, or nothing?


Sincerely,

Chris O.
 
Back
Top