Data Control, LLC

Now I will be creating a database for four nuclear power plants. The purpose will be tracking the testing and training of the plant operators. From this the company will also be able to assess what a crew would be capable of based on test results of individuals. This way they can combine individuals with respect to their strengths and weaknesses so as to have all crews meet certain standards.

Now I will be creating a database for four nuclear power plants. The purpose will be tracking the testing and training of the plant operators. From this the company will also be able to assess what a crew would be capable of based on test results of individuals. This way they can combine individuals with respect to their strengths and weaknesses so as to have all crews meet certain standards.

A new challenge is before us. Migrating a FileMaker Pro database on a Mac OSX machine to MySQL on a hosted server. So we can handle Mac and PC implementations.

I enjoy the discovery phase of a project; learning a new business, seeing how other people arrange and manage their business. No two businesses are the same. There lies the shortfall of software packages. They are not able to be tailored to suit each unique situation. Instead you have to adapt your organization to fit the Software. That is not a way to purchase software. Every company needs software tailored to how they do their business. It always is easier to adapt your custom software than it is to change the way people do their jobs.

I find that when developing a proposal, if I give the client a graphic display of their database as it would look to the user, that they are better equiped to help me design the database the way they want it the first time and not after many revisions.

I had a tough time accomplishing this one and my final solution isn’t elegant at all!

I wanted to close all currently open forms except the main menu.  And if the main menu wasn’t open, I wanted to open it at the end of the routine.

 I used the Forms collection to inspect all of the currently opened forms.  I compared the name of the form to two hard coded names that I didn’t want to close (one of which was the form calling this routine).

 But the challenge I encountered was that once a form was closed, the overall collection seems to have changed so that the next time the loop is iterated, a previous form in the collection was being skipped!

 My crappy solution was to simply run the entire routine 5 times which should capture all forms eventually.

I know there must be a better solution, but I simply don’t have the time for elegance on this project and my solution runs so darn quickly, the user will never know.

 Private Sub cmdContinue_Click()

     DoCmd.RunCommand acCmdSaveRecord

      Dim frm As Form

    Dim i As Integer

       For Each frm In Forms

        Debug.Print frm.Name

    Next

       Debug.Print

    Debug.Print “—————————————————————————————————————————————————”

    Debug.Print

    For i = 1 To 5

        Debug.Print “LOOP: ” & i

        Debug.Print

        For Each frm In Forms

            Debug.Print “   ” & frm.Name

            If frm.Name = “frm_MainMenu” Or frm.Name = “frmadm95Choose Case” Then  ‘don’t close the main menu

                Debug.Print “    – form not closed: ” & frm.Name

            Else

                Debug.Print “    – trying to close form: ” & frm.Name

                DoCmd.Close acForm, frm.Name

            End If

          Next

       Next

       If nz(Me!cboCase) = 0 Then

        MsgBox “You must choose a case.”

        Me!cboCase.SetFocus

    Else

           DoCmd.Close acForm, Me.Name

        DoCmd.OpenForm “frm_MainMenu”

    End If

End Sub

I do a weekly download from a .csv file (for my client).

They want to visually compare the orig data (in a form) to the new data.  Then they may or may not want to accept any data changes.

So I’m building them a data comparison form (pop up) to lie on top of the current (old) data.  I’m changing colors on the popup form to visually indicate which data has changed.  And I’m adding a function to the double click event of the controls so they may easily accept the changes.  Why a function?  so I won’t clutter the coded window and so I can handle the various currentdb.execute update statements all in one place.

But here’s what I’d like to know:  From the properties window of the popup form, how do I pass in the name of the control in the function in the double click event?  That sure would have saved me a lot of time!

Arrgghhhhhh!!!!!!!!!