On May 12, 10:18=A0am, "Arvin Meyer" <a...@[EMAIL PROTECTED]
> wrote:
> "zufie" <john.marru...@[EMAIL PROTECTED]
> wrote in message
>
> news:6f44ca37-127e-4fb3-9bf6-d8e28dc2b092@[EMAIL PROTECTED]
>
> 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];
> =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D
>
> As Albert and Larry suggested, a query may not be updateable. The
Expressi=
on
> (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
se=
e
> in the navigation buttons at the bottom of the query if there is an
asteri=
sk
> (*). If not, the query won't be updateable, and the resulting form will
no=
t
> be either. Any form which has no records, and is not updateable, will be
> blank.
> --
> Arvin Meyer, MCP,
MVPhttp://www.datastrat.comhttp://www.mvps.org/accesshtt=
p://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=3D2;
(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.
|
