Results 1 to 6 of 6
  1. #1
    New Lounger
    Join Date
    Jun 2003
    Location
    Camp Lejeune, North Carolina, USA
    Posts
    18
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Prevent unwanted exit (2000)

    (Subject edited by HansV - "Access" is not very informative)

    <img src=/S/help.gif border=0 alt=help width=23 height=15> The staff in our building for the last week have been closing out of our database by other methods other than the exit menu bar added to our switchboard. They accidently exit out Access all together by hitting the X button on the entire program, or to my dismay some have even control, alt, delete. Also have had quite a few power outages and all this combined is affecting the database.

    I solved the problem with the X button exit from the actual database by shutting it off, but cannot shut off the actual Access program X button (upper right hand corner).

    I was under the assumption that everything entered into Access is automatically saved, but I get warning after shutdowns and power outages that the database was exited/closed the "wrong way".

    I know I cannot stop power outages, but is there a better way that I can build into the system to prevent staff from exiting their way.

    We back up the database and luckily have something to fall back on, but it is frustrating to reenter data which is lost due to improper shutting down of program/database.

    Thank you

    Judy

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

    Re: Prevent unwanted exit (2000)

    The attached text file contains code for a module. You can use the SetCloseBox function to enable/disable the X close button of the Access application window.
    Attached Files Attached Files

  3. #3
    New Lounger
    Join Date
    Jun 2003
    Location
    Camp Lejeune, North Carolina, USA
    Posts
    18
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Calculated totals from Subform do not transfer

    Out office database has a table and subform that track outcome study scores. On the form I added a calculation that would total a grand total for all groups of individual tests. This calculation is done automatically. However the actual individual scores are input manually and appear on the outcome study table. How do I get the grand total from the subform to go automatically into the table which is used for queries.
    =[OQ452SDPreTest]+[OQ45IRPreTest]+[OQ45SRPreTest] this is the code placed in the properties box for the subform grandtotal.
    Thank you <img src=/S/brickwall.gif border=0 alt=brickwall width=25 height=15>

  4. #4
    Plutonium Lounger
    Join Date
    Dec 2000
    Location
    Sacramento, California, USA
    Posts
    16,775
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Calculated totals from Subform do not transfer

    Normally, you don't store calculated values in a table because there is no way to insure that they are up to date. In a query, you can use the same kind of calculated expression you do in the subform, so there really is no need to store the total.
    Charlotte

  5. #5
    New Lounger
    Join Date
    Jun 2003
    Location
    Camp Lejeune, North Carolina, USA
    Posts
    18
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Calculated totals from Subform do not transfer

    The grand total on the table should never change/update, because there is an entry for each record and date of visit.

    So what you are saying is to include all the fields on a particular test (example: part 1 total, part 2 total, and part 3 total and then have it total that in the query?)

    <img src=/S/confused3.gif border=0 alt=confused3 width=45 height=45>

  6. #6
    Plutonium Lounger
    Join Date
    Dec 2000
    Location
    Sacramento, California, USA
    Posts
    16,775
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Calculated totals from Subform do not transfer

    Now you're confusing me. You have the general idea, but sinceI haven't a clue about your table structure, I can't be more specific. I don't know what you're actually wanting to total, but it sounds like a total of multiple records, and I don't know what the relationship is between the table behind the parent form and the table behind the subform. You didn't actually specific which table you wanted to store the total in, but I'm assuming it was the one behind the parent form. It would make no sense to store it in the table behind the subform. <img src=/S/hmmn.gif border=0 alt=hmmn width=15 height=15> I just had a thought. Are you by any chance using a flat table with a field for each test?
    Charlotte

Posting Permissions

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