bhicks11 via AccessMonster.com said:Yes, that's right. It sounds like there is a filter of some sort. The only
other thing I might do is right click on the upper left hand corner of the
form (where you see the black sideways arrow), click on properties and click
on the data tab. Do you see anything in the filter line?
Bonnie
http://www.dataplus-svc.com
Am I answering this correctly--the data source is a table.
[quoted text clipped - 5 lines]What is the data source? Have you made any changes? If the data source is a
query, open it in datasheet view and see ii looks right.I have been using this the same way for over two years, now all of a sudden
when I open it is blank! Any ideas?
bhicks11 via AccessMonster.com said:Did you right click and then click properties?
I don't see a filter line. There are two black sideway arrows and I clicked
on both of them and I don't see a filter line. I am at a loss, don't know
what to do to get it back. Also when I have the design view of forms up and
I right click and go to print review it will show what the form looks like.
This puzzles me!
[quoted text clipped - 11 lines]Yes, that's right. It sounds like there is a filter of some sort. The only
other thing I might do is right click on the upper left hand corner of theI have been using this the same way for over two years, now all of a sudden
when I open it is blank! Any ideas?
nbeckany said:I don't see a filter line. There are two black sideway arrows and I clicked
on both of them and I don't see a filter line. I am at a loss, don't know
what to do to get it back. Also when I have the design view of forms up and
I right click and go to print review it will show what the form looks like.
This puzzles me!
bhicks11 via AccessMonster.com said:Yes, that's right. It sounds like there is a filter of some sort. The only
other thing I might do is right click on the upper left hand corner of the
form (where you see the black sideways arrow), click on properties and click
on the data tab. Do you see anything in the filter line?
Bonnie
http://www.dataplus-svc.com
Am I answering this correctly--the data source is a table.
What is the data source? Have you made any changes? If the data source is a
query, open it in datasheet view and see ii looks right.
[quoted text clipped - 5 lines]
I have been using this the same way for over two years, now all of a sudden
when I open it is blank! Any ideas?
bhicks11 via AccessMonster.com said:Did you right click and then click properties?
I don't see a filter line. There are two black sideway arrows and I clicked
on both of them and I don't see a filter line. I am at a loss, don't know
what to do to get it back. Also when I have the design view of forms up and
I right click and go to print review it will show what the form looks like.
This puzzles me!
[quoted text clipped - 11 lines]Yes, that's right. It sounds like there is a filter of some sort. The only
other thing I might do is right click on the upper left hand corner of theI have been using this the same way for over two years, now all of a sudden
when I open it is blank! Any ideas?
nbeckany said:I don't see a filter line. There are two black sideway arrows and I clicked
on both of them and I don't see a filter line. I am at a loss, don't know
what to do to get it back. Also when I have the design view of forms up and
I right click and go to print review it will show what the form looks like.
This puzzles me!
bhicks11 via AccessMonster.com said:Yes, that's right. It sounds like there is a filter of some sort. The only
other thing I might do is right click on the upper left hand corner of the
form (where you see the black sideways arrow), click on properties and click
on the data tab. Do you see anything in the filter line?
Bonnie
http://www.dataplus-svc.com
Am I answering this correctly--the data source is a table.
What is the data source? Have you made any changes? If the data source is a
query, open it in datasheet view and see ii looks right.
[quoted text clipped - 5 lines]
I have been using this the same way for over two years, now all of a sudden
when I open it is blank! Any ideas?
Nicholas Scarpinato said:It sounds like this is either a form filter issue, or a query issue. Are you
sure the table is the record source, rather than a query that runs when you
open the form? If it is a query, check to make sure that the query is still
valid... I had a rather strange occurrance happen to me where one minute my
form was perfectly fine and the next it was completely blank; when I checked
the query I was using to get the form data, the entire query's contents had
been deleted somehow. Not the table, but the actual SQL of the query was
completely gone. Once I fixed the query, the form worked fine again.
If the recordsource is in fact a table, try to untoggle the filter. If it's
filtered, you should see a button on your toolbar that looks like a funnel,
and it should be highlighted. Click it and see if your form comes back. You
might have accidentally turned on the form filter at some point without
realizing it, and if you enter something into the form filter and no records
are found for that filter, your form will come up blank.
nbeckany said:I don't see a filter line. There are two black sideway arrows and I clicked
on both of them and I don't see a filter line. I am at a loss, don't know
what to do to get it back. Also when I have the design view of forms up and
I right click and go to print review it will show what the form looks like.
This puzzles me!
bhicks11 via AccessMonster.com said:Yes, that's right. It sounds like there is a filter of some sort. The only
other thing I might do is right click on the upper left hand corner of the
form (where you see the black sideways arrow), click on properties and click
on the data tab. Do you see anything in the filter line?
Bonnie
http://www.dataplus-svc.com
nbeckany wrote:
Am I answering this correctly--the data source is a table.
What is the data source? Have you made any changes? If the data source is a
query, open it in datasheet view and see ii looks right.
[quoted text clipped - 5 lines]
I have been using this the same way for over two years, now all of a sudden
when I open it is blank! Any ideas?
nbeckany said:When I open up my query, if I am doing this correctly, it seems to all be
there.
I am pretty sure that my table is the record source as that is where I input
all my informationl
Nicholas Scarpinato said:It sounds like this is either a form filter issue, or a query issue. Are you
sure the table is the record source, rather than a query that runs when you
open the form? If it is a query, check to make sure that the query is still
valid... I had a rather strange occurrance happen to me where one minute my
form was perfectly fine and the next it was completely blank; when I checked
the query I was using to get the form data, the entire query's contents had
been deleted somehow. Not the table, but the actual SQL of the query was
completely gone. Once I fixed the query, the form worked fine again.
If the recordsource is in fact a table, try to untoggle the filter. If it's
filtered, you should see a button on your toolbar that looks like a funnel,
and it should be highlighted. Click it and see if your form comes back. You
might have accidentally turned on the form filter at some point without
realizing it, and if you enter something into the form filter and no records
are found for that filter, your form will come up blank.
nbeckany said:I don't see a filter line. There are two black sideway arrows and I clicked
on both of them and I don't see a filter line. I am at a loss, don't know
what to do to get it back. Also when I have the design view of forms up and
I right click and go to print review it will show what the form looks like.
This puzzles me!
:
Yes, that's right. It sounds like there is a filter of some sort. The only
other thing I might do is right click on the upper left hand corner of the
form (where you see the black sideways arrow), click on properties and click
on the data tab. Do you see anything in the filter line?
Bonnie
http://www.dataplus-svc.com
nbeckany wrote:
Am I answering this correctly--the data source is a table.
What is the data source? Have you made any changes? If the data source is a
query, open it in datasheet view and see ii looks right.
[quoted text clipped - 5 lines]
I have been using this the same way for over two years, now all of a sudden
when I open it is blank! Any ideas?
nbeckany said:In the data tab there is nothing, it is blank
bhicks11 via AccessMonster.com said:Did you right click and then click properties?
I don't see a filter line. There are two black sideway arrows and I clicked
on both of them and I don't see a filter line. I am at a loss, don't know
what to do to get it back. Also when I have the design view of forms up and
I right click and go to print review it will show what the form looks like.
This puzzles me!
Yes, that's right. It sounds like there is a filter of some sort. The only
other thing I might do is right click on the upper left hand corner of the
[quoted text clipped - 11 lines]
I have been using this the same way for over two years, now all of a sudden
when I open it is blank! Any ideas?
bhicks11 via AccessMonster.com said:Hi Nicholas - did you notice she said there was NOTHING in the data source?
If she is being literal, she has no data source. So I told her to put her
table in.
Bonnie
Nicholas said:Just because you put the data into a table doesn't automatically make that
the record source for the form. Obviously the data has to be in the table in
order to be displayed on the form, but the form's record source could easily
be a query used to limit the data being displayed, or format it in some other
way. Check the Properties of the form and see what it says under
"RecordSource". If it lists a table name, then there's no query issue
involved.
Are you by any chance using linked tables? Look at the table the form (or
the form's underlying query, if there is one) is getting it's data from in
the main database window. If it has an arrow pointing to the right next to
it, that table is a linked table. There could be a network issue preventing
the database from properly linking to that table, causing the form to be
blank because there's no data to display.
[quoted text clipped - 38 lines]When I open up my query, if I am doing this correctly, it seems to all be
there.I have been using this the same way for over two years, now all of a sudden
when I open it is blank! Any ideas?
bhicks11 via AccessMonster.com said:Hi Nicholas - did you notice she said there was NOTHING in the data source?
If she is being literal, she has no data source. So I told her to put her
table in.
Bonnie
Nicholas said:Just because you put the data into a table doesn't automatically make that
the record source for the form. Obviously the data has to be in the table in
order to be displayed on the form, but the form's record source could easily
be a query used to limit the data being displayed, or format it in some other
way. Check the Properties of the form and see what it says under
"RecordSource". If it lists a table name, then there's no query issue
involved.
Are you by any chance using linked tables? Look at the table the form (or
the form's underlying query, if there is one) is getting it's data from in
the main database window. If it has an arrow pointing to the right next to
it, that table is a linked table. There could be a network issue preventing
the database from properly linking to that table, causing the form to be
blank because there's no data to display.
[quoted text clipped - 38 lines]When I open up my query, if I am doing this correctly, it seems to all be
there.I have been using this the same way for over two years, now all of a sudden
when I open it is blank! Any ideas?