Form visible in data view, not in form view

[sls1365]

Hi

I have read three other threads about this, and checked everything that was mentioned in them (Allow additions set to yes, etc) and all are fine. I am new to access and I have created a 5 tab form, which has taken me days. Suddenly, it isn't visible in form view, but I can see it in data view.

I have, one by one, deleted the other forms to which it refers in case one of those (2 forms) is the issue. Still can't see it. I can just delete the whole thing and spend next week recreating it, but the problem I foresee is that because I don't know why it has happened, I can't stop it happening again. Does anyone have any ideas what I have done wrong?

Sarah

 

[Mr. B]

Have you looked at the "Allow Form View" property of your form. If this is set to no, you will not be able to see the form in "Form View".

 

[RainLover]

Further to Mr.B

Add this code to the On Open event of the form.

DoCmd.Maximize

 

[sls1365]

Thanks for this guys, but it isn't working.

Allow Form View is set to yes and when I put the code in DoCmd.Maximize, it told me that this wasn't recognised. I am tempted to just do it again, but as I said, my worry is that I'll do the same thing again, whatever it is that I have done....

 

[RainLover]

If you can post a cut down version of the Database I will have a look and get back to you with the cause of the problem

 

[sls1365]

If you can post a cut down version of the Database I will have a look and get back to you with the cause of the problem

Thanks Rain, I appreciate it. How do I do that? (very, very new to Access....)

 

[RainLover]

Instead of "Post Quick Reply" use "Go Advanced"

You will see a paper clip. Click on that and you should be right from there.

PS Make sure you supply a 2003 DB as not everyone has moved onto later platforms.

 

[sls1365]

Hi

Its an Access 2010 database and I'm not sure how to make it a 2003 compatible one, certainly, it doesn't give me the option to save it as a 2003 version.

Thanks for your time.

Sarah

 

[gemma-the-husky]

do you mean it opens with no data (blank), so you do not see your labels, etc

that is a different thing, and can happen if you have no data, and a non-updateable recordset

(or where you have set allowadditions = false)

 

[sls1365]

do you mean it opens with no data (blank), so you do not see your labels, etc

that is a different thing, and can happen if you have no data, and a non-updateable recordset

(or where you have set allowadditions = false)

I know Gemma - I have checked all of those things. I can see the whole thing in design view, but just a header and a blank white screen and I don't know why. I have been deleting and recreating various tables and forms to see if these were the problem, because it was after I added subforms to the form that it went wrong.

Sigh.....

 

[missinglinq]

Barring the Form being corrupted, the situation you describe can only be the result of the Form being Bound, the Record Source being empty or non-accessible and the lack of the ability to add New Records.

What exactly does "I have checked all of those things" mean? The reasons that a Bound Form cannot have New Records added include:

1. AllowAdditions for the Form is set to No
2. The underlying Query the Form is based on is Read Only
3. User doesn't have Read and/or Write Permission for the Folder where the Data resides.
4. Folder the File resides in (in versions 2007/2010) not having been declared as 'Trusted'
5. Form's Recordset Type is set to Snapshot
6. All Controls on the Form being Locked or Locked and Disabled.

To see if #2 is the case, from the Objects Dialog Box go to Queries and click on the Query that your Form is based on to open it. Now try to enter a New Record directly into the Query. If you're unable to do so, this is the cause of your problem.

If your Query is Read Only, follow this link to Allen Browne’s article explaining the reasons this happens.

http://allenbrowne.com/ser-61.html

Have you checked all of the above?

Linq ;0)>