Re: Dataforms

Tech-Archive recommends: Fix windows errors by optimizing your registry

Thanks Debra!

That worked fine - thanking you. Would you have any tips on showing just
the dataform and not the data behind it. I don't want the group to see the
data that other's are entering - merely the dataform.

"Debra Dalgleish" wrote:

> Does your table start in the range A1:B2?
>
> If not, you should name the range "Database". There are instructions here:
>
> http://www.contextures.com/xlNames01.html
>
>
> Pimulo Bradfeet wrote:
> > I am trying to set up a simple recorded macros to only show the dataform. I
> > have database-style data on *** 2 and 3. I would like buttons on *** 1
> > that only shows the data form for the requested ***. I have fallen at the
> > first hurdle as although I can manually get the form, when I record the same
> > process:-
> > ...Application.Goto Reference:="start"
> > ....Active***.ShowDataForm
> > I get this:-
> > Run time error 1004. ShowdataForm method of Work*** class failed! I
> > have all the required object libraries switched on.
> > Any help please...
>
>
> --
> Debra Dalgleish
> Excel FAQ, Tips & Book List
> http://www.contextures.com/tiptech.html
>
>
.

Quantcast