Search results

  1. D

    Loop stuck at the first record when execution of module ends...

    Hi friends, Got stuck with the first loop not moving ahead...The function is executing fine ..but oce it returns to the originat recordset loop startsat the first record again... plz help?? Dim db As DAO.Database Dim rs As DAO.Recordset Dim strtoid As String, strtnid As String 'strtoid =...
  2. D

    LoopWithout Do Error- Plz help

    Hi Friends, Got stuck up with Error LoopwithoutDo- But I do have the Do .... Also checked for misssing End If's again and again; they are all there.. Following is the code, had a working code with subloops which were working perfect, but then I tried to put those in Loop- so that the query...
  3. D

    Populating unbound controls on a single unbound form using VBA

    Dim db As Database Dim rs As DAO.Recordset Dim sqltbl As String If IsNull(Me.OpenArgs) = False Then sqltbl = ("Select TestName, TestValue FROM NonProfileTests WHERE TestOrderID ='" & Me.OpenArgs & "") Set db = CurrentDb Set rs = db.OpenRecordset(sqltbl) Set Me.Recordset = rs rs.Close Set db...
  4. D

    Carryforward - previous records as the basis for new records in a conUnsolved Problem

    High friends - Here I have a problem which I even find difficult to express in technical terms so I would write in simple words. I'm a newbie- doctor by profession so not very well versed in VBA. I have made an application to keep the records of pts ( P,BP, WT and medications prescribed) Each pt...
  5. D

    Hi!

    Hi every one -I have learnat a lot and hope to continue learning thru this forum, my best wishes for a good health to all. Dr Kesari
Back
Top Bottom