Forms do not show

[zufie]

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

[Larry Linson]

Re: Forms do not show

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

"zufie" <john.marruffo@ illinois.govwro te in message
news:ce7a7c36-470a-44cd-9588-69308845728f@r6 6g2000hsg.googl egroups.com...

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
>

[zufie]

Re: Forms do not show

On May 8, 1:10 pm, "Larry Linson" <boun...@localh ost.notwrote:

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
>
"zufie" <john.marru...@ illinois.govwro te in message
>
news:ce7a7c36-470a-44cd-9588-69308845728f@r6 6g2000hsg.googl egroups.com...
>
>
>

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- Hide quoted text -

>
- 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

[Larry Linson]

Re: Forms do not show

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.

"zufie" <john.marruffo@ illinois.govwro te

>>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@localh ost.notwrote

>Access Version? Bound / unbound? Allow Edits?
>Data Entry? Updateable?

"zufie" <john.marru...@ illinois.govwro te

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

[Albert D. Kallal]

Re: Forms do not show

>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...


--
Albert D. Kallal (Access MVP)
Edmonton, Alberta Canada
pleaseNOOSpamKa llal@msn.com

[Chris O'C via AccessMonster.com]

Re: Forms do not show

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


zufie wrote:

>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

--
Message posted via AccessMonster.c om

http://www.accessmonster.com/Uwe/Forums.aspx/databases-ms-access/200805/1

[Arvin Meyer]

Re: Forms do not show

"zufie" <john.marruffo@ illinois.govwro te in message
news:6f44ca37-127e-4fb3-9bf6-d8e28dc2b092@8g 2000hse.googleg roups.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.
--
Arvin Meyer, MCP, MVP

http://www.datastrat.com

http://www.mvps.org/access

http://www.accessmvp.com

[lyle fairfield]

Re: Forms do not show

On May 12, 10:18 am, "Arvin Meyer" <a...@m.comwrot e:

"zufie" <john.marru...@ illinois.govwro te in message
>
news:6f44ca37-127e-4fb3-9bf6-d8e28dc2b092@8g 2000hse.googleg roups.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.
--
Arvin Meyer, MCP, MVPhttp://www.datastrat.c omhttp://www.mvps.org/accesshttp://www.accessmvp.c om

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.

[Arvin Meyer]

Re: Forms do not show


"lyle fairfield" <lyle.fairfield @gmail.comwrote in message
news:4cb9973c-e458-4260-9044-34400276a8f4@f3 6g2000hsa.googl egroups.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
=============== ============
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.
--
Arvin Meyer, MCP, MVP

http://www.datastrat.com

http://www.mvps.org/access

http://www.accessmvp.com