Results 1 to 1 of 1
  1. #1
    Join Date
    Feb 2012

    Unanswered: Unable to requery subform

    Hello Guys,
    I am Oracle Database administrator, however i am unable to administrate access database
    All i want is to SELECT (FNAME, SNAME, LNAME and EGN) in the SubForm based on that script:

    SELECT Students.FName, Students.SName, Students.LName, Students.EGN
    FROM T1_Specialnost INNER JOIN (T1_Period INNER JOIN (T1_Groups INNER JOIN Students ON T1_Groups.Group_ID = Students.Group_ID) ON T1_Period.Period_ID = Students.Period_ID) ON T1_Specialnost.Spec_ID = Students.Spec_ID
    WHERE (((T1_Specialnost.SpecName)=[Forms]![Start]![Combo0]) AND ((T1_Groups.GroupName)=[Forms]![Start]![Combo2]) AND ((T1_Period.PeriodDate)<=[Forms]![Start]![Combo6]));

    I have tried to edit the SQL script like this:

    SELECT Students.FName, Students.SName, Students.LName, Students.EGN
    FROM Students
    INNER JOIN T1_Period ON Students.Period_ID=T1_Period.Period_ID
    INNER JOIN T1_Specialnost ON Students.Spec_ID=T1_Specialnost.Spec_ID
    INNER JOIN T1_Groups ON Students.Group_ID=T1_Groups.Group_ID
    WHERE T1_Specialnost.SpecName=[Forms]![Start]![Combo0]
    And T1_Groups.GroupName=[Forms]![Start]![Combo2]
    And [Forms]![Start]![Combo6]>=T1_Period.PeriodDate;

    ...however the engine of access is not agree with me

    Also i am unable to requery to subform even when your comments and Access wizard query.
    Could you help me please ?
    Attached Files Attached Files

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts