Product Discounts for Customers

[KenshiroUK]

unless a query based on whats currently in to whats been ordered?

 

[bob fitz]

unless a query based on whats currently in to whats been ordered?

If you use a query now to do that calculation, surely you can still use a query, just means the calculation would be different.

 

[KenshiroUK]

Its okay I think I have figured it out now.

 

[bob fitz]

Its okay I think I have figured it out now.

OK. Good luck with your project.

 

[KenshiroUK]

Hi, I think I may have caused a problem with the database you sent me. I changed the product ID from a digit to the actual sku as it should be however. I am now getting a debugging message and don't know what to changein order for it to work correctly

 

[bob fitz]

See if this is better:

 

[KenshiroUK]

I do really appreciate this! If you ever need a website building let me know!

 

[bob fitz]

I do really appreciate this! If you ever need a website building let me know!

Thank You. Is that what you 'do' then?

 

[KenshiroUK]

Hi Bob, once again I have managed to break the database you sent me. I added in a new dropdown box with Product code, because orders will be placed on either product name or product id. When I pick an item this works fine, however there is no price being generated now. Any chance you take a look?

 

[bob fitz]

Happy to take a look when I have a few minutes, but you will need to attach the db.

 

[KenshiroUK]

Posted a copy

 

[bob fitz]

Sorry, but it needs to be in A2003 mdb format.

 

[KenshiroUK]

Try this now. Not sure how I keep breaking this database.

 

[bob fitz]

Sorry, but the last attached file is not A2003 mdb.

 

[KenshiroUK]

Sorry about this. I'll try again

 

[bob fitz]

Try the file attached:

 

[KenshiroUK]

Hi I tried your database you sent back, but it didn't appear to work. When I clicked on the product code it altered the product title, but still hasn't changed the price. I don't need that code stored within the table, I just need it to update the price and product name within the form.

 

[bob fitz]

KenshiroUK

Hi I tried your database you sent back, but it didn't appear to work. When I clicked on the product code it altered the product title, but still hasn't changed the price. I don't need that code stored within the table, I just need it to update the price and product name within the form.

If the quantity ordered is changed, then the QtyToFollow should change, but it was not changing. I have altered the code in the After Update event of the Qty control to correct this. If there is something else, not working as required, please post back.

 

[bob fitz]

Do you still need help in dealing with the QtyToFollow when new stock arrives, that you requested at: //www.access-programmers.co.uk/forums/showthread.php?t=252946