Dissapearing Details Section very strange

[Tal]

Hello All,

This one has completely confounded me.
So, I have a form that comprises a Header section full of filter fields and
a filter button. Then I have a detail section that displays all the filtered
records as a continuous form. The query that this is based on cannot be
edited.
Then I have a footer section that has a subform that displays the
information from a single selected record that can be edited.
Here's where it gets weird.
On my computer the continuous detail section displays perfectly. On any
other machine in my office, this section completely dissapears.
Help!!
All ideas greatly appreciated!

Cheers,
Tal

 

[John W. Vinson]

On my computer the continuous detail section displays perfectly. On any
other machine in my office, this section completely dissapears.

This will typically happen when two conditions are true: the form's
Recordsource returns no data (so there are no existing records to display) and
the form is not updateable (so there is no "new record" to display either).

Might this be the case on your colleagues' machines, either because they have
different data or because of file permissions? Try opening the form's
Recordsource query itself and see if it returns any records.

 

[Tal]

Hi John,

So, I think maybe the issue is that it is not updateable, because running
the query does bring up all the records. How do I get the records to display
anyway? Like they do on my machine?

Cheers,
Tal

 

[John W. Vinson]

Hi John,

So, I think maybe the issue is that it is not updateable, because running
the query does bring up all the records. How do I get the records to display
anyway? Like they do on my machine?

"not returning all the records" has absolutely nothing to do with being
updateable!

And I have no idea how the records display on your machine, so I can't really
help.

Go to a colleague's machine exhibiting the problem. Open the Form's
Recordsource query as a datasheet.

Does it contain *any* records?
If so are they the expected/correct records?
At the bottom of the datasheet there will be a blank row with a *> icon at its
left if the recordset is updateable. Is there such a row?

 

[John W. Vinson]

Hi John,

I did what you said (running the source query as a datasheet) and the query
did return all the expected records. And no, the query is not updateable. Can
I make it display anyway?

If it's returning records, I don't know why they should be showing on one
machine and not another (if you're using the same frontend). Is it possible
that the users' machines have the Data Entry property of the form set to Yes?
That would hide the existing records.

 

[Tal]

Hi John,
Definitely using the same frontend and the same backend. Very strange indeed!!
Does it help if I tell you that it's Office 2007?

Cheers,
Tal

 

[John W. Vinson]

Hi John,
Definitely using the same frontend and the same backend. Very strange indeed!!
Does it help if I tell you that it's Office 2007?

Just be sure that you have all service packs *AND* the post-SP3 hotfix
installed.

 

[Tal]

Hi John,

Thanks for sticking with me. I have tried everything. I have changed the
record source to something editable. I have checked the computers for
updates, etc.
It is still not working!!!

Any other ideas?
Cheers,
Talia

 

[John W. Vinson]

Hi John,

Thanks for sticking with me. I have tried everything. I have changed the
record source to something editable. I have checked the computers for
updates, etc.
It is still not working!!!

Any other ideas?

I'll ask some of the other MVP's to look in on this thread. I'm baffled too!

 

[John W. Vinson]

Hi John,

Thanks for sticking with me. I have tried everything. I have changed the
record source to something editable. I have checked the computers for
updates, etc.
It is still not working!!!

Bill Mosca suggested that you'll see vanishing forms if the forms (for example
switchboard forms, though I'd guess it applies to any form) have code, and the
database is not in a trusted location. Try checking to see if the users have
the folder containing the frontend trusted.

 

[Tal]

Hi John,

Again, thank you so much for sticking with me, but I did definitely check
that.
I have managed a work around by making the form into a split form, but it is
not nearly as elegant.

Cheers,
Tal

 

[John W. Vinson]

Hi John,

Again, thank you so much for sticking with me, but I did definitely check
that.
I have managed a work around by making the form into a split form, but it is
not nearly as elegant.

Got me beat then! Sorry I couldn't help more!