Search results

Gents thanks a lot works perfectly. I had a few completion times missing also. Thanks BOB and Mahmood

Hi Bob What type of file do you need? this forum wont accept it as XLSX

HI Bob Attached seems to work ok to a point then throws up weird numbers

HI Bob Thanks for your efforts however its close but gets some weird results in amongst good ones -1028109 this comes up a lot? you get like ten good results then this random bad one every now and then

Put that in the critrea field ?

Hey Bob they are all date/time Start date = dd/mm/yyyy Start time = h:nn:ss AM/PM Finish date = dd/mm/yyyy Finish time = h:nn:ss AM/PM The export of the table is attached Im after a query Bob to show total time difference in hours between the Start data and time and finish date and time...

Hi I have kind of made a rod for my own back here with my data base in the table I have 4 fields Start date Start time Finish date Finish time I want to find out using a query how many hours there are between the Start date and time and Finish date and time. Simple enough id imagine with...

I donrstand why every thing is based around ChkBoxship its not just if that box is checked I want only one check box to be allowed to be ticked at any one time on that whole sheet not just if ChkBoxship is ticked Private Sub subUnCheckOtherRecords(ByVal pk As Variant) Dim rs As...

I can build a query and see the data I want but ill be dammed if I can show it on graph

I cant get it to work I have 16 fields all I want to do is count the rows that say yes in each field and make a graph off it in positives not negatives

Cant get it to work arnel heres my code for each box how do I add to that to make it uncheck all others if check this box and ill copy that to all other 16 functions Private Sub Chklayup_Click() If ChkLayup Then If Trim(Me.txtLayUpCRS & "") <> "" And Trim(Me.txtLayUpactual) <> "" Then...

How do I do it ? I cant get Arnels Working

Hi My chk boxes are already named Chk with a caps does that matter?

HI I have 16 check boxes on this form / record and I only want to be able to click one of them at a time. if one is selected and I click another one id like it to cancel the other chk box and select the one I click on I have attached photo of the form Thanks Dan

HI Throws an error on this part What do I put in [ID] If ![ID] <> pk And !ChkBoxship = True Then

Thanks got it counting the fields but in negative any way to flip that when I make it a graph as I actually have positive parts not negative?

I have 15 different fields I want to count each field one field is called [Part In Lay Up] where do I put it in criteria? it says invalid syntax

Guys im having a moment here I have a query which looks at various parts in production areas I have a check box that's returning yes there is a part ther or no there isn't all I want to do is count the yes ! surely im missing something here PLease help Dan

Hi thanks Sorry im still learning where do I put this new code? also do I have to add Call subUnCheckOtherRecords(Me.txtID) to each of the onclick boxes on the sheet? Private Sub subUnCheckOtherRecords(Byval pk As Variant) Dim rs As Dao.RecordSet Set rs = Me.RecordsetClone With rs...

Hi Yes I do this one is primary key and autonumber unique to each record TxtID Dan