Results 1 to 3 of 3
  1. #1
    2 Star Lounger
    Join Date
    Sep 2002
    Location
    East Coast(USA)
    Posts
    109
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Subform/crosstab (Access 2000)

    Greetings,

    I have a field called NumOfApp in the main form and will be automatically field in, depending on how many applicants there are in the sub form. I had 3 records in the sub form and it was working fine, until I went to the table and deleted one record, compact and repaired it, but NumOf App still shows 3, where as in the sub form it shows 2 records (1of 2, 2 of 2). This is the code I had, please comment:

    Private Sub txtCount_Change()
    Forms![Applicant]![NumOfApp].Value = txtCount.Value
    End Sub

    2. I was trying to design a query based report to indicate the member of applicants whose case are denied each month and what % are denied within 10 business days and average # of days. How do I go about designing the crosstab query?

    Thanks,
    DD

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Subform/crosstab (Access 2000)

    About your first question:

    As far as I can see, deleting a record in the subform has no influence on NumOfApp. You set NumOfApp when the user changes the value of txtCount. (I don't know what txtCount is used for, but I would use the AfterUpdate event instead of the Change event to set NumOfApp.) Events such as Change (or AfterUpdate) only fire if the user changes the value interactively, not if the value is changed by Access or by code.

  3. #3
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Subform/crosstab (Access 2000)

    About the second question:'

    What do you want as row headers and what as column headers?

    It might actually be easier to let the report do the aggregating - that's what reports are good in. You could group the data by month and calculate the various numbers in the group header or footer.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •