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
|
|||
|
|||
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 |
#2
|
|||
|
|||
Blank forms
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 |
#3
|
|||
|
|||
Blank forms
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 . |
#4
|
|||
|
|||
Blank forms
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] . |
#5
|
|||
|
|||
Blank forms
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] . |
Thread Tools | |
Display Modes | |
|
|