Go Back   Access World Forums > Microsoft Access Discussion > General

 
Reply
 
Thread Tools Rate Thread Display Modes
Old 02-18-2019, 02:25 AM   #1
stoicy
Newly Registered User
 
Join Date: Feb 2019
Posts: 40
Thanks: 11
Thanked 0 Times in 0 Posts
stoicy is on a distinguished road
Price auto value

Hello all

I put the price in my database manually.
I need it to be automatically but I am afraid if I change the price in the future, it will effect my saved records.

Please help
Attached Files
File Type: accdb MS Access - Test-2.accdb (748.0 KB, 14 views)

stoicy is offline   Reply With Quote
Old 02-18-2019, 02:40 AM   #2
Gasman
Enthusiastic Amateur
 
Gasman's Avatar
 
Join Date: Sep 2011
Location: Swansea, South Wales,UK
Posts: 4,554
Thanks: 442
Thanked 847 Times in 818 Posts
Gasman is a jewel in the rough Gasman is a jewel in the rough Gasman is a jewel in the rough
Re: Price auto value

So you either store the price for a date range, or lookup the price at the time of data entry and store it, so it does not change.

I tend to do the latter, just because it is easier to implement.

HTH
__________________
Access novice. Sometimes trying to give something back.
Access 2007

Please, please use code tag # when posting code snippets

To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.


To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.


To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
Gasman is offline   Reply With Quote
Old 02-18-2019, 02:41 AM   #3
Tieval
Still Clueless
 
Join Date: Jun 2015
Location: UK
Posts: 429
Thanks: 57
Thanked 42 Times in 42 Posts
Tieval is on a distinguished road
Re: Price auto value

What you need to do is store the price with the order when you enter it but to take this price from a table of current prices.

Basically have a table of current prices which you can update as and when prices change. When you add an order, you can enter the item on the form and default the price to the current price and store it in the order.

This way you have the price at that date and it will not change in old orders when the current price changes.

Gasman, we crossed

Tieval is offline   Reply With Quote
Old 02-18-2019, 03:13 AM   #4
stoicy
Newly Registered User
 
Join Date: Feb 2019
Posts: 40
Thanks: 11
Thanked 0 Times in 0 Posts
stoicy is on a distinguished road
Re: Price auto value

Quote:
Originally Posted by Tieval View Post
What you need to do is store the price with the order when you enter it but to take this price from a table of current prices.



Basically have a table of current prices which you can update as and when prices change. When you add an order, you can enter the item on the form and default the price to the current price and store it in the order.



This way you have the price at that date and it will not change in old orders when the current price changes.



Gasman, we crossed
I do t know how to do it. Could you please give more details or can modify the attached file
Thank you

Sent from my SM-N900V using Tapatalk
stoicy is offline   Reply With Quote
Old 02-18-2019, 03:33 AM   #5
Gasman
Enthusiastic Amateur
 
Gasman's Avatar
 
Join Date: Sep 2011
Location: Swansea, South Wales,UK
Posts: 4,554
Thanks: 442
Thanked 847 Times in 818 Posts
Gasman is a jewel in the rough Gasman is a jewel in the rough Gasman is a jewel in the rough
Re: Price auto value

Use a DLookup to get the relevant price and store it in the record.
__________________
Access novice. Sometimes trying to give something back.
Access 2007

Please, please use code tag # when posting code snippets

To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.


To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.


To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
Gasman is offline   Reply With Quote
Old 02-18-2019, 08:55 AM   #6
stoicy
Newly Registered User
 
Join Date: Feb 2019
Posts: 40
Thanks: 11
Thanked 0 Times in 0 Posts
stoicy is on a distinguished road
Re: Price auto value

Quote:
Originally Posted by Gasman View Post
Use a DLookup to get the relevant price and store it in the record.
How? Could you please explain

Sent from my SM-N900V using Tapatalk
stoicy is offline   Reply With Quote
Old 02-18-2019, 09:01 AM   #7
stoicy
Newly Registered User
 
Join Date: Feb 2019
Posts: 40
Thanks: 11
Thanked 0 Times in 0 Posts
stoicy is on a distinguished road
Re: Price auto value

Quote:
Originally Posted by Gasman View Post
Use a DLookup to get the relevant price and store it in the record.
How? Could you please explain

Sent from my SM-N900V using Tapatalk

stoicy is offline   Reply With Quote
Old 02-18-2019, 09:02 AM   #8
Gasman
Enthusiastic Amateur
 
Gasman's Avatar
 
Join Date: Sep 2011
Location: Swansea, South Wales,UK
Posts: 4,554
Thanks: 442
Thanked 847 Times in 818 Posts
Gasman is a jewel in the rough Gasman is a jewel in the rough Gasman is a jewel in the rough
Re: Price auto value

Quote:
Originally Posted by stoicy View Post
How? Could you please explain

Sent from my SM-N900V using Tapatalk
See this link https://support.office.com/en-us/art...b-bed10dca5937

It can explain it much better that I could and has examples.
__________________
Access novice. Sometimes trying to give something back.
Access 2007

Please, please use code tag # when posting code snippets

To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.


To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.


To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
Gasman is offline   Reply With Quote
The Following User Says Thank You to Gasman For This Useful Post:
stoicy (02-18-2019)
Old 02-18-2019, 01:52 PM   #9
stoicy
Newly Registered User
 
Join Date: Feb 2019
Posts: 40
Thanks: 11
Thanked 0 Times in 0 Posts
stoicy is on a distinguished road
Re: Price auto value

Quote:
Originally Posted by Gasman View Post
See this link https://support.office.com/en-us/art...b-bed10dca5937



It can explain it much better that I could and has examples.
Thank you so much Gasman

This link help me to solve it


Sent from my SM-N900V using Tapatalk

stoicy is offline   Reply With Quote
Reply

Thread Tools
Display Modes Rate This Thread
Rate This Thread:

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Compare price fields in same column and select the lowest price. Marijn Queries 7 02-07-2016 08:01 PM
Auto-fill unit price in tblOrderDetails from tblProducts Hey Lucy Forms 2 05-24-2013 05:45 AM
Unit price from a "Price list" table coming up auto in a invoice next to each product guppa Reports 1 11-02-2012 06:00 AM
Extracting lowest price from 31 downloaded Excel vendor price lists larrynew Queries 9 04-21-2009 09:57 AM
Product Price Auto Updates Using Affective Date MickJav General 5 12-09-2007 11:16 AM




All times are GMT -8. The time now is 12:22 PM.


Microsoft Access Help
General
Tables
Queries
Forms
Reports
Macros
Modules & VBA
Theory & Practice
Access FAQs
Code Repository
Sample Databases
Video Tutorials

Featured Forum post


Sponsored Links


Powered by vBulletin®
Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
(c) copyright 2017 Access World