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...

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...

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...

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...

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...

Please find attached a table in which I would like to count each field if the dates falls in the past and have the count as a total or individual in a popup to show what is out of date, and if the user requires to see any of the results how to create a form to show those results. Or should I...

Hi all, hope you can help. I have a continuous form show multiple records, fine, I have a text box behind all fields on the form and another hidden unbound text box in the form header, I have this in my oncurrent event of the form, Private Sub Form_Current() If Nz(Me.Unitid) <> "" Then...

Hi all, and thanks for looking any help appreciated. I have an unbound form with 2 option groups, one contains a category like MOT, TAX etc the other group contains the 12 months, so I can choose from the first group a category then choose a month, then I would like those choices to run a query...

Hi, I know there has been many threads written around cascading combo boxes, but I can't seem to figure out if any of them fit my problem. I have a continuous form. in the header I have 3 combo boxes based on 3 tables of single firlds, each one filters the form i.e location, category and status...

Hi everyone, hope this makes sense if not someone point me in the right direction please. I have a form for vehicle maintenance. I have 3 conditional formats to show red for out of inspection, yellow for those coming up for inspection and green for ok, that works fine. the form is in continuous...

Not sure which is the best wat to go here, I have one form amd two queries, the only difference between the two queries is a 6 weekly date and a 12 weekly date for inspecting vehicles. I have created a form based on the 6weekly query and all is fine, I use a combo box to filter all hgv's or all...

I have a main table which is autonumbered on unitid, I have another table which is linked via the unitid which holds items purchased for the main table, so the second table is a subform of the suppliers and will have multiple entries of the same unitid. What I would like to do is when an item is...

Hi guys and gals! I have a dilema that I have been looking at for days now and still can't see the wood for the trees. I have a databse that monitors vehicle maintenance, servicing schedules and stuff like that. My problem is we purchase items for the vehicles and I am trying to link the items...

Not sure if this is for the forms thread or tables, think I am in the right place I have 2 tables tblworkdone and tbltests, both have a date field and are both subforms in a tabbed form on the main form. When I enter a date into the tbltests subform I would like the date to automatically be...

Hi everyone, I have had a look at similar threads but not quite what I am looking for hopefully someone has come accross this before and can help. Heres the thing. I have designed a vehicle maintenance database, I have a query listing vehicle tests due between 2 dates from a form. This works...

Hi guys and gals lol, Newbie to the forum and world of access. I have searched the forum for a solution and found one that works in part, DoCmd.OpenForm "frmfleettruck", acNormal, , "[unitid]=" & Me.searchresults.Column(0) This takes me from a list box on a double click event which id fine but...