 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
MS Access Forum / General 1 / May 2008Forms do not show
Hi, I created some forms using the "Create form using Wizard". However, I cannot view the forms I created with Wizard unless I click on the Design View icon. I checked the forms' properties to no avail. What did I do wrong? How do I correct and avoid this mistake in the future? Thanks in advance! Zufie Access Version? Bound / unbound? Allow Edits? Data Entry? Updateable? When you "cannot view" the forms, exactly what did you do and exactly what happened? It is difficult, at best, to debug remotely. Without detailed information, it is impossible. Larry Linson Microsoft Office Access MVP > Hi, > [quoted text clipped - 11 lines] > > Zufie > Access Version? Bound / unbound? Allow Edits? Data Entry? Updateable? > [quoted text clipped - 24 lines] > > - Show quoted text - Sorry, Access Version? Access 2000 Bound / unbound? That is has a control source Allow Edits? Yes Data Entry? No Updateable? If you mean "Allow Additions" then Yes Zufie Text rearranged, and comments/questions interspersed. I'm not trying to "grill" you under a hot, glaring light -- just trying to figure out what more information might be helpful. >>> I created some forms using the "Create form using Wizard". >>> However, I cannot view the forms I created with Wizard unless I click >>> on the Design View icon. "Larry Linson" <bouncer@localhost.not> wrote >> Access Version? Bound / unbound? Allow Edits? >> Data Entry? Updateable? > Access Version? Access 2000 Do you have all three Service Packs for Access 2000 installed, and any "fixes" since SP3? Access 2000 had problems and, IMNSHO, only really stabilized with SP3. On the toolbar, click Help and About Access 2000 to see what SPs have been applied. Use Windows Update / Office Update to see if there are other "unapplied" fixes. > Bound / unbound? That is has a control source Controls do or do not have Control Source. Does the Form have a Record Source? If so, what is the Record Source? If it is the name of a Query, post the SQL of the Query. > Allow Edits? Yes > Data Entry? No > Updateable? If you mean "Allow Additions" then Yes Are the Controls updateable? That is, what are the settings of their Locked and Enabled properties (in the Data tab of the Property Sheet). I have to ask again... >> When you "cannot view" the forms, exactly what did >> you do and exactly what happened? Did you have the Database Window open, highlight the form, and then click Open; did you click a Command Button, and, if so, what was the code in its click event; or did you open in Design View and click the Form View icon on the toolbar? What _did_ you see, or was there no response at all? Oh, yes, you said you created formS, in plural? Are there other forms in the database, and can you view them under the same circumstances? Are you having difficulties with viewing any other objects in the database? Larry Linson Microsoft Office Access MVP > Text rearranged, and comments/questions interspersed. I'mnottrying to > "grill" you under a hot, glaring light -- just trying to figure out what [quoted text clipped - 50 lines] > Larry Linson > Microsoft Office Access MVP Doyou have all three Service Packs for Access 2000 installed, and any > "fixes" since SP3? Yes, SP-3 is applied Use Windows Update / Office Update to see if there are other "unapplied" > fixes. Did not go fully thru this on Microsoft site as I am not sure what the IT help desk people want us to donwload on our PC's Here is the SQL for the Record Source: SELECT [1st time callers].Date, [1st time callers].[User ID], [1st time callers].Expr1 FROM [1st time callers]; Are the Controls updateable? That is, what are the settings of their Locked > and Enabled properties (in the Data tab of the Property Sheet). Record Locks? No Locks These are the remaining properties listed on the Data tab. Hope this is what you mean by Enabled Properties? Filter? Textbox blank Order by? Textbox blank Allow Filters? Yes Allow Edits? Yes Allow Deletions? Yes Allow Additions? Yes Data Entry? No Recordset Type? Dynaset did you open in Design View and click the Form View icon on > the toolbar? Yes What _did_ you see? The form with text boxes in Design View you said you createdformS, in plural? Are there otherformsin > the database, and can you view them under the same circumstances? Some No, Some Yes Are you having difficulties with viewing any other objects in the database? No Thanks Larry! Zufie So far, this is a puzzler to me. Correct me if I am wrong in understanding your response: You can view the form in Design View, but clicking on the Form View icon in the Toolbar does not change the view to Form View; the screen just stays the same, showing Design View. What happens if you open the database Window, highlight the Form, and click Open? Can you carefully examine the forms that work OK and the ones that do not work OK, and see anything in common between the ones that do not work OK? You looked at the properties sheet for the Form and found the properties you describe -- those are Form properties. If you open the Form in Design View, click a control to chose it, right-click and choose properties, on the data tab for the Control's Properties, you will see a Property "Enabled" and a property "Locked". Enabled = True / Yes means you can add or change data in the Control; Locked = True means if you click in the control, it does not get the focus and the cursor does not move there. I don't expect those are the problem, but worth checking. You might ask your IT people to check if there are any unapplied "fixes" after SP3. Are you having this problem with any other databases? Can you create a new, empty database and recreate the problem building from scratch? What happens if you create a new, empty database and import all the objects from this one? I hope that others will see our puzzlement and join in the discussion, as well, to take a look at this thread... maybe they will have experienced a similar phenomenon (I have not), and I'll ask some other MVPs to take a look here. I'm reluctant to ask anyone to uninstall and reinstall, because although that helps sometime, more often it is a lot of work for nothing -- so I suggest that only as a last resort. Regards, Larry On May 8, 5:53 pm, "Larry Linson" <boun...@localhost.not> wrote: > Text rearranged, and comments/questions interspersed. I'mnottrying to > "grill" you under a hot, glaring light -- just trying to figure out what [quoted text clipped - 54 lines] > Larry Linson > Microsoft Office Access MVP Doyou have all three Service Packs for Access 2000 installed, and any > "fixes" since SP3? Yes, SP-3 is applied Use Windows Update / Office Update to see if there are other "unapplied" > fixes. Did not go fully thru this on Microsoft site as I am not sure what the IT help desk people want us to donwload on our PC's Here is the SQL for the Record Source: SELECT [1st time callers].Date, [1st time callers].[User ID], [1st time callers].Expr1 FROM [1st time callers]; Are the Controls updateable? That is, what are the settings of their Locked > and Enabled properties (in the Data tab of the Property Sheet). Record Locks? No Locks These are the remaining properties listed on the Data tab. Hope this is what you mean by Enabled Properties? Filter? Textbox blank Order by? Textbox blank Allow Filters? Yes Allow Edits? Yes Allow Deletions? Yes Allow Additions? Yes Data Entry? No Recordset Type? Dynaset did you open in Design View and click the Form View icon on > the toolbar? Yes What _did_ you see? The form with text boxes in Design View you said you createdformS, in plural? Are there otherformsin > the database, and can you view them under the same circumstances? Some > No, Some Yes Are you having difficulties with viewing any other objects in the database? No Thanks Larry! Zufie >Here is the SQL for the Record Source: SELECT [1st time callers].Date, [1st time callers].[User ID], [1st time callers].Expr1 FROM [1st time callers]; ---------- does the above work fine as a saved query? I would make the above as a query, and then ensure you can open the query and view/browse the records in the query builder. Also, can you edit the records using the NEW query you just built? I would suggest you get the query working BEFORE you attempt to create the form. So, it only a few forms you can't change? Also, what happens when you open the form in design view, and then switch to form view (ie: don't close the form, but keep it open in design view, and then switch to form view?). Remember, get the query working first, and then perhaps build a test form with the wizard based on that query that we *know* is working just fine. I suspect you deleted a table, or modfied the tables that the form needs...and thus they don't want to open in "user edit mode" but continue to allow opening in desing mode...  SignatureAlbert D. Kallal (Access MVP) Edmonton, Alberta Canada pleaseNOOSpamKallal@msn.com Here is the SQL for the Record Source: SELECT [1st time callers].Date, [1st time callers].[User ID], [1st time callers].Expr1 FROM [1st time callers]; ======================== As Albert and Larry suggested, a query may not be updateable. The Expression (Expr1) may make a query so that it isn't updateable, so you may have to change that slightly. The way to see if it is updateable, is to paste the SQL into the SQL window of a new query and run it. Then take a look and see in the navigation buttons at the bottom of the query if there is an asterisk (*). If not, the query won't be updateable, and the resulting form will not be either. Any form which has no records, and is not updateable, will be blank. SignatureArvin Meyer, MCP, MVP http://www.datastrat.com http://www.mvps.org/access http://www.accessmvp.com > Here is the SQL for the Record Source: > [quoted text clipped - 13 lines] > -- > Arvin Meyer, MCP, MVPhttp://www.datastrat.comhttp://www.mvps.org/accesshttp://www.accessmvp.com I think, Arvin, the form controls will show, but be blank. Probably this is what you mean. In any case, the form can be viewed, that is, it will be visible. My interpretation of the OP is that the form or forms cannot be viewed except in design mode, I tested this with Access 2007, The North-wind sample, a form with a record-source of SELECT [Last Name] & " " & [First Name] AS CalCal FROM Employees WHERE 1=2; (no records and not up-dateable) and one Control-TextBox Text0 with a Control Source of CalCal. The form shows and the empty text box, Text0, shows when the form is opened. I assume OP went to the Window drop down in the tool bar and played with Show, Hide, Cascade etc, after "opening" the form. If not, he or she might try that. I understand that Wizards can help beginners but I feel that, in the long run they create much more trouble than they are worth, and are the greatest cause of bad programming and programming oneself in to a corner as in painting oneself into a corner. Whenever I see a Wizard I try to expunge it. I think, Arvin, the form controls will show, but be blank. Probably this is what you mean. In any case, the form can be viewed, that is, it will be visible. My interpretation of the OP is that the form or forms cannot be viewed except in design mode, I tested this with Access 2007, The North-wind sample, a form with a record-source of =========================== Hi Lyle, Actually, in Access 2003 and earlier, controls on a bound form which has no data and is not updateable will not show, neither will their associated labels. AAMOF, nothing on the form's detail section shows, including command buttons, etc. I haven't tested this yet in A 2007, but will sometime today and let you know. This is what I used from Northwind: Select SupplierID, CompanyName From Suppliers Group By SupplierID, CompanyName Having 1=2; Using an aggregate guaranteed no records and that the query would not be updateable. Your query was not updateable, but it did return 1 blank record. SignatureArvin Meyer, MCP, MVP http://www.datastrat.com http://www.mvps.org/access http://www.accessmvp.com I've seen this happen before. Check the VBA code for Me.Visible = False in the form's load and open events. Check for Cancel = True in the form's open event. Check for the acHidden argument in code that opens the form if you're opening the form from other than the database window. If it's not the code hiding it, the form's window may be out of view. After trying to open it, use the menu for Window - Cascade. If it's out of view, that will pop it back in view again. Chris Microsoft MVP >Hi, > [quoted text clipped - 11 lines] > >Zufie
|
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.