Recent content by mmahmod

Gentelmen in the attached file i create table to record the receipt booklet every booklet has a range ex :booklet 2 from 1051 to 1100 and i create another table for recieving cash i chose first the booklet then i write the receipt here is the issue when i write the receipt ,i want a code to...

the code of apply didn't work with me and there is an error msg and also how i finalize the 3 condition of payment as i explain in the last post of me i attached the file after writing the code in it kindly your support

Dear Beetle thanks for you helpful notes let me explain some pionts the table of invoices in fact i get all the invoices from application from work , its for piont of sales called SFO , so i get the invoices export from it and paste im my table in access and thats way i design the table...

yes thats completly right i want append three field to append in transcation sub form : 1- receipt id from mani form to receipt id in transaction table 2- invioce no from list box to invoice no in transaction table 3-the remaining field from list box to paid field in transaction table then...

sorry i wasn't activate the multiselect in list box :rolleyes: and no 2 & 4 are solved still no 3 to append the selected invioces to the transaction table when i hit the command button "Apply" thanks

thanks Beetle 1- its is worked perfect 2- always get zero , i don't know why 3- i need it as you see in attachment to update junction table "transaction" after the user select the invoices then he click on apply to go to junction table 4- i don't know how to chose multi record from the list ...

Dear All i have a list box based on query for invoice no & invoice amount how can i do the following 1- sum all the values of the list box (sum of invoices amount) in unbound text field 2- sum the selected invoices amount (if i select two or more invoices from the list) in unbound text field...

Dear Gents I have a main form for payment and sub form for invoices and the relationship is many to many I would like in to chose the invoices from the combo box in the sub form based on condition If the remaining amount of the invoice is less than the total payment , then accepted and updated...

Dear Gents i have build a file to track the payment with the invoices for the sales rep so i made the relationship is many to many because i have three condition: 1- one payment to one invoice 2-one payment to multiply invoices 3-partaile payment to one invoice all my problem in the form that...