Recent content by Chris Howarth

I have three tables, one for employee names, one for test methods, and one showing which employees have been trained on which test method. I would like a query to show all employees and all test methods (even where there has been no entry). The only way I've found to do this is to create one...

I have two related tables, tmain and a look up table for AccidentCauses. I can show all records for all accident causes (including those with no accidents) with the following SQL:- SELECT tAccidentCauses.AccidentCause, Count(tMain.IncidentID) AS CountOfIncidentID FROM tAccidentCauses LEFT JOIN...

Excellent, thanks very much Bob, I was wondering about how to show times in that way. Bit of a shame Access doesn't seem to 'natively' support the [hh]:mm format of Excel- very useful for times in excess of 24 hours.

Heh, got it Only took two days... I had to add a copy of the tSamples table to the query- this is the SQL view:- SELECT tReactors.BatchNo, tSamples!sDate+tSamples!sTime AS Start, tSamples_1!sDate+tSamples_1!sTime AS [End], ([End]-[Start])*24 AS BatchLength FROM (tReactors LEFT JOIN tSamples AS...

Sorry, I don't think I made myself clear enough in the first post. Both sets of date and time will be in the tSamples table, what I'm trying to do is subtract the date and time identified by the ReactionPoint 'Start Gas' from the ReactionPoint identified 'Batch End' from the same table.

Just wondered if this was possible or whether I need to adjust the set-up of my tables. I'm trying to work out the time taken for a chemical reaction to finish. I have a main table (tReactors) linked one-to-many by BatchID to a samples table (tSamples). The main table stores details of the...

Not sure if you can buy the individual Office components in their 'developer' versions, but here's a link to Office XP Developer.

Just looking for some advice on the 'best' way of using a lookup table. Is the accepted way to have an autonumber ID and store the numerical value in the main table, thus saving space, or just to have the unique entries in the lookup table and use the text entries directly? Using the former I...

Thanks, Rob, I'll give that a try on Monday. Strange, though, I've done a lot of programming with Excel VBA and yet, when it comes to Access, everything I've learnt seems to go out the window and I'm fumbling about again. Still, fun when you get something to work :D .

Great, thanks very much. I found I had to refresh the current record to catch any update in the report and ended up with the following code. Is this the usual way of doing it, or can you foresee any problems? Private Sub cmdPrintPreview_Click() On Error GoTo ErrTrap Dim frmCurrentForm As...

Apologies if this is a dumb question, I'm on my first database and I'm having problems with setting up my report. I've created my forms etc and I've placed a command button on one of the forms to show a formatted report. Is there a way to only show an 'individual' report for the currently...