Not sure if its a dynamic query i need or not. I need to track training for personnel. Each person belongs to a different department and each department has different training requirements. I have the personnel table, a training list table that list classes required, a table that has personnel...
I would like to have a combo box that populates with data, here is the code i have that don't work:
forms!frmdbxSortCriteria!cbxFindSort.rowsource = "qryAddcbxFindSort"
now the qry has several colums that i will set in the propertys to show 2 colums and bound to colum 1. I have a IF THEN that...
Hi, I have a popup form that ask do you want to print all departments or selected departments?
the user enters the beg dept (10) and then the end dept. (30)then they click on the preview button. Which should open a report with the the beg dept Thru the end dept displayed But i get the...
I have a popup dialog box that ask for a date, once the date is entered a form opens up with the date just entered in an unbound box(DrillDate). The form is based on a tbl which has the name, section, and times that a person was present for work. The form is a contiuous form, and the size varies...
Hi, I have a form that has 3 tabs on it, 2 of the tabs have subforms on them. Using Access 97
tab 1 is general bill to data: bill to number, name, address, phone ext.
tab 2 is a parent listing: it shows for a company all the subcompanys along with amount of sales and commissions.
tab 3 is a...