[AccessD] Datasheet subform showing "Error"
davidmcafee at gmail.com
Tue May 24 18:19:01 CDT 2022
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.
I did this same exact thing on another form and it works flawlessly.
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>
> > 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,
> > 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
> > as default when the input parameters are all null, such as when the form
> > 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"
> > 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
> > 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
> Website: http://www.databaseadvisors.com
More information about the AccessD