Recent content by Jonny45wakey

Hi I have a textbox on a form called OEEMTDMTand it contains a percentage value eg 91.6% I'd like the texbox backcolour to change to Green if >=92% or red if <92% but both conditional formatting tool and vba conditional formatting not working. The textbox on the form has its backcolour set to...

Hi not sure if this is achievable but here goes in the hope someone can help :) I have a label "label1704" on a form "frmDayshift" which is hidden on the form load event. On the form is a combobox "combo123" which is loaded with drop down values, when "NoProd" is selected i want the label to...

All I have sorted this through trial and error, on the hidden form is a textbox "txttime" with bounds to =Now() and timer interval set to 60 seconds. When the On Timer event fires the following code opens the second form (which is like a popup form) Private Sub Form_Timer() Me.Refresh If...

Hi I would like the on-timer event of a hidden form to trigger DoCmd.OpenForm "formnamehere" every hour using the computer time, essentially if time (minutes) = 00 then run the docmd How would this be formatted in VBA please? Thanks Jonny

arnelgp, your solution worked perfectly, thankyou for solving this for me, much appreciated :) REgards Jonny

Hi I have a form "frmDayshift" which has field [shiftdate], this form has a cmd button when clicked i want it to open a second form "frmdayshiftprintcheck" to same record date as form 1 [shiftdate], form 2 date field = [checkdate] ive tried vba such as:- DoCmd.OpenForm...

Hi Thanks for this, much appreciated. The form "frmMain" with the CmdButton "cmdPrintCheck" remains open once the form "frmDayshiftPrintChecks" has opened, how would you close this form please? Thanks JOnny

Hi I have a form "frmDayshift" with a cmd button (Command28) and on the on click event it opens a popup form "frmDayshiftprintchecks" and looks for a matching record by date. This works fine if there is a matching record but if there isnt, I'd like a message box to notify the user and then...

Exactly June7, aggregation of SumOfActHrs by Job_No and TransDate Thanks Jonny

Hi All I'm hoping someone with a better brain than mine can help me out please? I have a query called qryESH which has the following fields:- [Job_No] - Job Number [OpStart] - Operations start DTG [OpStop] - Operations stop DTG [SumOfActHrs] - Total Hrs between [OpStart] & [OpStop]...

Hi I have a requirement to send a report by email only once daily, this is triggered by the Form Event Timer. I am using the following code which works and sends the report by email after 9am but it keeps sending it every time the form requeries, is there a way to say if todays date is already...

Thanks Arnelgp Unfortunately i cant open the query as it says event is blocked by disabled mode? Perfect Arnelgp, works like a charm, many thanks for your support, much appreciated :) Jonny

No problem sir, DB uploaded. The two queries in question are qryOpStartBooked and qryOpStoppedBooked. As you know i would like a query which shows 1 line for Job No 79019 for the guillotine workcentre start and stop time and actual Hrs between start and stop (ActHrs...

Thanks Arnelgp I nearly got there but it's not quite right, hoping you can point me in the right direction please? I have the below data in a query when capturing the OpStart Date and time for the MTL workcentre I have the same data for the OpStop date and time for the MTL workcentre What...

Hi I'm wondering if someone could help me out with the following please? I have 2 x queries, qryOpStartBooked and qryOpStopBooked (see images below) What i would like to do is generate a query structured as follows:- Transaction ID / Job_No / Emp_ID / Trans_Date / Time / Workcentre /...