Results 1 to 3 of 3
  1. #1
    Join Date
    Apr 2005
    Posts
    11

    Unanswered: Can't edit ConfigF text through a form

    I'm trying to edit the data in the ConfigF Text box in my form but I can't. I need to make the configF editable and be able to pull Monday thru Sunday. This is the procedure I have.

    ALTER PROCEDURE test
    (@v_acid int = '201')
    AS SELECT DISTINCT
    s.id,
    a.tailnum,
    s.sched,
    s.dadate,
    s.config,
    f.config AS configF,
    f.acid,
    DATENAME(dw, s.dadate) AS strdate
    FROM dbo.sched s
    JOIN dbo.aircraft a ON s.acid = a.id
    JOIN dbo.flysheet f ON s.acid = f.acid AND CONVERT(VARCHAR, f.dadate, 101) = CONVERT(VARCHAR, s.dadate, 101)
    --JOIN dbo.flysheet f ON s.acid = f.acid AND DATEDIFF(d, f.dadate, s.dadate) = 0
    WHERE (f.acid = @v_acid)
    ORDER BY s.dadate

    This is how the data is being pulled:

    id tailnum sched dadate config configF acid strdate
    254046 3816 SP 24-Oct-05 C23FM 201 Monday
    254048 3816 SP 26-Oct-05 C20FM 201 Wednesday
    254049 3816 FLY 27-Oct-05 C20FM 201 Thursday
    254050 3816 FLY 28-Oct-05 C20FM 201 Friday

    Here is how the data should be pulled and allowing me to edit the data through a form:

    id tailnum sched dadate configF config acid strdate
    254046 3816 SP 24-Oct-05 C23FM 201 Monday
    254047 3816 WA 25-Oct-05 C20F 201 Tuesday
    254048 3816 SP 26-Oct-05 C20FM 201 Wednesday
    254049 3816 FLY 27-Oct-05 C20FM 201 Thursday
    254050 3816 FLY 28-Oct-05 C20FM 201 Friday
    254051 3816 29-Oct-05 201 Saturday
    254052 3816 30-Oct-05 201 Sunday

  2. #2
    Join Date
    Nov 2003
    Location
    Christchurch, New Zealand
    Posts
    1,618
    [code]
    ALTER PROCEDURE test
    (@v_acid int = '201')
    AS SELECT DISTINCT
    s.id,
    a.tailnum,
    s.sched,
    s.dadate,
    s.config,
    f.config AS configF,
    f.acid,
    DATENAME(dw, s.dadate) AS strdate
    FROM dbo.sched s
    JOIN dbo.aircraft a ON s.acid = a.id
    LEFT JOIN dbo.flysheet f ON s.acid = f.acid AND CONVERT(VARCHAR, f.dadate, 101) = CONVERT(VARCHAR, s.dadate, 101)
    --JOIN dbo.flysheet f ON s.acid = f.acid AND DATEDIFF(d, f.dadate, s.dadate) = 0
    WHERE (f.acid = @v_acid)
    ORDER BY s.dadate
    [code]
    I believe this should bring back all your records...

    As for the editing you really need to give us more information about what you are actually doing for your editing....

  3. #3
    Join Date
    Apr 2005
    Posts
    11

    Can't edit info in Form

    No it didn't work. It's only pulling information that ConfigF has, not everyday of the week or config. I know the problem is with configF since it is really config and just creating a new column name (configF) from it. I've tried every join there is and I still can't get it to pull everyday of the week and edit the configF data. The only way I can do this is through the table but my controllers need to edit it through the form in access.

Posting Permissions

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