Rabu, 23 Mei 2012

Re: [MS_AccessPros] Re: Datasheet form updates

 

Clive,
 
Ok, I have my form with my frmWorkOrderMaterials with a subform containing a datasheet called sfrmWorkOrderMaterials. I have created a combobox called cboAddPart with the datasource of SELECT [tblPart].[PartID], [tblPart].[Description], [tblPart].[UnitPrice] FROM tblPart; That resides on the main form. I am creating a command button called cmdAddPart. I would like to use the command button to insert the PartID, Description and UnitPrice from selected record in the combo box into the datasheet on the subform.
 
Does that make sense?
 

With warm regards,

Arthur Lorenzini
Sioux Falls, South Dakota

________________________________
From: Clive <zctek@aol.com>
To: MS_Access_Professionals@yahoogroups.com
Sent: Wednesday, May 23, 2012 12:07 PM
Subject: [MS_AccessPros] Re: Datasheet form updates


 

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]
>

[Non-text portions of this message have been removed]

__._,_.___
Recent Activity:
.

__,_._,___

Tidak ada komentar:

Posting Komentar