Recent content by nish2009i

same thing happnes.. i meant to say that even when the forms are closed, and opened again, when flicking through bookings, if the user clicks on PAY for one of the paid bookings, the payment form opens for a booking (regardless of whether its already been paid or not) and the code still lets it...

hi all, i have a booking form which enables users to make a booking and when the Status becomes "completed" , PAY button becomes active which can be clicked in order to make a payment FOR THAT BOOKING only... the problem: the code behind the payment form is: Private Sub form_load()...

as far as i know i didnt really use that table for anything, and i have checked if iv used it for any queries. i am tryin to attache the file its under 700KB but still not working, its saying there is a problem in attaching... :confused:

hello, i had a PBtable in between Payments and Booking table and i did not need this table no more to i have deleted it and also deleted the previous relationships, however: now, when a booking is made, i still get the little plus sign in the table on the left and its looking for the PB table...

yaa.. i figured it out now and its working! thanks :)

yaa.. i figured it out anyway! thanks

how do i create one to one relationship in acccess 07 please? i have no choice but to do it because of other problems.. its not allowing me to create 1:1 for some reason...

Hi, i have designed a booking form.. when the user wants to make a new booking they can either choose from existing list of customers from a combo box or ADD NEW CUSTOMER using following button of which the code is: DoCmd.OpenForm "frmAddCustomer", acNormal, "", "", , acNormal DoCmd.GoToRecord...

Also, while filling in the payment details, i would like to keep the COMPLETE TRANSACTION button inactive and i have put the code in for that and it doesnt work.. this is the code Private Sub Form_current() If cboPaid = "Yes" Then cmdCompletePay.Enabled = True Else...

hi, thanks a lot for that its working!!!

Hi This is very basic but i cant get my head round it since iv not used access in ages! i have a booking form and a payment form. when the user clicks PAY button, i want the payment form opened with the Booking details they were viewing from the booking form. the Booking Id, cost and other...