how do i write , or atlease start writing a "pseudo-code" for this databaseQUOTE]
Hi ya Rookie!
Well see in as u won't take the hint and right u questions in prop UK I thought I would give you a taste of your own medicine! This mght elp you see how diff it is for other ppl to read your posts!
B4 you + any code to your db i recommended u make a few alterations. I have looked at your db and made the following obs.
tblLogTimes >>>> Good!
Car_Details >>>> Bad!
Fuel_Details >>> Bad!
has flds named "Date" & "Time" VERY VERY BAD..................
so do Service
tbl nmaes shd start "tbl" the Xtra mean -, word "details"
qrys are nicly named
frms nms ok expt 4 the Xtra mean -, word "details"
mods
have
Option Compare Database
Option Explicit
which is Xilent
Vgood most ppl miss this an leav out the DAO
Dim db As DAO.Database
IsLoaded this is an old way of doin it theres a new way, i dunt u sit (new way) me self though cause i see it somewhere an 4got to save lnk
tbl accidents as a fld names like "Police Report" spaces are not good practice
maybe use 1 fld for both date an time?
car details tbl has fld Reg no 50 chr lng really? that would be a BIG CAR
no relationships setup?
Employee tbl Date-Of-Birth ge rid of - so DateOfBirth
same again fld names wiv spaces not good!
tblLogTimes nice!
frmCar_Details
form mod only have Option Compare need Option Explicit
Database "Not Good"
cmd btn not named Correctly
Command21_Click() shd be named sumut like
cmdSearch
or if you are migrating to VB
btnSearch
recordsouce 4 frm "frmEmployee_Details" is incorrect
recordsouce 4 frm "frmFuel_Details" is incorrect
no recs in db so tis ard to see whats hapnin man! (You ready bin told this!) I'm avin to rept others elp not Gd.....
And if you can read that load of crap you are a better man than me! So do I take it that you will take the hint? Or will you still insist on doing things your own way?