C
CHARLES.CLAYTON
A2K
I have a form that use the Datasheet view. The form is based on a
crosstab query. It shows a list of all my drawings and the dates I
received various revisions to those drawings. Depending on the stage
of the job or the quality of engineering, I can have any revision unto
Rev7. All drawings are issued as Rev0 at the beginning.
For the form I have textboxes for all 8 Revisions (Rev0 through Rev7).
However, when you open the form, it will have the "#Name?" error for
those columns that do not exist in the crosstab. This looks
unprofessional to me so I was wondering if there is a way to hide those
columns that do not exist in the crosstab query so that the end-user
will not see the error "#Name?"?
I know that I can force the crosstab to use the column headings I want
and that will eliminate the "#Name?" but it will still leave blank
columns in the form. I would just as soon only show those columns
(Rev0-Rev7) that actually have a value in them.
My coding skill are limited but is there a way to see how many columns
are going to be in the crosstab and then compare that to how many
textboxes are in the form and then hide those columns for which no data
exist?
Thanks,
Charles D Clayton Jr
I have a form that use the Datasheet view. The form is based on a
crosstab query. It shows a list of all my drawings and the dates I
received various revisions to those drawings. Depending on the stage
of the job or the quality of engineering, I can have any revision unto
Rev7. All drawings are issued as Rev0 at the beginning.
For the form I have textboxes for all 8 Revisions (Rev0 through Rev7).
However, when you open the form, it will have the "#Name?" error for
those columns that do not exist in the crosstab. This looks
unprofessional to me so I was wondering if there is a way to hide those
columns that do not exist in the crosstab query so that the end-user
will not see the error "#Name?"?
I know that I can force the crosstab to use the column headings I want
and that will eliminate the "#Name?" but it will still leave blank
columns in the form. I would just as soon only show those columns
(Rev0-Rev7) that actually have a value in them.
My coding skill are limited but is there a way to see how many columns
are going to be in the crosstab and then compare that to how many
textboxes are in the form and then hide those columns for which no data
exist?
Thanks,
Charles D Clayton Jr