Search results

Hi all, I have a dillema, I have 3 table, vehicles, drivers and the join table all works fine for data entry both sides and interogation both ways. However, becuase one drive can have more than one vehicle at different times, thus showing mutliple entries for a vehicle, I need to print a list of...

That table is backend for a form that is manulally updated, what I need is a many to many scenario so i what place has had what.

Hi all I have attached a table I created years ago, in my access green years. As you can see I have three main fields, 2 are locations from and to that location, and a date field, what I need and am finding it very difficul to get my head round it I need a todate and from date or a onhire date...

How do I finsih this thread as solved

Thanks for that I think I have cracked it I missunderstood the binding phrase its the crontrol source of the combo that sould be the id of the subform, I get it lol so cheers

I know this is a daft question but how does one do that, do I go to properties and then where or is at the wizard level i do that.

No i'm not using lookup fields. Ok I will give that a try thanks I will let you know the outcome. In the combo box in the subform do I need to store the result or just use it? What is the combo boxes source, the drivername or the whole driver table. I have created a combo box in the subform...

I must be missing something because when I create a form with the vehicle table as main and hire table as sub, when I add a driver from the hire table i am given a new driver id not the driver id in the driver table.

i have already created a link table and i have the id for the link table and have got the other 2 id fields in there too. when you say primary index, what do you mean, do you mean no duplicates. The id of the link table is autonumber, the other 2 are just number tpyes, and you mention a unique...

I created the join table and created the 2 fileds driverid and gave it a number type and the unitid and gave that a number field then joined them to the unit table and the driver table, what do you mean by look up fields?

I have a vehicle database. I have 3 tables set up which are populated from a previous database I inherited., in one table I have vehicles PK unitid, in the other I have drivers PK driverid, I have the third which is the joining table which is also populated, which has the Unit/drivers in, the...

This is what is behind the combo that selects a record. SELECT tblmain.Unit, tblmain.Location, tblmain.Category, tblmain.Status, tblmain.Year, tblmain.Make, tblmain.Model, tblmain.ChassisNo, tblmain.BodyType, tblmain.Tracker, qry_mainscreenFeed.datedif, qry_mainscreenFeed.NextInsp...

Hi thanks for your reply, but not sure how to integrate the 2. This is what is behind the filter button: Dim strWhere As String 'The criteria string. Dim lngLen As Long 'Length of the criteria string to append to. Const conJetDate =...

Hi everyone, I know this is in similar realms to cascading combos, but still can't see to get my head round it. I have a form based on a qry, I have 3 unbound combo boxes based on 3 tables, one for each, just lists supplying the combos, I have a filter button so that once anyone combination is...

Thanks, but I know I have a structure problem, thats what I need help on, I need this to be independant to the main database the only link back is the vehicle. So that this will run independantly. Rather like a car rental company or vehicle hire database without the costing.

Thanks, ok here goes, we are plant and transport company, with several vehicles large small etc, I have succesfully created the main database to track inspections , services, MOT, Tax, maintenance, not a problem. As part of this we need to track who is driving what and when, in the main vehicle...

I think I have the understanding of the tables I need to problem I have now id populating them. My orginal table had everything in it ie driverid, unitid, drivername, begindate and enddate, and there are many entries for drivers. so I need to strip out of that what I need for each new table.

Thanks lagbolt, are you suggesting I place the dates into another table? And yes jdraw I will take a look thanks

Hello, I have a table of drivers, driverid, unitid, drivername, begindate, and enddate.The unitid relates to a main table which have the vehicles, and the begin and end dates are when the driver had the vehicle and returned it. The reason I ask if this could be made bettewr is I have created a...

Hi Dan, when you double click are you going to opening a single form?