Blank forms

[dtlns20]

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

 

[Arvin Meyer [MVP]]

Your form is most likely based upon a query which has no data and isn't
updateable.

 

[golfinray]

Check Allen Browne at www.allenbrowne.com He has a solution for that.

 

[dtlns20]

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]

.

 

[dtlns20]

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?

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]

.