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. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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!! |
#2
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
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 | |
|
|