jsteph....THANK YOU THANK YOU THANK YOU for all your help. I did everything you just said. Now to calculate my AmountDue feilds is this where my query comes in?
build a simple Invoice table, then a query summing Total Invoices by client--maybe display that on a form, and have a field calculating the total of all payments for that client, the difference being his current balance
Ok..thank you so much for your input..this sounds like what I'm looking to...
Ok. Thank you. I took the ClientID out of the Payments table. Each client will only have one Parent. How do I create a way to determine how much each client owes for each class that they register for?
Can someone please help me with this database I am I trying to create. I am so confused I just dont know what to do. I have to create a database to manage the swimming courses that are offered and the students that are taking those classes. I have created a several tables. I am trying to figure...
If I have a child table that is related to a parent table by a parentid but I want to enter the parent info from either form and have it synchronize the changes from form to form what is the best way to go about this(if possible)....Meaning I want to be able to enter the child's parent info on...
Ok. I understand the code above but is it possible for that code to copy the info to another form. Maybe I am not explaining this clearly.
I have 2 forms. One which has the client(or child's) info. Name = Clients Then other form contain the child's parent info. Name = Parents. In the client...
I would like to clear the textboxes. I am very new to this so thank you so much for helping me. This code it to copy the data in one record's control to another control in that same record. Is it possible to copy this information to another form(table) that has an address,city, state,zip...
How do you write an IF statement for a checkbox?
I want to copy data from one control to another if the IsMinor checkbox is checked. I have the code working to do this once the command button is clicked but I want to put this same code in the AfterUpdate event of a checkbox named IsMinor...
I have client form that has fields for: address, city, state,zip
and a checkbox to indicate whether or not the client is a minor?
If the checkbox is checked I want to be able to copy the address, city, state and zip from the client table to the parent table as the billing address with fields...
I finally thought I'd set up a form that would allow me to 1) enter new records, and 2) jump to an existing record if I entered an existing Item Number (primary key). I tried it first using a simple test form with an ItemNumber field that is Auto-Numbered...I inserted a combo box that would...
Thanks for your response, BlackKnight.
A couple of things:
The combo box is bound...it is bound to the 'Item Number' field on the database.
The field's name (and the name of the combo box on the form) is actually, 'Item Number'...do I include the space in that name when referencing it, or do...
OK, I'm trying to find a way to get my form to move to the existing record in my database. The key I'm using is one I created called "Item Number" (not the default AutoNumber ID field). When someone types in (or selects) a value in the Item Number combo-box, I'd like for the form to...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.