I have an invoice form (based on an "invoices" table) where I can select from a list of completed jobs from a "jobs" table. The "jobs" table has a check box "job invoiced?" that I would like to set to "yes" when the "print invoice" event happens.
Hi,
I have a form-subform-subform situation. The sub-subform has a command button to hide it when it is not needed. When I hide and then re-show it, the sub-subform record indicators (or navigation buttons as they are called) do not show that there are any records in the recordset. The records...
I am wondering how (or where) Access links the parent/child fields in form/subforms. I would like to re-direct a subform record to be related to a different form record.
Is this possible?
I have a problem with a form. When I open the form, the record selectors show '1 of 1' records. There are several records in the table, but only after I click one of the sort buttons does it say '1 of 235' records. I originally had it working otherwise.
I am still learning Access. Addictive it is. I want to create auto-incrementing estimate and invoice numbers so that the customer does not know how many others I am making.
My thought was to use his ID number (188 for example) as a prefix like this:
188-0001 would be the first invoice for that...
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.