Search results

  1. D

    ADDITIONAL RECORDS DO NOT APPEAR

    I have a few glitches that Im trying to iron out, some report related others tables I beleieve In the attached db the main form for entering data is BASIC essentially the process starts with new job followed by on scene left of form.. For some reason whilst the data seems to save in the table...
  2. D

    PARAMETER REQUIRED

    Good morning my db has a number of reports or should I sub reports, db attached in clicking this report a request for a parameter comes up.. Followed guides on the web to locate issue but failed any advice would be appreciated
  3. D

    Code Not Changing Report

    I have moved on amzingly thanks to the support and help from people in this forum, Im struggling with code behind my form. The idea is that data is entered through the basic form, then when form is clicked you can select the name for the report record. For some reason ven though I can select the...
  4. D

    REPORT DISPLAYING SINGLE VALUE

    Good morning I have uploaded DB in full it my first real stab at anything but wouldnt be anywhere near with out the amazing help here.. Well aware I perhaps need to review WIKI to help sort tables etc not the best reader though... My question is my report which is labelled A4CDM when displying...
  5. D

    JOINT FORM UPDATE

    Good afternoon I have two sets of tabbed blocks left and right of the screen My even log in the right screen is just a running update of actions to be enter as and when they occur being time, event , note then initials Two questions, I would like to have a copy of the event tab with event log...
  6. D

    ACTIVE USER INITIAL SELECT

    Good morning hope all are well and a good weekend had I have a running list that is simply a time stamp, note followed by the initals of the person entered at start.. For example Dave D or Chris D when entered as users would populate a query CD and DD or if only Dave D DD would only be...
  7. D

    REPORT LAYOUT

    Good afternoon my current report from headings works down the page is there a way that they can move acorss Currently Time HR O2 Then subsequent Time HR O2 Is it possible Time Time HR HR O2 O2
  8. D

    CLOCK AND TIMERS

    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...
  9. D

    COPY ON DOUBLE CLICK SUB TO SUB

    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...
  10. D

    TABLET OPERATION

    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
  11. D

    Code Query Based On Multiple Parameters

    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...
  12. D

    VBA TO REFER TO ANOTHER CELL

    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...
  13. D

    Calculation Or Table Setup

    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...
  14. D

    STILL CANT SUS THE COMBO TO LIST BOX

    Good afternoon I have been struggling a little with the list box being populated from combo selections. The below works well allowing me to select from a list of 50ish items then they subsequently add to the list box The lookup list is is in one table called medication, the lbdrugs list box...
  15. D

    COMBO VALUE TO LIST

    I have list box that I would like to populate from a text box Private Sub cbmedsearc_AfterUpdate() Med_Name.AddItem (cbmedsearc.Value) tried all sorts of differing routes but all fail
  16. D

    Solved SYNCHRONISED DATA BETWEEN FORMS

    Good morning Im building a DB with form access that I can run on PC tablet, I should also add appologies Im a newbie. The main form contains basic information but then should set the trend index for the other data For example the basic for has a button that opens second form called OBS1 whilst...
  17. D

    Select Query To Use From Combo

    Good morning I have db with many records,, using a form I have programmed the tb to enter data for a criteria which works well... Is there a way of using a combo to select a query already set,, for example I have 4 queries each setting 3 differing results can I use theese as a combo item
  18. D

    Me

    Hye all Im an old fella playing with access to sort between many records,, not a pro by any means
Top Bottom