[AccessD] Datasheet subform showing "Error"

[David McAfee]

I tried that. I doesn't work.


OK, after wasting all day, I think the rendering process thinks the nulls
are numeric. I cast 1 column as such:

CAST(NULL AS Varchar(20)) AS ProjectCode

and that column now appears without errors.

Really weird.

I did this same exact thing on another form and it works flawlessly.

Thanks all.
David McAfee

On Tue, May 24, 2022, 3:51 PM John Colby <jwcolby at gmail.com> wrote:

> if push comes to shove requery twice the first time?
>
> On Tue, May 24, 2022 at 6:38 PM David McAfee <davidmcafee at gmail.com>
> wrote:
>
> > Hi all, long time no post. :)
> >
> > I'm  working on a project for a company that we're merging with.
> >
> > It's an old Access 2010 ADP connected to a SQL 2000 DB. Some old,
> isolated
> > legacy set up that they need a new screen to do some maintenance.
> >
> > I made a foem with a datasheet subform.
> >
> > The main form is unbound with text and combo boxes, wose values are used
> > for input parameters.
> >
> > The subform is bound to a stored procedure. The procedure returns all
> nulls
> > as default when the input parameters are all null, such as when the form
> is
> > opened.
> >
> > When the parameters are chosen on the parent form and a command button is
> > clicked,  I simple call: me.mysubform.requery
> >
> > This works for other forms. This form, for some reason returns "#Error"
> in
> > almost every field. The correct number of rows are returned and the PK &
> > GLAccount columns are displayed, but all text columns have the Error.
> >
> > I can hit F5 and nothing changes. But if I switch to design view and come
> > back k to form view the data is displayed correctly.
> >
> > From here on out and I change parameter values and click the button and
> it
> > all works as expected. It's just that initial requery that returns errors
> > in the fields.
> >
> > Any ideas?
> >
> > Thanks,
> > David
> > --
> > AccessD mailing list
> > AccessD at databaseadvisors.com
> > https://databaseadvisors.com/mailman/listinfo/accessd
> > Website: http://www.databaseadvisors.com
> >
>
>
> --
> John W. Colby
> Colby Consulting
> --
> AccessD mailing list
> AccessD at databaseadvisors.com
> https://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
>