Blank forms

Hi, I recently took over our Access 2003 Database from our guy that got laid
off and I am a newbie++. I am having a problem with a form. I have a form
then I have a subform embedded within that. When I log in with the developer
account, I can see the form, but the area where the sub form is is greyed out.
When I log in as a user and try to open the form, I have a completely blank
window.

When I am looged in as developer and look at the form in Design view can I
can see all of the fields in the subform that are supposed to be there, but
in Form view it magically becomes grey.

I have looked at the permissions and set the user and developer accounts to
be the same with no luck. Any advice would be a good start. I have done some
preliminary research and haven't found much. Can anyone help? As I am just
starting out plain english would be greatly appreciated!!!

Thanks

Your form is most likely based upon a query which has no data and isn't
updateable.
--
Arvin Meyer, MCP, MVP
http://www.datastrat.com
http://www.mvps.org/access
http://www.accessmvp.com

"dtlns20" u57315@uwe wrote in message news:a1b6c8330ef14@uwe...
Hi, I recently took over our Access 2003 Database from our guy that got
laid
off and I am a newbie++. I am having a problem with a form. I have a form
then I have a subform embedded within that. When I log in with the
developer
account, I can see the form, but the area where the sub form is is greyed
out.
When I log in as a user and try to open the form, I have a completely
blank
window.

When I am looged in as developer and look at the form in Design view can I
can see all of the fields in the subform that are supposed to be there,
but
in Form view it magically becomes grey.

I have looked at the permissions and set the user and developer accounts
to
be the same with no luck. Any advice would be a good start. I have done
some
preliminary research and haven't found much. Can anyone help? As I am just
starting out plain english would be greatly appreciated!!!

Thanks

Check Allen Browne at www.allenbrowne.com He has a solution for that.
--
Milton Purdy
ACCESS
State of Arkansas


"dtlns20" wrote:

Hi, I recently took over our Access 2003 Database from our guy that got laid
off and I am a newbie++. I am having a problem with a form. I have a form
then I have a subform embedded within that. When I log in with the developer
account, I can see the form, but the area where the sub form is is greyed out.
When I log in as a user and try to open the form, I have a completely blank
window.

When I am looged in as developer and look at the form in Design view can I
can see all of the fields in the subform that are supposed to be there, but
in Form view it magically becomes grey.

I have looked at the permissions and set the user and developer accounts to
be the same with no luck. Any advice would be a good start. I have done some
preliminary research and haven't found much. Can anyone help? As I am just
starting out plain english would be greatly appreciated!!!

Thanks

.

That was the first place I looked. He had some good info, but my setup was
just like he said it should be. I do have data in my tables already and I
have my "allow additions" set to yes. One thing I did notice was that I had
information in SOME cells but not all of them. For example, I have a table
with 50 rows and 4 columns. In the first 5 or 6 each cell is populated, but
it tapers of as I go down the table. The majority of the rows at the bottom
only have one of the four cells populated. I would assume that this doesn't
matter, but I have seen weirder (?) things.

Thanks for the reply!

golfinray wrote:
Check Allen Browne at www.allenbrowne.com He has a solution for that.
Hi, I recently took over our Access 2003 Database from our guy that got laid
off and I am a newbie++. I am having a problem with a form. I have a form
[quoted text clipped - 15 lines]

.

More information... I got the form to work in the developer login (the
subform needed 'allow additions'). Now this form is still showing up blakn
when I login under my user account. Other people get the same blank form
while others can see the whole form, subform included.

I would assume it is a permissions thing?

dtlns20 wrote:
That was the first place I looked. He had some good info, but my setup was
just like he said it should be. I do have data in my tables already and I
have my "allow additions" set to yes. One thing I did notice was that I had
information in SOME cells but not all of them. For example, I have a table
with 50 rows and 4 columns. In the first 5 or 6 each cell is populated, but
it tapers of as I go down the table. The majority of the rows at the bottom
only have one of the four cells populated. I would assume that this doesn't
matter, but I have seen weirder (?) things.

Thanks for the reply!

Check Allen Browne at www.allenbrowne.com He has a solution for that.
Hi, I recently took over our Access 2003 Database from our guy that got laid
off and I am a newbie++. I am having a problem with a form. I have a form
[quoted text clipped - 15 lines]

.