Recent content by rollerz
-
R
Today's Date
Can anyone tell me the code i need to put in so when a new row is put in a table it puts in today's date and where to put it? :)Rollerz:) -
R
Order forms
:confused: I've entered in the SELECT DISTINCTROW [ProductID etc... code in, what is it meant to do, it gave me an error message when i mispelled the code but now it is correctly spelled it just gives me an empty combo box, have i made a mistake somewhere? Also, i have 5 Item ID, Price, Quantity... -
R
Order forms
What i have is a form where i make orders, this information is hopefully linked to an order table where the information from the order is sent, the form has order ID, customer ID and date at the top, then further down it has 2 columns of boxes, the first is product id and the second is price... -
R
Order forms
:confused: I am creating a database involving a shop for my AS ICT project, one of the things i need to create is an order form. I am trying to create it so when the product ID is entered on the form the price of it comes up automatically and it adds up all the product prices to give a sub total...