Try this

[Replies] [Reply] [View by Thread] [Help]
[Back To CyberArmy Public Forum]

Lt FanTasY

You must define an event action. You can find a tut about it @
http://mis.bus.sfu.ca/tutorials/MSAccess/tutorials/macro.pdf
Other tutorials about related things can be found here:
http://mis.bus.sfu.ca/tutorials/MSAccess/tutorials.html

Hope that helps
-+ Fantasy +-
On 2002-12-13 09:27:16, goremaster wrote
>Having trouble in access, i have the tables:
>
>TblSales
>------------
>SaleID (PK)
>EmployeeID
>DateOfSale
>TimeOfSale
>StockID
>Quantity
>UnitPrice
>TotalSalePrice
>
>and
>
>TblStock
>--------
>StockID
>Description
>UnitPrice
>TypeOfStock
>Damaged?
>Shelf-Life
>Edited?
>CurrentQuantity
>SuggestedStockLevel
>QuantityToOrder
>
>I have two forms with exactly the same fields FrmSales and FrmStock
>
>In the sales form I have a seperate part that looks like this
>
>---------------------------------
>| StockID| \/ | (combo box)
>---------------------------------
>-----------------------
>Quantity|| (text box)
>-----------------------
>-----------------------
>Unit Price|| (text box)
>-----------------------
>-----------------------
>Total Sale Price|| (text box)
>-----------------------
>
>the above is from the sales form with the combo getting information from TbLStock, while text boxes all linked to TblSales, what I want to do is this... when a StockID is chosen, i need access to look into TblStock and retreive the Unit Price from there and put it into the Unit Price box in FrmSales
>
>It would help if there was either code to do that, or a better way that I can't think of.
>
>-------------------------------------------------
>The Gore Master - Mere Trooper
>
>I'm as good a Trooper as Rincewind is a Wizard.
>-------------------------------------------------

Lt.KernelFantasy
C/O Web Site Management Division (#455)

Contact

Replies:

more access problems - Tr goremaster 2002-12-13 09:27:16
- >Try this - Lt FanTasY 2002-12-13 17:02:09 <
- RE: more access problems - Tr goremaster 2002-12-13 15:41:24
  - No! :P - 2nd Lt TaylorDyne 2002-12-13 16:36:10
- BTW, Get mirc... ;] ~url~ - 2nd Lt TaylorDyne 2002-12-13 09:38:31
- Access sucks ass... /more/ - 2nd Lt TaylorDyne 2002-12-13 09:37:23
  - Heh.. isn't this thread a lil funky? o.O -nt- - Ker inspectorgadget 2002-12-16 01:10:39
  - RE: Access sucks ass... /more/ - Tr goremaster 2002-12-13 09:39:49
    - Heh he he! :P - 2nd Lt TaylorDyne 2002-12-13 09:41:33
      - RE: Heh he he! :P - Tr goremaster 2002-12-13 09:43:09
        Ummm... - 2nd Lt TaylorDyne 2002-12-13 09:45:36
        RE: Ummm... - Tr goremaster 2002-12-13 09:50:11
        RE: Ummm... - 2nd Lt TaylorDyne 2002-12-13 09:52:14
        RE: Ummm... - Tr goremaster 2002-12-13 09:54:30
        He he he ;P *can't help ya, too tired* ~nt~ - 2nd Lt TaylorDyne 2002-12-13 09:55:24
        RE: He he he ;P *can't help ya, too tired* ~nt~ - Tr goremaster 2002-12-13 09:58:52

Guest:
Subject:
Message:	On 2002-12-13 17:02:09, FanTasY wrote >You must define an event action. You can find a tut about it @ >http://mis.bus.sfu.ca/tutorials/MSAccess/tutorials/macro.pdf >Other tutorials about related things can be found here: >http://mis.bus.sfu.ca/tutorials/MSAccess/tutorials.html > >Hope that helps >-+ Fantasy +- >On 2002-12-13 09:27:16, goremaster wrote >>Having trouble in access, i have the tables: >> >>TblSales >>------------ >>SaleID (PK) >>EmployeeID >>DateOfSale >>TimeOfSale >>StockID >>Quantity >>UnitPrice >>TotalSalePrice >> >>and >> >>TblStock >>-------- >>StockID >>Description >>UnitPrice >>TypeOfStock >>Damaged? >>Shelf-Life >>Edited? >>CurrentQuantity >>SuggestedStockLevel >>QuantityToOrder >> >>I have two forms with exactly the same fields FrmSales and FrmStock >> >>In the sales form I have a seperate part that looks like this >> >>--------------------------------- >>\| StockID\| \/ \| (combo box) >>--------------------------------- >>----------------------- >>Quantity\|\| (text box) >>----------------------- >>----------------------- >>Unit Price\|\| (text box) >>----------------------- >>----------------------- >>Total Sale Price\|\| (text box) >>----------------------- >> >>the above is from the sales form with the combo getting information from TbLStock, while text boxes all linked to TblSales, what I want to do is this... when a StockID is chosen, i need access to look into TblStock and retreive the Unit Price from there and put it into the Unit Price box in FrmSales >> >>It would help if there was either code to do that, or a better way that I can't think of. >> >>------------------------------------------------- >>The Gore Master - Mere Trooper >> >>I'm as good a Trooper as Rincewind is a Wizard. >>------------------------------------------------- > > >[b][img=http://www.cyberarmy.com/includes/cbadges/ltcol.gif]Lieutenant Kernel[/img] Lt.Kernel[color=red]Fantasy[/b] >[i][b]C/O[/b] Web Site Management Division (#455)[/i] >[/color] >[b]Contact[/b][list] >[]cMS - [url=http://www.cyberarmy.com/office/cMS/compose/Fantasy][color=red]Fantasy[/color][/url] >[]E-Mail - [email=ciri@VirtuaX.be][color=red]Fantasy's mail[/color][/email] >[]MSN - [url=http://messenger.msn.com][color=red]ciribeertje@hotmail.com[/color][/url] >[]ICQ - [url=http://www.icq.com][color=red]39128200[/color][/url] >[/list]
Signature:
Optional Image Link:
http://

CyberArmy::Forum v0.6
Generated In 0.05134 seconds