Search results

  1. J

    after update and values

    OK. I'll do. Thanks
  2. J

    after update and values

    Thanks I'll try.If i want values 110,115,120 How can i do this;
  3. J

    after update and values

    I have a combo box that i t takes values from a table.I put this code in the after update event. "Private Sub combo_box1_AfterUpdate() If Me.Combo_ box1.Value = 110 Then DoCmd.OpenForm "frmthromvolytika", acNormal, , , acFormAdd End If End Sub" The values are...
  4. J

    Run time error on keypress event

    Hello . I used thiw code on the KeyPress event KeyAscii = Asc(UCase(Chr$(KeyAscii))) I had no problem in Win 98.Now in Win Xp I got the message: "Run time error '5' Invalid procedure call or argument." Does anyone know how to solve this; Thanks
  5. J

    Automatic filling in a main form from a subform

    I have a main form “frmPatient”with the fields : PatientID, Name, Datein, DateOut,and DateDiff. I have a subform “subformUseExams” with the fields “PatientID’’ and “Categoryname”(combobox) In the afterupdate event of CategoryName I use this code: Private Sub CategoryName_AfterUpdate () If...
  6. J

    Afterupdate event and filter name

    Hello, I have a main form –frmpatients- and a subform-subformuseExams.In the subform I have a textbox –PatientID – and a combobox-Examname.I want when I fill the combo box in the after update event, but only for two values(look the code), to open a form –frmthromvolytika –and find the specified...
  7. J

    A new record with existing data

    You suggest me to make two tables and forms. This is difficult because I must change the whole design of the database.
  8. J

    A new record with existing data

    Hello, I have a form with this fields: patientID( primary key,autonumber) cardcode,Pname,surname,age, address,phone,insertdate,sex. I want when a patient is coming for second time and filling the "cardcode" ,Access to check and have a message like this o you want to make a record with this...
Back
Top Bottom