Good idea for the orders bit but i was thinking about the sales side when the goods are being sold to a customer , so far i have got it to process sales of items but just wondering how i would go about creating offers so like when 2 any two items are bought it would give a discount off the sale. Like 1 apple is 50p but for 2 apples it would be 70p so it would -30p off the sale.
Thanks...
User Profile
Collapse
-
Any idea how i could get things like promotion on products to work like any 2 of an item for x.xx ?
ThanksLeave a comment:
-
May Be try using two IF's -
If slot1 = slot2 then
if slot1=slot3 then
runningCredits = runningCredits + 50
me.textbox1.tex t = "You hit the jackpot"
end if
end if...Leave a comment:
-
VB Express 2008 Publish Application Install Folder
I am trying to use VB's Publish feature to make the application install via a exe file .
I have a database mdf file in my project on my local drive but when it installs from the exe is does not install to the local drive so it cant find the mdf files and just shows errors.
How can i get it to install all the files to the same folder as it is on my drive - tried changing the installation folder on publish but it will not acept... -
VB Express Epson TM88iii Serial Printing
Using VB 2008 Express with an Epson tm-t88iii wtih serial cable?
How can i print from Vb to the printer? -
Thanks for your help , i have used your method and it works perfectly...Leave a comment:
-
Thanks , i think the 2 option would be best for future use of more info . I am using vb 2008 express and sql express
my products table contains:
ProductCode
Description
SellPrice
SupplierID
DepartmentID
StockLevel
Min
Max
ProdcutCost
Would i need to take the primay key off the ordernumer or use another table that allows runs to be set to a ordernumer which then can...Leave a comment:
-
OrderId is an autonumber? (do i need it?)
I need to be able to seperate one order from another , how would i do it?...Leave a comment:
-
If my oder table has these fields
Productcode qty totalcost
which then places those items to a unique order id, how do i get multiple product codes and qty to store to that orderId as there is only room for one product to a orderid or do i need another table to store multiple products to the orderid?...Leave a comment:
-
Orders Database Storing Orders
I have a Database with a products table that has min / max stock fiqures , i can query the table for products that are below the min and get it to work out how much of a product needs ordering , but how can i get this data to store in a table like an Order id then it has the all the product codes and the amounts to order? Basically i want to store the query to a table . -
VB Express 2008 + How to use SQL ???
I am really stuck on how to use SQL Express in VB . I have looked at many examples but when trying to use them in VB it just underlines alot of the code and says not declared.
I have mdf database with a products table , i want to be able to enter a product code into a text box then press a button and it checks if the product is in the table and if it is then it fills two other textboxes with the price and description? -
Thanks for the motion , any idea on the compression ive tried lots of formats and its still the same size?Leave a comment:
-
VB WEBCAM capture Record
I have got an app that shows a webcam live image and records it to a file format but it takes up too much space
about 100mb /20sec , can any one help in getting this down ?
Also how would i set it to only record on motion?
And how would i stream the live video over a lan?
Thanks
No activity results to display
Show More
Leave a comment: