Hi Art,
To open the Form for DataEntry then in DesignView
set the DataEntry property to Yes.
Alternatively you could use the same form for
viewing old data or entering new data and use a
CommandButton to switch views.
Regards, Clive.
--- In MS_Access_Professionals@yahoogroups.com, Art Lorenzini <dbalorenzini@...> wrote:
>
> OK I created it as a subform But now I have all my materials listed but I want to start out with a blank datasheet then add rows to with a command button.
>
>
>
>
> With warm regards,
>
> Arthur Lorenzini
> Sioux Falls, South Dakota
>
>
>
>
>
>
> ________________________________
> From: Clive <zctek@...>
> To: MS_Access_Professionals@yahoogroups.com
> Sent: Wednesday, May 23, 2012 6:09 AM
> Subject: [MS_AccessPros] Re: Datasheet form updates
>
>
>
> Â
>
> Hi Art,
>
> Yes you can do it but you can't display a FormFooter
> in DataSheetView.
> You have a choice of either having a Datasheet as
> a SubForm, or use an AutoForm:Tabular(A Form that looks
> like a DataSheet but is really a Form).
>
> Hope that helps.
>
> Regards, Clive.
>
> --- In MS_Access_Professionals@yahoogroups.com, "Art" <dbalorenzini@> wrote:
> >
> > I am trying to create a datasheet popup form. The datasheet is based on the tblWOMaterial:
> >
> > WOMaterialID
> > MaterialID
> > WorkorderID
> > UnitCost
> > Quantity
> > Notes
> >
> > The MaterialID is a lookup to tblMaterial which contains the following fields:
> >
> > MaterialID
> > MaterialCode
> > MaterialName
> > UnitCost
> > Notes
> >
> > In the form footer I am thinking that I would a combobox based
> > "Select MaterialID, MaterialName from tblMaterial"
> > and then add a command button cmdAddMaterial that when the user clicks it would add the material to the datasheet above. Of course I would also need to pass the workorderID to the new record in the datasheet.
> >
> > Also would there be a way to add a running subtotal textbox to it so it updates as the user adds materials?
> >
> > Thank you,
> >
> > Arthur Lorenzini
> > Sioux Falls, SD
> >
>
>
>
>
> [Non-text portions of this message have been removed]
>
Tidak ada komentar:
Posting Komentar