Software Design Notes

Design elements for the database application program

 

 

First Database: Contacts database ID: First Name: Last Name: Address: Phone Number: Worker Code:

Second Database: Sign In Database: ID: Date: Time In: Time Out: Area Worked: Worker Code:  Hours Worked:

Third Database: Donations Database: ID: Date: Amount Donated:

Worker Codes: 1:Volunteer 2:Community Service 3: College Student 4: Home Owner 5: Other

 

 

To Do List:

1. Iconize the project yellow logo
2. replace the logo on the first form with a picture of a house being built

 

 

VB Forms:

1. Intro
2. Contact Information
1. See all Activity
3. Donations
1. See all donations
4. Sign in
1. See all work performed

 

So 7 forms

 

All forms 10pt Tahoma Font

Form Size: 968 628

Background Color: Light Yellow

Start Pos. Center Screen

 

 

Tasks to perform:

1. I need to update related records
2. I would like to pull the ID from a form or questionnaire
3. I need original graphics for everything

 

 

 

 

 

 

 

 

 

**** Go back and make sure that the search for the ID # on the sign in page is correct or remove it!

 

 

A good idea may be to modify the contacts db to reflect a password!

 

 

 

 

 

You must include all the tables in the grid view for the contacts

Also you need to find some way to pull the user’s id # without having to enter in all the information

 

It is really messy right now, but I am in the functional stage – not the UI design phase.

 

Right now I need graphics….

 

Ummm it should take another 2-3 days at most (I hope).

 

Feel free to give any input.

 

When I have a fully functional draft, I will put it online for you guys.

 

Day2:

 

I need to make a (subprocedure?) for the work number.

This can’t be queried using a combo box and a text box leaves too much room for error

 

I am just going to have to hide the text box control to save time and use the combobox to insert the values into the text box.

 

 

*** Back/Forward buttons need to be formed and used********

 

 

Did you know that you have to have Access only by itself to save the changes.

This took an extra 4 hours for me to learn hahahahahah

 

I am using date/time pickers – don’t worry – I will add these things as I go along.

 

I need to install mouseovers for the images that are used as buttons if possible

 

 The next 2 big steps:

User ID interface and

Crystal Reports

 

I do need to go back and do all of the icons in the title bar again

 

 

 

Let me tell you something you should NEVER do – rewrite a VB file. I lost about 4 hours worth of work!

 

Oh well, I should have a working copy around tomorrow night or the day after.