Search results

  1. R

    Combo box values based on another field?

    How can I display the values of one combo box based on another? For instance, I have a Hospital Combo box and I want only the units for that hospital to appear in the Units Combo box. I have two tables (Hospital and Hospital Unit) which are linked by hospital Unit. Thanks!!
  2. R

    Entering Values in a ComboBox

    Is it possible to have a combo box that a user can enter new values in right from the form. These then should appear in the underlying table? Thanks much!!! [This message has been edited by RACHNA (edited 02-07-2000).]
  3. R

    DatePart Function

    I'm using the following code to compute Age based on Date of Birth. (i'm using 4 digit year) Private Sub DOB_AfterUpdate() Age.Value = DatePart("yyyy",[Now]) - DatePart("yyyy",[DOB]) End Sub I'm getting bad results and realize I need to use month and day in the calculation. Any ideas how...
  4. R

    Switchboard

    I have a switchboard which has actions for the database it resides in i.e open form, open report etc. How can I create a button on it to open another database? Thanks much!!
  5. R

    Value count

    I have some a combo box named status with the following values Status: Accepted Rejected Incomplete Deflected Wthdrawn In a report how can I show how can I show the number of times each value is chosen? i.e Show how many times "Accepted" is chosen? Thanks!!
  6. R

    Changing a field Value

    I have a combo box field on my form for Grade Level (1-5). I'm looking for a way to advance all students to the next grade. 4th Graders->5th Graders 3rd Graders->4th Graders 2nd Graders->3rd Graders 1st Graders-> 2nd Graders Any suggestions would be helpful
  7. R

    Date Add Function

    I'm trying to calculate a date field on a subform based on a date field on the parent form using the following expression in the control source of the subform's date field i'm trying to calculate: ( I want the field to be 10 days from the Admission Date)...
  8. R

    Tabbed Control

    I have a tab control on a form, in the detail section, with several pages. I also have a header and footer section. There is a command button to Print the current record, however, when I click this it only prints the header and detail section. I have tried cliking yes to the keep together...
  9. R

    Combo Box Record Source

    Can a Combo Box's Record Source include multiple tables and queries?
Top Bottom