Search results

Good morning my current form has a live clock on it which uses the timer on form load.. There are then a series of tabbed pages, one of which I would like to show a counter that counts to 30 at 2 beats per second then holds for 4 seconds then recounts.. yes a cpr timer It would be really good...

t Thanks vey much works a treat,, if i chose to covert to a button operation would it be as simple as copy the code to one click btn

WOW many thanks worked a treat, may I just ask another question although it may need another thread The news2 table calculates a total based on change of cell which works on entering value manually.. Using this approach the calculation does not take place unless I re enter the value manually

The main form is incident and patient information, observations and news are a 2nd action the db will eventually have a record set in the event of medical resus.. NEWS2 may or maynot be used depending on the situation hence why if a set of observations were carried out a doube click would only...

Uploaded next rev,,, still messy behind the scenes but will tidy up as I learn more thankyou,, to the right hand side in the tabbed area I have observations and News two both of which can have o2 values.. I would always take the observations first my question is can I set on a double click if I...

Excellent will have a read thankyou

My fear is that

Good afternoon, had some amazing help creating a db,,, my ntention is run on a tablet. Of course I forgot that tablets have a software keyboard, is there a way to set the app that when your typing in a box its not hidden by the keyboard, Or do I have to resize everything

Thanks all everything is running looking good

Sorry just to explain when using whole numbers the below functions Select Case TMP Case Is <= 35 TC = 3 Case Is <= 36 TC = 1 Case Is <= 38 TC = 0 Case Is <= 39 TC = 1 Case Is >= 40 TC = 2 Case Else TC = 0 End Select On trying to enter a...

yes agreed now I stood back and looked saw the error of my ways,, can you not use case when handling decimals eg 36.1

Sorry so the RR first question works a dream now I have played with SPo2 The value chages once then stops unsure if its my case woking or a glitch else where Private Sub SPO2_Scale_1_AfterUpdate() O21 = Me.SPO2_Scale_1 Select Case O21 Case Is < 96 O21C = 1 Case Is <= 93 O21C...

Yes agreed, its a lot harder the case works like a dream so many thanks folowing on from the first post I tryed to seach the net but found it a little bit of a mine field in working out the case and operators so did to replicate

Hmm so the first section with RR worked a dream im clearly not understanding the case as applying to next set didnt work Private Sub SPO2_Scale_1_AfterUpdate() O21 = Me.O21C Select Case O21 Case Is <= 91 O21C = 3 Case Is >= 92 O21C = 2 Case Is <= 93 O21C = 2...

Thankyou all good stuff will have a tinker

Im trying to calculate a value based on input to a field, the calculation in normal terms is the following <= 8 output is 3 =>9 but <= 11 output is 1 =>12 but <= 20 output is 0 =>21 but <=24 output is 2 >=25 output is 3 I have tried various combinations of the code below noe of which give a...

Good morning thank you for the responses, as you probally gathered this is a new world Im dabbling with. The information being entered firstly is a set of observations related to a patient which would be heart rate, oxygen pluse a number of others. These are being entered into a data sheet view...

Morning Im trying to use dbl click to copy a value to another form Private Sub Heart_Rate_DblClick(Cancel As Integer) Dim OV As String Dim HR As String OV = Me.O2.Value HR = Me.Heart_Rate.Value 'Me!Subform1.Form.RecordSource Me!NEWS2.Pulse = HR Pulse is located on a sub form called...

Good evening I have attached in total the DB Im playing/developing had some super guides on here previously, as a newbie struggling with a simple calculation which may be because Im approaching in the wrong way. Part of the patient assesment are GCS (Glasscow Comma) and News 2 are based on...

Thanks you are all amazing, building this for fun and a bit of education and so far learnt so much with all of your help The calcualtions are next they could be interesting