Search results

Cheers man, working the way I wanted to now. All I need is spellcheck for Access and i will be doing great :)

Would u believe i am only getting back to this now. Been quite busy in work. Thanks for the updated file but there is now and error when I click on the drop down box for the Invocie number in the Add Payment sheet. It is saying that the record source is not correct. "the record source...

Yes there are just 2 new text boxes that i have created. There is a query that has the amount paid to date which is called "Payments Per Invoice" How can I get this info to fill a text box when another drop down box selects the invoice number. I though I had it there working for a while...

Thats great , thanks. but could i trouble you for one more question on it. I now also want to add another 2 boxes "LefttoPay" and "total_paid" I will then do a calucation on these to to show the amount owed. I have a seprate querys that does the calucation for total paid already "Payments...

My Invoice does not have an Payment field. But my payment has an Invocie one. I have attached my DB as its hard to explain. I am using the customer query "CustomerQuery 2" , that has all the information I want to use in this page. So.... in the Form "Add Payment" I want the "Customer Name"...

Hey all, Just wondering how I can have a drop down box and once and option is selected it autofills other fields? Always best with an example of what I am looking for. . . I have 3 tables Customers Invoice Payment I have a payment form and use a drop down to select the Invoice...

Is there an easy way to add a table to the record source to a Form that is already created? In my example I have a form that uses all the info from the "Invoices" table. This table has the field "Customer ID" What I want to do is use the customer ID to get the customer name from the...

Yeah that was it. Have got it working now :) Cheers mate.

Yo! asdasdasda

Hey All , An easy one I am sure. I have a form "Invoice" with a sub form "Payments" I dont know how I did it but I made the entire form navigate by the sub form. ( this means when I click "next" for the next record it is scrolling through the Payments ID's.) Not ever Invocie has a...

brilliant stuff. I see know where i went wrong. Thanks again for the help.

I have uplodaed db3 to this form. This is a access 2003 version. If you open the form "PaymentsAdd" and try to add a new payment you will , hopefully, see the error. Thanks for this Roy

only got around to doing this now. Doing that does seem to give me the results I am looking for but I get an error when I try to save the record. "You cannot add or change a record because a related record is required in table 'invocie' but this is strange to me as I am not lookinig to...

Hey Again, Its a new question but am posting here so people can see the history. Now I need to create an add Payment form. In this form I have a drop down box for the Invoice numbers but as my invoice table does not have the customer names in it, just the Customer IDs , when I create the...

Thanks, that is just what I was looking for. Big thanks for that. I knew it was going to be easy to do I just needed to know where to begin. Roy

Cheers jzwp22, I have set up the DB as you have suggested but am still having the same problem. When I create a form for the Invoice table it will now only show the CustomerID, I want the form to show the Customer names and then autopopulate CustomerID so it can be saved as obviously the...

Hey All, New to access here and I have picked up most of the stuff myself but am having problems with 1 thing for the last 3 days. I am creating a basic system with 3 tables Customers, Invoices, Payments. I am creating a form that is to take in the details of a new Invoice. I am using the...