Wrox Programmer Forums
Go Back   Wrox Programmer Forums > Microsoft Office > Access and Access VBA > Access VBA
| Search | Today's Posts | Mark Forums Read
Access VBA Discuss using VBA for Access programming.
Welcome to the p2p.wrox.com Forums.

You are currently viewing the Access VBA section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
  #1 (permalink)  
Old February 5th, 2008, 10:02 AM
Registered User
 
Join Date: Oct 2006
Location: , , .
Posts: 8
Thanks: 0
Thanked 0 Times in 0 Posts
Default How to go about using 2 different pricelists

Ok,

Im making a db for the company i work for and its my first time working with access, i also have very little knowledge of vba.

On the order form i have atm, there is a subform where my bosses would be selecting the products they want for the particular order where the data is retrieved from a price list that doesnt change. However we do get contracts where these prices will vary, so what i thought of is adding a check box which would bring up a new subform and has the same fields and all they would need to do is add the varied products and their prices. Am i thinking about doing this the right way or is there an easier way?

The reason i mention this is because, if i modify the price in the subform where the standard pricelist is the price seems to change for all the orders not just for that one specific order..

what are your thoughts?

  #2 (permalink)  
Old February 5th, 2008, 11:52 PM
Friend of Wrox
 
Join Date: Oct 2007
Location: , , .
Posts: 130
Thanks: 0
Thanked 3 Times in 3 Posts
Send a message via AIM to urtrivedi
Default

You should keep one price field in transaction table
When ever new transaction record is created by default load price from
main product price and allow user to change, so it will effect only current transaction record and your master price will remain unchanged.


urt

Help yourself by helping someone.
  #3 (permalink)  
Old February 6th, 2008, 04:57 AM
Registered User
 
Join Date: Oct 2006
Location: , , .
Posts: 8
Thanks: 0
Thanked 0 Times in 0 Posts
Default

Thanks for the help ill gve it a go, if i could help people with their i would :s but its not like ill disappear after my problem is solved! Im still learning the basics.






Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright (c) 2020 John Wiley & Sons, Inc.