An access newbee

[koendekruijf]

Hello all,

I would like to introduce myself. My name is Koen de Kruijf and I am a aviation spotter. For my database I'm using a microsoft access file.

I would like to change the database, but I've never designed one. I don't know if there are some people here who would like to have a look at the file and hopeful can help me by changing the data base.

The database can be downloaded here: http://www.airliners.be/pages/db/download.php

I have asked the guys of the website, but didn't got a reaction. I looks like the site is since 2006 never changed.

What I would like to change is the reports and a statistic page where I can see my statistics of the airlines I've recorded. Also the picture's filename have to been modified before I place them in the list. I only would like to select them by their current name.

I hope somebody can help me.

Kind regards,
An Access rookie
Koen

[June7]

I reviewed the project. It is a mix of macros and VBA coding so you will have to learn both if you want to modify and use. With rare exception, I use only VBA. It is an mdb file and design changes are possible (an mde could not be modified).

When I tried to run some of the Input/Output switchboard items, the macros errored, presumably because there is no data.

You really need to get some reference books, do some tutorials (book or on-line), maybe even take a class or two.

Do the edits you want and when encounter issue, post specific question. What information do you want that is not already provided by existing reports?

I have no idea what you mean by "Also the picture's filename have to been modified before I place them in the list. I only would like to select them by their current name."

I noticed that the Aircraft table has a field named #. Advise against using special characters, punctuation (underscore is exception), or spaces in any names. Also, reserved words should not be used as names. If you do any of these, must enclose in [] when referenced in code or expressions.

What does an 'aviation spotter' do?

[koendekruijf]

I reviewed the project. It is a mix of macros and VBA coding so you will have to learn both if you want to modify and use. With rare exception, I use only VBA. It is an mdb file and design changes are possible (an mde could not be modified).

When I tried to run some of the Input/Output switchboard items, the macros errored, presumably because there is no data.

You really need to get some reference books, do some tutorials (book or on-line), maybe even take a class or two.

Do the edits you want and when encounter issue, post specific question. What information do you want that is not already provided by existing reports?

I have no idea what you mean by "Also the picture's filename have to been modified before I place them in the list. I only would like to select them by their current name."

I noticed that the Aircraft table has a field named #. Advise against using special characters, punctuation (underscore is exception), or spaces in any names. Also, reserved words should not be used as names. If you do any of these, must enclose in [] when referenced in code or expressions.

What does an 'aviation spotter' do?

Hello June7,

Thank you for your quick response.

At first, a aviation spotter means that I try to make nice pictures of aircraft and store them with construction details (manufacture, type, registration) in my database. I am an aeronautical engineer, so my interests are aviation related.

I can conclude in your post, that the database is very complex. The options that I'm missing in this database is a button (report) where I can see all my seen/photographed aircraft, listed by airline and then by aircraft type:

Like:
KLM -> Boeing 737
PH-KZA
PH-KZG
-> Boeing 747
PH-KLI

British Airways -> Boeing 747
G-KDE
G-LDE

I can now request a fleet report, but then I see a list were the registrations are sorted on alphabetic order without Airline or Type, also if I have "seen" an aircraft two times (10-01-2010 and 19-05-2011) they are both listed, I'm not interested in the date. So I would like to see only one registration.

About the photo selection.
It is possible in this database to connect an aircraft to a picture of it. I have to mark the "photo in database" mark. But if I do this, I need to change the name of my photo to "PH-KZA (01).jpg" This is the registration and the liverycode (01) to it. If I make another picture of the PH-KZA, I can't show it in my database anymore. What I would like to have, is that I can give a specific file-location like: c:\aviation\picture.jpg
at the aircraft. So that when I made several pictures of it, I can view them all in my database.

I think I need to buy some books and go to follow some lessons before I understand what and how I can make those changes in my database.

Kind regards,
Koen de Kruijf

[June7]

Yes, forum postings is not appropriate venue to learn basics. Until you understand basics any instructions we try to provide will be gibberish to you. Modifying design developed by someone else is especially challenging.