Search results

heres the code for the frmorder form Private Sub Order_Date_BeforeUpdate(Cancel As Integer) End Sub Private Sub tblProduct_subform_Enter() End Sub Private Sub tblProduct_subform_Label_Click() End Sub Private Sub add_order_Click() On Error GoTo Err_add_order_Click DoCmd.GoToRecord , ...

could someone take a look at my db that i have made that has experince, i have asked my teachers and they dont really know how to fix the problem thx in advance

yeh i did and it still aint workin:(

hi i jus tried the code given and it still doesnt work:(

anyone

I need to know how to put an input mask in so that when I write The Road name in an address both names begin with capital letters e.g rectory road becomes Rectory Road

hi there pat ive had a look at the nrthwind db and found this Private Sub ProductID_AfterUpdate() On Error GoTo Err_ProductID_AfterUpdate Dim strFilter As String ' Evaluate filter before it's passed to DLookup function. strFilter = "ProductID = " & Me!ProductID '...

thx but it diodnt work i mite of not written the question properly the image belowmay tell u wot i excatly want to do i have also checked the northwind sample db and the order subform is exactly wot i want to do but it aint workin

i have tried wot u sed but it says that it cant find the macro "ME":confused: :confused: :confused:

thx wayne i'll see if it works

hi there could u break down the formula Me.txtPrice = Me.txtProduct.Column(2) as i am a little confused about changing the fields

subform........(help with college project) hi there im havin a problem wot i want to do is on the subform which can be downloaded below, when a product is selected i want it to change the price , to what it is in the products table how do i do this

thx pat i'll try these out

i have tried evrything , it is not a form , wen i click new query the msg box comes up , also in the northwind db wen i click on design for a query it comes up again , i have scanned , reinstalled, detect and repaired and it still aint workin any other ideas

hi there wen i ever i try to make a query in mas access xp it comes up with a error message "there is'nt enough memory to perform this operation..." ive got 192mb of ram so it is enuff and i have closed proghrams not in use but still aint workin im running win xp pro helppppppppp i know i...

the thing is , is that i havent craeted no queries

wen i ever i try to amke a query it comes up with a error message "there is'nt enough memory to perform this operation..." ive got 192mb of ram so it is enuff and i have closed proghrams not in use but still aint workin helppppppppp:(

hi there im still havin trouble with the equation , on on wot field do i put this equation

could you elaborate what is the equation that i will have to put in the query

stock control query- can anyone help?????? hi there im a little stuck on how to make a query, wot i want to do is that , on my order form when the add order button is pressed, i want the quantity of the item to decrease by the quantity bought from the products table, how do i make a query for...