Search results

Another picky question that has me flummoxed. I can get my head around cascading combo boxes, but this one has got me. In the header of my form frmStaff i would like to place two combo boxes to filter the records shown. Records for this form come from a query Q_StaffNOTExcluded The first combo...

Result! I salute in your general direction.

Morning, One query that i need to run contains, amongst other things, two date fields. These are to do with training. First one is DateStarted and the other DateCompleted. I need to run a query to check all the training occurrences for null DateCompleted but only where there IS a value (any...

It does. I need to make it simple, for the varying users who will use the application. What i was thinking was a main page (switchboard - called frmMenu) with two combo boxes, one "cmbSelectLocation" and "cmbtype" which lookup values from their respective tables and then a command button to run...

Well, filtering on a subform is one, but only when searching for an entry (unique ID). The main work is form and subform. Let me explain... Form contains equipment (frmMainData) This contains Location and Type (1/2/3 1=Printer, 2=Cutter, 3=Binder) and also State (faulty/working/sold) Subform...

Result! Cheers

I have a standard form and subform setup, with quite a few boxes and organisaed layout. Trouble is, now i need to run different queries on the date (such a only show location A where equipment = x AND equipment is faulty) varying on types of equipment and locations. Don't have a problem...

Bit of a Query on a Query! I have a table (tblTraining) and a field called QualExpiry (short date field). This is date listing when a persons qualification requires renewal (expires). To plan ahead, i want to run a query listing all my staff members courses when the expiry date is only 4 months...

Sorry, i meant to say background colour of the whole sub-form. On balance, i may try just highlighting the cell. May be easier. Cheers

Evening again. Probably a quick one for the folks on here (and yes, have tried a search but getting conflicting and confusing returns?). In a subform (frmFaults) i need the background colour to show up red, when a text box date field (bound) [Date_returned) contains a null value. Any takers?

Doubt it will be used that far. Probably for another 18 months or so, plus entry input for the last 12 months historical data.

Pretty much spot on with ref to the checking rules. Didn't think about leap years though!

Queries the best way to go on this one then?

OK. Fair points. Different question, and I probably should have put this in the OP. I need to add up the total number of lost days due to equipment failure over the last 12 months. For example, i will have a range of dates as below: 1. 1/5/07 - 1/6/07 (days lost = 31) 2. 1/6/07 - 14/10/07...

Evening, Having a spot of bother with some date calculations. I have two date options (Date_down and Date_returned) for kit that goes away for repair. Not that it probably matters, but these dates are contained in a sub-form for each item of kit (one kit can have many faults). To keep a track...

The shifts do follow a pattern, but the pattern can be changed at 48 hours notice and other options need to be selectable (eg: Someone moving from an early shift to a late shift, or perhaps someone working a late shift now training or sick). Staff can only do one option in relation to shifts...

Sorry about that. I totally forgot about the multiple drivers when typing the first post. I do have the design, with relationships and controls but i am not sure how to post them on here in the best way so you can understand. How about this...

All drivers have to sign a useage record (for speeding tickets/accidents etc) but rather than check all 20-odd books to see who was driving it would be nice to do a check by driver of the vehicles they have driven and the dates. Does it complicate it if i muddy the water by adding the fact that...

Exporting would be done into Excel, preferably not CSV (sometimes needs to be emailed). Luckily all user (if multi-user) would be on a shared drive system (between offices)

Righty, The basic tables (drivers, routes etc poses no problem). I am a bit stuck with the shift pattern table (date/person). Any thoughts on the exporting/saving of the daily running?