Rabu, 23 Mei 2012

Re: [MS_AccessPros] Re: Datasheet form updates

 

Clive,
 
Nevermind the question about the FORM A Tabular. I figured that one out.

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

__._,_.___
Recent Activity:
.

__,_._,___

Tidak ada komentar:

Posting Komentar