Re: Forms do not show

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



"zufie" <john.marruffo@xxxxxxxxxxxx> wrote in message
news:6f44ca37-127e-4fb3-9bf6-d8e28dc2b092@xxxxxxxxxxxxxxxxxxxxxxxxxxxxx
On May 8, 5:53 pm, "Larry Linson" <boun...@xxxxxxxxxxxxx> wrote:
Text rearranged, and comments/questions interspersed. I'mnottrying to
"grill" you under a hot, glaring light -- just trying to figure out what
more information might be helpful.

"zufie" <john.marru...@xxxxxxxxxxxx> wrote

I created someformsusing the "Create form using Wizard".
However, I cannot view theformsI created with Wizard unless I click
on the Design View icon.

"Larry Linson" <boun...@xxxxxxxxxxxxx> wrote

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

"zufie" <john.marru...@xxxxxxxxxxxx> wrote

Access Version? Access 2000

Doyou 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

Controlsdoordonothave 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 ***).

I have to ask again...

When you "cannot view" theforms, exactly what did
youdoand 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 createdformS, in plural? Are there otherformsin
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


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

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



.