a few of you on here have helped me greatly with my database build and hopefully you will be able to follow me a bit better.
first of all. sorry boblarson but you are going to kill me for this.
i think i need some vba. im re-designing my payment screen. it now has a continuous subform. previously i had a list box and on dbl click another form poped up and then you had options. now all those options are on the subform. apart from 1 because i dont know how to do it.
its courses. i have the ability to sell an amount of items in bulk called a course. when somebody redeems one of these items then obviously there is no payment due.
ive got the tables in place and the queries to update the courses table(qty remaining etc) but i dont know how to check if the customer has course items remaining for the item that has been chosen. i did this via DLookUp's ie if DLookup 1 >0 then bla bla bla.
i would like to do this now without the DLookup's as i think it is a clumsy way of doing it. and i would end up with hidden txt boxes all over the place.
i have uploaded my full database. the form that works is frmDepartures-Pricechange. the form i want to do this in is frmDeparturesPaymentScreen-ItemListSubform. i would like it on the check box i have put there. the check box is not in any table but it can be if neccessary.
the way i have my tables are in the uploaded image.
tblCourseItems.ItemsID is the redeemable Item.
the way it needs to look is
tblCourseItems.ItemsID - tblCourses.CourseID - tblClientCourse.ClientDetailsID then tblClientCourse.ItemsRemaining. if greater than 0 then run query to update(minus 1). else show message that the client does not have any course items remaining for this.
thanks for looking and i hope you all follow. if not any questions. just ask
first of all. sorry boblarson but you are going to kill me for this.
i think i need some vba. im re-designing my payment screen. it now has a continuous subform. previously i had a list box and on dbl click another form poped up and then you had options. now all those options are on the subform. apart from 1 because i dont know how to do it.
its courses. i have the ability to sell an amount of items in bulk called a course. when somebody redeems one of these items then obviously there is no payment due.
ive got the tables in place and the queries to update the courses table(qty remaining etc) but i dont know how to check if the customer has course items remaining for the item that has been chosen. i did this via DLookUp's ie if DLookup 1 >0 then bla bla bla.
i would like to do this now without the DLookup's as i think it is a clumsy way of doing it. and i would end up with hidden txt boxes all over the place.
i have uploaded my full database. the form that works is frmDepartures-Pricechange. the form i want to do this in is frmDeparturesPaymentScreen-ItemListSubform. i would like it on the check box i have put there. the check box is not in any table but it can be if neccessary.
the way i have my tables are in the uploaded image.
tblCourseItems.ItemsID is the redeemable Item.
the way it needs to look is
tblCourseItems.ItemsID - tblCourses.CourseID - tblClientCourse.ClientDetailsID then tblClientCourse.ItemsRemaining. if greater than 0 then run query to update(minus 1). else show message that the client does not have any course items remaining for this.
thanks for looking and i hope you all follow. if not any questions. just ask
