A Microsoft Office (Excel, Word) forum. OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » OfficeFrustration forum » Microsoft Access » Using Forms
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Page displaying in design view, but layout view shows blank screen



 
 
Thread Tools Display Modes
  #1  
Old May 5th, 2010, 09:38 PM posted to microsoft.public.access.forms
TechieMom
external usenet poster
 
Posts: 3
Default Page displaying in design view, but layout view shows blank screen

I have a multi-page form where each page displays a different subform, for a
total of 10 pages. This is a database/form setup that has worked for years,
but now I've encountered a strange issue in Access 2007.

9 of the 10 pages display with no problems; one page however comes up blank.
If I look at the design view for just that page, it displays correctly, but
the layout view gives me just a blank white screen/page. If I look at the
page from within the main form, it displays correctly in design view, but
when switching to layout view, the rest of the form displays correctly and I
still get the blank page in place of where page 2 is supposed to be.

From what I can tell (I'm not very well versed in Access), all the pages are
set up the same way as far as source objects, all point to the same form for
the record set, etc. And like I mentioned above, it's been working for years
on previous versions of Access with no trouble.

Any ideas? Let me know if I can provide additional details that might shed
some light - I'm rather stumped at the moment! Thanks so much!!
Ads
  #2  
Old May 5th, 2010, 10:42 PM posted to microsoft.public.access.forms
John W. Vinson
external usenet poster
 
Posts: 18,261
Default Page displaying in design view, but layout view shows blank screen

On Wed, 5 May 2010 13:38:01 -0700, TechieMom
wrote:

9 of the 10 pages display with no problems; one page however comes up blank.
If I look at the design view for just that page, it displays correctly, but
the layout view gives me just a blank white screen/page.


That symptom suggests that two things are true:

- the Form's Recordsource contains no records (or they're all being filtered
out) so you can't see any existing records
- the form is also not updateable, either because its Allow Updates or Allow
Additions property is turned Off, or more likely because it's based on a query
which is not updateable; so you won't see the empty New Record either.

What is this page (I presume containing a subform??) displaying? If it's a
Subform, what's the subform's Recordsource?

--

John W. Vinson [MVP]
  #3  
Old May 5th, 2010, 11:41 PM posted to microsoft.public.access.forms
TechieMom
external usenet poster
 
Posts: 3
Default Page displaying in design view, but layout view shows blank sc

Yes, it's a subform. Basically, the whole thing a very lengthy evaluation
form for a project that we broke into pages to make it easier for the
evaluators to fill in. Each project being reviewed is a row entry in the
table. Each page contains a subform with input boxes for part of the
evaluation data; the reviewers open a main form and flip thru the pages via
tabs across the top to enter data for each section. So all 10 pages/subforms
are updating the same table (in fact, the same record) until the reviewer
goes to the next record and repeats the process.

I know the recordsource DOES contain records - I have verified this visually
(looking at the table data itself) and the other pages/subforms pointing to
the same recordsource show the data just fine.

As for the Allow Updates or Allow Additions properties, I can check those,
but as I said before I compared the working subforms/pages to the one that is
not working and they all appear to be set up identically.

Since nothing changed from the previous years' database to this one except
for the version of Access we're reading it on, I'm afraid it may be some
random glitch related to the MS Office version changes ...




"John W. Vinson" wrote:

On Wed, 5 May 2010 13:38:01 -0700, TechieMom
wrote:

9 of the 10 pages display with no problems; one page however comes up blank.
If I look at the design view for just that page, it displays correctly, but
the layout view gives me just a blank white screen/page.


That symptom suggests that two things are true:

- the Form's Recordsource contains no records (or they're all being filtered
out) so you can't see any existing records
- the form is also not updateable, either because its Allow Updates or Allow
Additions property is turned Off, or more likely because it's based on a query
which is not updateable; so you won't see the empty New Record either.

What is this page (I presume containing a subform??) displaying? If it's a
Subform, what's the subform's Recordsource?

--

John W. Vinson [MVP]
.

  #4  
Old May 5th, 2010, 11:45 PM posted to microsoft.public.access.forms
TechieMom
external usenet poster
 
Posts: 3
Default Page displaying in design view, but layout view shows blank screen

OK, it appears there was a random filter on that subform that did not exist
on the others; apparently the filter evaluated TRUE on older versions of
Access but did NOT evaluate the same way in Access 2007 :S Strange, but
thanks for pointing me in the right direction; it was GREATLY appreciated!!

"TechieMom" wrote:

I have a multi-page form where each page displays a different subform, for a
total of 10 pages. This is a database/form setup that has worked for years,
but now I've encountered a strange issue in Access 2007.

9 of the 10 pages display with no problems; one page however comes up blank.
If I look at the design view for just that page, it displays correctly, but
the layout view gives me just a blank white screen/page. If I look at the
page from within the main form, it displays correctly in design view, but
when switching to layout view, the rest of the form displays correctly and I
still get the blank page in place of where page 2 is supposed to be.

From what I can tell (I'm not very well versed in Access), all the pages are
set up the same way as far as source objects, all point to the same form for
the record set, etc. And like I mentioned above, it's been working for years
on previous versions of Access with no trouble.

Any ideas? Let me know if I can provide additional details that might shed
some light - I'm rather stumped at the moment! Thanks so much!!

  #5  
Old May 6th, 2010, 12:30 AM posted to microsoft.public.access.forms
John W. Vinson
external usenet poster
 
Posts: 18,261
Default Page displaying in design view, but layout view shows blank sc

On Wed, 5 May 2010 15:41:01 -0700, TechieMom
wrote:

Yes, it's a subform. Basically, the whole thing a very lengthy evaluation
form for a project that we broke into pages to make it easier for the
evaluators to fill in. Each project being reviewed is a row entry in the
table. Each page contains a subform with input boxes for part of the
evaluation data; the reviewers open a main form and flip thru the pages via
tabs across the top to enter data for each section. So all 10 pages/subforms
are updating the same table (in fact, the same record) until the reviewer
goes to the next record and repeats the process.


Ummm... I'd suggest a different approach. For one thing, if the record has so
many fields that this is necessary, your table design may require
reevaluation! A 30-field table is getting pretty wide already!

Secondly, it's perfectly possible to have a Tab Control with multiple pages,
with a modest number of controls on each page, all bound to the same record on
the same table.

I know the recordsource DOES contain records - I have verified this visually
(looking at the table data itself) and the other pages/subforms pointing to
the same recordsource show the data just fine.

As for the Allow Updates or Allow Additions properties, I can check those,
but as I said before I compared the working subforms/pages to the one that is
not working and they all appear to be set up identically.

Since nothing changed from the previous years' database to this one except
for the version of Access we're reading it on, I'm afraid it may be some
random glitch related to the MS Office version changes ...


Wouldn't be the first time, alas! You might want to delete this subform;
compact and repair the database; and recreate the subform (and its query) from
scratch, just in case it has some embedded problem.
--

John W. Vinson [MVP]
 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 07:37 PM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
Copyright 2004-2019 OfficeFrustration.
The comments are property of their posters.