Results 1 to 4 of 4

Thread: using a check box to compile data...

  1. #1

    Thread Starter
    New Member
    Join Date
    Apr 2015
    Posts
    3

    using a check box to compile data...

    First off, I'm at work right now and don't have my files with me, I can get to them later.

    My program consist of essentially 2 frm, (minor and major) each one bound to a separate database table in access with the same name.

    Each time the operator of a welder rebuilds a torch (minor), they enter the torch number, torch on hours, welding hours, date of rebuild, a optional check box, initials and optional comments.

    After so many hours and minor rebuilds, the torches need to be over hauled (major)

    What I want the program to do is when a minor rebuild occurs and the operator decides the torch needs to be over hauled, they ✔ the check box, and the program adds up the on and welding hours since that torch was last over hauled and enters that sum into the major data table.

  2. #2
    PowerPoster
    Join Date
    Feb 2012
    Location
    West Virginia
    Posts
    13,278

    Re: using a check box to compile data...

    Sounds pretty simple, what are you having problems with?

  3. #3

    Thread Starter
    New Member
    Join Date
    Apr 2015
    Posts
    3

    Re: using a check box to compile data...

    here is my program.
    the database needs to be in C:\TorchLogger\Databases
    https://www.dropbox.com/s/7lsdj0onkf...ogger.zip?dl=0

    Now that im on a keyboard, ill try to explain more of what im trying to do, Im sure it can be done, Im just totally clueless on how to get it...
    Its been 5 years since ive dealt with VB in college, this is a side project im doing for work.

    So in this image, This shows all the data that has been entered using the minor form.

    https://www.dropbox.com/s/at7l6lrzvv...57.20.png?dl=0

    When the operator did a rebuild on torch X281, it was decided that it also needed to be overhauled, so they checked the Major rebuild check box.
    Since the last Major rebuild (overhaul) Torch X281 accumulated 37 Run hours and 76 On hours. This data also needs to be entered into the Overhaul database table. The hours can be added up manually by the operator and entered in the Overhaul form of the program, but what I would really like to accomplish is when the check box on the rebuild form is checked, the program looks for the last overhaul on that particular torch (in this case X281) and adds up the hours since the last overhaul.

    Im guessing I would have to have a query run in access for this to happen, but I want the program to run the query in the background and enter the total hours into the overhaul form/datatable automatically.

    Sorry if I seem confusing (I am quite confused honestly)

  4. #4

    Thread Starter
    New Member
    Join Date
    Apr 2015
    Posts
    3

    Re: using a check box to compile data...

    Bump

Posting Permissions

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



Click Here to Expand Forum to Full Width