Recent content by Jonny45wakey

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

Hi I have a form with a cmd button "Command133" and when the "on-click" event fires for "Command133" i would like codes executed but struggling to nest each statement. Below is the current code for the "PaymentTerms" field, if this is blank the msgbox appears and then set focus to field, this...

Thanks CJ_London, it was a text value but I stepped through the form properties which drive the report and the "RCV" control source wasn't assigned to "RCV" it was blank and hence the report "RCV" field was always blank, its working now the control source is assigned correctly Hope that makes...

Hi All I have a report "rptInvoice" that has an If statement within the detail section of the report which is in the "on-format" event; however its not working correctly and i dont know why? In essence, when the report loads it should have either a "YES" or "NO" in the field "RCV", this is...

Thanks arnelgp I have noticed with the original code that after clicking the cmd box to set the chkbox filters its deleting entries from the Division field in the recordsource, i cant seem to figure out why? Any thoughts welcomed please. Jonny

Fully understood arnelgp :) If i utilised listbox for the fiscal year, how would i amend the cmd button code to reflect this whilst keeping the checkboxes for the divisions as these arent likely to change? Thanks Jonny

arnelgp Just wondering what could cause this error please when clicking the cmd button? On Debug it displays the following in Code window Thanks Jonny

arnelgp, your code was plug and play, thanks very much :) I know you helped me earlier with this post and I'm really grateful for your support and expertise Kindest Regards Jonny

Hi Hoping someone can assist me please? I've been trying to filter a continuous form using checkboxes and cmd button and am nearly there apart from the filters not filtering data properly. On my form i have 9 x checkboxes as shown, these should filter the query field [FILTERYEAR] according to...