Recent content by mrh

Hi Guys, Thanks for the suggestions etc. Have managed to sort the query - now works as I hoped! Just need to find a way of running a query at 10pm each night. I understand I can use the ontimer, but I'm not sure how to make it time specific. Many thanks Matthew

Many thanks It's a very simple structure:- Operator Text Time Date/Time Status Text Index Autonumber A sample of the data:- Operator Time Status Index Boris 13/10/2008 07:10:00 Clocked In 11 Boris 13/10/2008 06:49:45 Clocked In 1 Bert...

I agree! I've sorted all the time calculations - including rounding forwards and backwards and applied them to create the above tables. Wonder if it is worth me starting again, although that will then give headaches to collect the data..... I'll keep thinking! Many thanks Matthew

Hi, Following help from other members on here, I'm finally getting somewhere! I now have a table like this:- 20/10/2008 Boris Clocked In 07:15 20/10/2008 Boris Clocked Out 10:15 20/10/2008 Boris Clocked In 11:15 20/10/2008 Boris Clocked Out 16:30 20/10/2008...

Cheers Ken, I'll try and explain what I trying to do. I fear it is very simple really, but I'm making hard work of it! It's a simple record of if a machine is running, and what time it started - so we can calculate how many hours a week the machines are running for. I have a table [Machines]...

Thanks 1jet. I've played around and got.. Dim strSQL As String strSQL = " INSERT machinestatus " & _ " set machinestatus.machine = Forms!MachineStatus!machine " & _ " and machinestatus.time = Now() " & _ " and machinestatus.runstatus = "Idle" ; "...

Hi KenHigg, The form is based on a query, so, as a beginner, I don't think I can bind it to a table? Hopefully I'm wrong! Many thanks Matthew

Afraid not - the user is tweaks and changes the data before it is added to the new table. Thanks Matthew

Following the assistance given here http://www.access-programmers.co.uk/forums/showthread.php?p=764611 I thought I progress a bit! I have a form with 3 fields, read from several sources, and some manual text boxes. These fields are on a form called "Machine Status" and the 3 fields are...

That was great. Many thanks! All working now. Everyone's help much appreciated. About to post a new thread about using vba to add records! Here Matthew

Another complication! Sorry! The control I am looking to check to see if it is "Clocked In" or "Clocked Out" is actually on a subform called Status1. I've tried:- Private Sub SelectedOperator_AfterUpdate() Refresh If Me!Status1.Clockcard!CalcStatus = "Clocked-In" Then Me.ClockOut.Visible =...

OK. Now that's confused me. I understand the first bit "The code should be in the OnCurrent event". So I add the code as a procudure in the OnCurrent event parameter. "and called in the AfterUpdate event" How do I do this? Enter the same code as in the OnCurrent? Or can I link/reference...

Many thanks for the replies. I'll try them out later on and report back. Much appreciate the effort. Thanks Matthew

Morning all! Question from a novice I'm afraid. I have a simple form I am using for employees to "clock-in" and "clock-out" for their weekly timesheet. When they select their name, the form shows them if they are currently "clocked-in" or "clocked-out". If they are "clocked-in" I only want...