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
|
|||
|
|||
Form Opens Blank/Appears as if Filter Applied
Hi,
I have an access app in v2007, deployed via the runtime. I have initially installed on 2 machines, both running xp with all sp's/updates applied, and both running office 2003. On one machine, everything works fine, on the other all forms open correctly bar one. When one particular form opens(it is made up of a main & continuous forms subform), the form appears blank; only the field labels appear in the header of the main form. The result is what you would expect if you applied a form filter which returned no records, the sub form does not display at all. On the other machine however, the form displays correctly and the user is able to input data. Data Entry is not set to true, additions/deletions/edits/filters all set to true. Once the working machine add a main record, the non working machine can now see that record, but the subform is not available (as if Filter Empty Master is set, but it's not). Both machines look to the same backend data on a file server, and both frontends are identical, deployed from the same msi package. I have also tested it on a machine running a full version of 2007, and it works fine. Any help/suggestions would be greatly appreciated. Jon. |
#2
|
|||
|
|||
Form Opens Blank/Appears as if Filter Applied
The symptoms definitely appear to be one where a filter has been applied,
then saved. The reasons it doesn't work don't matter if you can fix it, and it doesn't keep happening, so I would simply replace the front-end on the bad machine, with a copy of the front-end from the good machine. Do not reinstall, or change anything, simply copy the file from the good machine and replace the bad one. -- Arvin Meyer, MCP, MVP http://www.datastrat.com http://www.mvps.org/access http://www.accessmvp.com "joneboy" wrote in message ... Hi, I have an access app in v2007, deployed via the runtime. I have initially installed on 2 machines, both running xp with all sp's/updates applied, and both running office 2003. On one machine, everything works fine, on the other all forms open correctly bar one. When one particular form opens(it is made up of a main & continuous forms subform), the form appears blank; only the field labels appear in the header of the main form. The result is what you would expect if you applied a form filter which returned no records, the sub form does not display at all. On the other machine however, the form displays correctly and the user is able to input data. Data Entry is not set to true, additions/deletions/edits/filters all set to true. Once the working machine add a main record, the non working machine can now see that record, but the subform is not available (as if Filter Empty Master is set, but it's not). Both machines look to the same backend data on a file server, and both frontends are identical, deployed from the same msi package. I have also tested it on a machine running a full version of 2007, and it works fine. Any help/suggestions would be greatly appreciated. Jon. |
#3
|
|||
|
|||
Form Opens Blank/Appears as if Filter Applied
Thanks for the response Arvin. I've tried this, and it doesn't work. Further
investigation has revealed that the DB on the bad machine seems to be in a read only state (it's not set as read only). Prepopulated tables (library type info), and their corresponding forms display data, but cannot be edited or added to. I've used the P & D wizard to install in the local user app data directory as I may have vista clients where I believe Program files is readonly. The local user has admin rights on his machine, and the file is definately not set as readonly. I moved the entire app directory to his MyDocuments folder, to which he obviously has full acces, to test the read only issue. When opened from here the app reports a 'unsafe content' warning, press ok & it opens but the same symptoms prevail. The backend DB is on a file server, in a single directory to which all users have full rights. I am now going to attemt stripping rights & reapplying on that directory. Will let you know how I get on. Thanks again, Jon. "Arvin Meyer [MVP]" wrote: The symptoms definitely appear to be one where a filter has been applied, then saved. The reasons it doesn't work don't matter if you can fix it, and it doesn't keep happening, so I would simply replace the front-end on the bad machine, with a copy of the front-end from the good machine. Do not reinstall, or change anything, simply copy the file from the good machine and replace the bad one. -- Arvin Meyer, MCP, MVP http://www.datastrat.com http://www.mvps.org/access http://www.accessmvp.com "joneboy" wrote in message ... Hi, I have an access app in v2007, deployed via the runtime. I have initially installed on 2 machines, both running xp with all sp's/updates applied, and both running office 2003. On one machine, everything works fine, on the other all forms open correctly bar one. When one particular form opens(it is made up of a main & continuous forms subform), the form appears blank; only the field labels appear in the header of the main form. The result is what you would expect if you applied a form filter which returned no records, the sub form does not display at all. On the other machine however, the form displays correctly and the user is able to input data. Data Entry is not set to true, additions/deletions/edits/filters all set to true. Once the working machine add a main record, the non working machine can now see that record, but the subform is not available (as if Filter Empty Master is set, but it's not). Both machines look to the same backend data on a file server, and both frontends are identical, deployed from the same msi package. I have also tested it on a machine running a full version of 2007, and it works fine. Any help/suggestions would be greatly appreciated. Jon. . |
#4
|
|||
|
|||
Form Opens Blank/Appears as if Filter Applied
Arvin,
Removed share permissions on the server & recreated the share & it now is working as it should. Thanks again for your reply. "Arvin Meyer [MVP]" wrote: The symptoms definitely appear to be one where a filter has been applied, then saved. The reasons it doesn't work don't matter if you can fix it, and it doesn't keep happening, so I would simply replace the front-end on the bad machine, with a copy of the front-end from the good machine. Do not reinstall, or change anything, simply copy the file from the good machine and replace the bad one. -- Arvin Meyer, MCP, MVP http://www.datastrat.com http://www.mvps.org/access http://www.accessmvp.com "joneboy" wrote in message ... Hi, I have an access app in v2007, deployed via the runtime. I have initially installed on 2 machines, both running xp with all sp's/updates applied, and both running office 2003. On one machine, everything works fine, on the other all forms open correctly bar one. When one particular form opens(it is made up of a main & continuous forms subform), the form appears blank; only the field labels appear in the header of the main form. The result is what you would expect if you applied a form filter which returned no records, the sub form does not display at all. On the other machine however, the form displays correctly and the user is able to input data. Data Entry is not set to true, additions/deletions/edits/filters all set to true. Once the working machine add a main record, the non working machine can now see that record, but the subform is not available (as if Filter Empty Master is set, but it's not). Both machines look to the same backend data on a file server, and both frontends are identical, deployed from the same msi package. I have also tested it on a machine running a full version of 2007, and it works fine. Any help/suggestions would be greatly appreciated. Jon. . |
#5
|
|||
|
|||
Form Opens Blank/Appears as if Filter Applied
"joneboy" wrote: Hi, I have an access app in v2007, deployed via the runtime. I have initially installed on 2 machines, both running xp with all sp's/updates applied, and both running office 2003. On one machine, everything works fine, on the other all forms open correctly bar one. When one particular form opens(it is made up of a main & continuous forms subform), the form appears blank; only the field labels appear in the header of the main form. The result is what you would expect if you applied a form filter which returned no records, the sub form does not display at all. On the other machine however, the form displays correctly and the user is able to input data. Data Entry is not set to true, additions/deletions/edits/filters all set to true. Once the working machine add a main record, the non working machine can now see that record, but the subform is not available (as if Filter Empty Master is set, but it's not). Both machines look to the same backend data on a file server, and both frontends are identical, deployed from the same msi package. I have also tested it on a machine running a full version of 2007, and it works fine. Any help/suggestions would be greatly appreciated. Jon. |
Thread Tools | |
Display Modes | |
|
|