Creating database

[Fred's]

Hi All,
I have a table that have the following field names

ID
hours
Truck
Seal
Comments

What is the simplest way to create a form where I can add data and at
the same time have a form where I can
look for data history.

Each day, the data on the form needs to be changed to new data, but we
need to keep the old data which was entered
previously.

Also, the form must have a check box in the details section with a YES/
NO data field that will let me know which
Truck will be received for the day.

 

[John W. Vinson]

Hi All,
I have a table that have the following field names

ID
hours
Truck
Seal
Comments

What is the simplest way to create a form where I can add data and at
the same time have a form where I can
look for data history.

Each day, the data on the form needs to be changed to new data, but we
need to keep the old data which was entered
previously.

Also, the form must have a check box in the details section with a YES/
NO data field that will let me know which
Truck will be received for the day.

Sounds like you need two tables, not one. You have trucks; for each truck, you
have day to day data... right?

Trucks
TruckID
<identifying information about the truck, such as VIN or your company truck
ID>

TruckHours
HoursID <Primary Key, Autonumber>
TruckID <link to Trucks>
RecordDate Date/Time <date information is collected; don't call it Date)
Hours
Seal
Comments

You'ld use a Form based on Trucks, with a subform based on TruckHours to enter
the data; select the truck for which you're entering data on the mainform, and
add a new record to TruckHours (and view existing records) on the subform.

John W. Vinson [MVP]

 

[Fred's]

Sounds like you need two tables, not one. You have trucks; for each truck,you
have day to day data... right?

Trucks
  TruckID
  <identifying information about the truck, such as VIN or your company truck
ID>

TruckHours
  HoursID <Primary Key, Autonumber>
  TruckID <link to Trucks>
  RecordDate Date/Time <date information is collected; don't call it Date)
  Hours
  Seal
  Comments

You'ld use a Form based on Trucks, with a subform based on TruckHours to enter
the data; select the truck for which you're entering data on the mainform,and
add a new record to TruckHours (and view existing records) on the subform.

             John W. Vinson [MVP]- Hide quoted text -

- Show quoted text -

Thanks, but the truck name is like i.e. OOLU5454556 and this name is
always changing. I don't think I can do this based on a truck
table....

 

[John W. Vinson]

Thanks, but the truck name is like i.e. OOLU5454556 and this name is
always changing. I don't think I can do this based on a truck
table....

Well, I was guessing in the dark about your business rules, and clearly
guessed wrong!

You're tracking history over time. What is the common factor between
measurements? Don't you at least need the date of the measurement?

Perhaps you could explain a bit what information you're collecting and how you
intend to use it.

John W. Vinson [MVP]

 

[Fred's]

Well, I was guessing in the dark about your business rules, and clearly
guessed wrong!

You're tracking history over time. What is the common factor between
measurements? Don't you at least need the date of the measurement?

Perhaps you could explain a bit what information you're collecting and howyou
intend to use it.

             John W. Vinson [MVP]

Each day, our fowarders are sending emails with truck (containers
numbers), time, seal numbe, qty, and comments and the day that the
delivery will be made. Then, we are entering into a form all these
informations. The thing is that one person enter day to day
information on a form, and others need to update the information by
clicking a Yes/No Field which Yes=received and No=Not received on an
access form with data from the previous days.

If you need further information, let mek know,

Thanking you in advance for your help!

 

[roccogrand]

A Yes/No box on the form requires that you put Yes/No field in your source
table.
You can see how to use Yes/No boxes by looking at the Products form in the
Northwind database. And if I am reading your messages right, Northwind may
be a good database for you to start your application because your
"forwarders" field seems like Northwind's "Shippers" field or possibly the
"Suppliers" field.

HTN

LDN

 

[Fred's]

A Yes/No box on the form requires that you put Yes/No field in your source
table.  
You can see how to use Yes/No boxes by looking at the Products form in the
Northwind database.  And if I am reading your messages right, Northwind may
be a good database for you to start your application because your
"forwarders" field seems like Northwind's "Shippers" field or possibly the
"Suppliers" field.  

HTN

LDN








- Show quoted text -

Where can I download this database?

 

[John W. Vinson]

Each day, our fowarders are sending emails with truck (containers
numbers), time, seal numbe, qty, and comments and the day that the
delivery will be made. Then, we are entering into a form all these
informations. The thing is that one person enter day to day
information on a form, and others need to update the information by
clicking a Yes/No Field which Yes=received and No=Not received on an
access form with data from the previous days.

Well, unless you need other information - the truck ID? nature of the load?
etc. then I almost wonder if Access is needed; you could do this in Excel
also.

If you're wanting to do it in Access then you'll want at least a couple more
fields:

ID - Autonumber, primary key
hours - if this means when the delivery is scheduled, I'd use a Date/Time
field and store both the date and time of delivery
Truck - Text, the truck ID
Seal - Text, I presume - the seal number
Comments - Memo probably unless all comments are <255 characters
Received - yes/no

or perhaps, WhenReceived, date/time in which you could enter the date and time
that the shipment was in fact received.

John W. Vinson [MVP]

 

[roccogrand]

Depending on how you installed Access on your computer, it should have been
installed automatically. Use Windows Explorer to find "Northwind.mdb". It
should be in the OFFICE11\SAMPLES directory. Then copy the file to
MyDocuments so that you can make changes and not corrupt the original version.

If you didn't install it, Northwind can be downloaded from the Microsoft
website. Make sure that you download the .mdb version as there are also
versions for .adp and .msi (for SQL Server).

There are also other sample databases at:
http://office.microsoft.com/en-us/templates/CT101426031033.aspx for Access
2003.

and
http://office.microsoft.com/en-us/templates/CT101428241033.aspx
for Access 2007.

Northwind for Access 2007 is at:
http://office.microsoft.com/en-us/templates/CT101428651033.aspx

Be aware that the naming convention used in Northwind is not recommended by
database experts. The functionality in Northwind however is very informative.

LDN