CSV Importing

The solution for importing a CSV file is to link to it instead of importing it. Linking to it, all the fields are correctly formatted and populated. One problem to watch out for; commas in the data. So I am turning to the semicolon as the answer. I am looking for the web developer to output the csv delimited by semicolons. If that is done there is a solution to the errors and format problems of importing a csv file. Once it is linked, I will then do the updates of the records. The only other step is to establish a set path for the location of the csv file.

Posted in Access 2007 problems/solutions, Uncategorized | Tagged | Leave a comment

Importing CSV files

Importing files can be tricky in MS Access. The application tries to set the property for each field and even with preset values you can still get data imported incorrectly. I don’t have a complete solution for this problem just yet but keep checking our posts and you will see one as soon as I have worked it out.

Posted in Access 2007 problems/solutions, Uncategorized | Tagged , | Leave a comment

Parking Lots

Central Parking System needs a database application to manager the paperwork and finances for the parking lots they operate in the City of Virginia Beach.

Posted in Access 2007 problems/solutions, Uncategorized | Tagged , , , , , | Leave a comment

Nuclear Power plants

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.

Posted in Access 2007 problems/solutions, Uncategorized | Leave a comment

Nuclear Power plants

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.

Posted in Access 2007 problems/solutions, Uncategorized | Leave a comment

File Maker to MySQL

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.

Posted in Access 2007 problems/solutions, Uncategorized | Leave a comment

Discovery

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.

Posted in Uncategorized | Leave a comment

What my customers enjoy

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.

Posted in Uncategorized | Leave a comment

Closing all open forms except certain forms

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

Posted in Uncategorized | Leave a comment

Data Comparison/Change made easy?

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!!!!!!!!!

 

data form comparison

Posted in Uncategorized | Leave a comment