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 im****t 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@[EMAIL PROTECTED]
> wrote in message
news:6f44ca37-127e-4fb3-9bf6-d8e28dc2b092@[EMAIL PROTECTED]
May 8, 5:53 pm, "Larry Linson" <boun...@[EMAIL PROTECTED]
> 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...@[EMAIL PROTECTED]
> 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...@[EMAIL PROTECTED]
> wrote
>
> >> Access Version? Bound / unbound? Allow Edits?
> >> Data Entry? Updateable?
>
> "zufie" <john.marru...@[EMAIL PROTECTED]
> 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 Sheet).
>
> 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 cir***stances? 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 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 cir***stances? Some
> No, Some Yes
Are you having difficulties with viewing any other objects in the
database?
No
Thanks Larry!
Zufie
|
