Results 1 to 5 of 5
  1. #1
    3 Star Lounger
    Join Date
    Sep 2002
    Posts
    210
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Auto Populate Field and Reports (2002 SP3)

    I need help with the following three items on the database that I have stored at Rapidshare at this link. (922kb zipped, 5080kb unzipped)

    1. I need the NPDES Check field (third row, middle on the Bldg Permit Form) to auto populate when ANY of the following fields are chosen (they're towards the bottom of the form):

    Electrical
    Mechanical
    Plumbing
    SFD - Detached
    SFD - Attached
    Custome Residence
    Trace Development
    Multi-Fam (2)
    Multi-Fam (3-4)
    Multi-Fam (5+)
    Commercial
    Industrial
    Institutional
    Grading
    Residential Add/Alteration
    Commercial Add/Alteration
    Pool/Spa
    Demolition
    Block Wall
    Temporary Power
    Roof/Reroof

    2. The NPDES field should be able to be checked separate of the categories.
    3. How do I run a report that is generated monthly showing total count and total valuation for each category?
    3a. A report by month for SMIPS fee, to include category?
    3b. A report for monthly Microfilm total, to include category?

    If anyone has any ideas, I would be most appreciative! Thanks.
    Pooja

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

    Re: Auto Populate Field and Reports (2002 SP3)

    I'm sorry, I'm not going to download a file of almost one megabyte. See <post#=401925>post 401925</post#> for instructions on how to reduce the size of the database so that the zip file can be attached to a post.

  3. #3
    3 Star Lounger
    Join Date
    Sep 2002
    Posts
    210
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Auto Populate Field and Reports (2002 SP3)

    After doing everything suggested in the post above, I still could not reduce the file size to below 100k in order to attach it here so I'm going to attempt this with screenshots if anyone can help. The attachment contains the screenshot of the Bldg Permit Form. If anyone has any ideas on the answers to my questions above, I'd be most appreciative!

    Thanks.
    Pooja

  4. #4
    3 Star Lounger
    Join Date
    Sep 2002
    Posts
    210
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Auto Populate Field and Reports (2002 SP3)

    This attachment contains the screenshots of the tables.

    Thanks.
    Pooja

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

    Re: Auto Populate Field and Reports (2002 SP3)

    Create After Update events for each of the check boxes that should influence the SPDES check box, for example:

    Private Sub Electical_AfterUpdate()
    If Me.Electrical = True Then
    Me.SPDES = True
    End If
    End Sub

    Not enough info to answer the questions about reports, but I fear that the table structure is not ideal for what you want.

Posting Permissions

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