Search results

  1. H

    I need Help with Case Statement

    Unsure how to write the code I do not know how to even start the code
  2. H

    I need Help with Case Statement

    I have a database that I track employees. I have a table that has their personal information – Name, address, ect. I have a table that stores their computer access information – Access A, Access B, date trained, training due date ect. I have created a form for the supervisor to nominate an...
  3. H

    Combo box based on other fields on form

    I have a table that list a set of numbers in one field, the organization in a field and the position title in a field. The numbers are specific to the organization and the position title. Number Org Position 89087 Company A Clerk 52145 Company A Mgr 32154 Company B...
  4. H

    Update form based on multiple tables

    My db has several tables tb1, tb2 tb3 tb4 ..... I have link tb1 to tb2 (tb1Id to tb2)and linked tb2 to tb3 and tb4 (tb2Id to tb3 and tb4) I have created a form with several field from tb1 and tb2 and a single field for tb3 and tb4. All of the fields except one for tb1 are use to make a decision...
  5. H

    Look up qry

    I created a qry to base an update record form to update employee information. However, I can not open it base on last name as that will populate all "smiths" Is there a way to add criteria to have only one parameter popup to populate both critera, LName and FName, for to fields? Basicly I want...
  6. H

    Close a Form w/ Cmd Button

    Thanks, that help alot. Sorry I did not reply sooner, I only work on this db about once a week.
  7. H

    Close a Form w/ Cmd Button

    I am building a database to track employees. I have a form to input the personal information and want to close this form and open a new form to input the employee's training information. I have a cmd button to open the Training form for the individual, however I can not make it close the...
  8. H

    Close form, open new form on current record

    I am building a database and I have a problem with the input forms. I have an input form for adding individuals to the db and have a button to close the form and open a new form to input training record information for the current record that does not work. How do I write the code to do this. Andy
Back
Top Bottom