Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
Discussion GroupsFormsForms ProgrammingQueriesModules / DAO / VBAReports / PrintingMacrosDatabase DesignSecurityConversionImporting / LinkingSQL Server / ADPMultiuser / NetworkingReplicationSetup / ConfigurationDeveloper ToolkitsActiveX ControlsNew UsersGeneral 1General 2
Access DirectoryToolsTutorialsUser Groups
Related Topics
SQL ServerOther DB ProductsMS OfficeMore Topics ...

MS Access Forum / Forms / May 2008

Tip: Looking for answers? Try searching our database.

Add a column to Exsisting Form

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Kylie - 25 May 2008 07:51 GMT
How do I add a column to an exsiting Access form (ie. order form) but then
get it to be part of a calculation?  My order form currently has "order Id,
order no, product id, quantity, rate, discount & extended price".  Need to
add length into there, and have formulae
(quantity*length)*rate-discount=extended price.  As you can tell I am a
beginner and would appreciate any help :)
Rick Brandt - 25 May 2008 12:34 GMT
> How do I add a column to an exsiting Access form (ie. order form) but
> then get it to be part of a calculation?  My order form currently has
> "order Id, order no, product id, quantity, rate, discount & extended
> price".  Need to add length into there, and have formulae
> (quantity*length)*rate-discount=extended price.  As you can tell I am
> a beginner and would appreciate any help :)

First you would need to add the field [length] to your table.  Then you
woudl need to make sure that the new field is available to your form.  If
you form's RecordSource property is just the name of your table then the new
field should be available as soon as you modify the table.  If the
RecordSource property is a saved query or SQL Statement you might need to
modify it since the new table field might not automatically be added.

For example.  If your RecordSource is a SQL statement like...

SELECT * FROM TableName

...then the new field will automatically be picked up because the " * "
tells the statement to include all fields from the table. If the SQL
statement lists fields by name...

SELECT [order Id], [order no], [product id], [quantity], [rate], [discount]
FROM TableName

...then the new field would have to be added to the statement before you can
use it in your form.

Once the new field is available in your form you just add a new TextBox that
uses the new field as its ControlSource and then add the name of the field
to your existing expression.

Signature

Rick Brandt, Microsoft Access MVP
Email (as appropriate) to...
RBrandt   at   Hunter   dot   com

 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.