Welcome to SPN

Register and Join the most happening forum of Sikh community & intellectuals from around the world.

Sign Up Now!

One More Mistery

Discussion in 'Information Technology' started by Ben, Jul 28, 2006.

Tags:
  1. Ben

    Ben
    Expand Collapse
    Guest

    In my access database I have an overview page where I have some totals.

    The overview takes the information on some subforms and shows just the
    result.
    This works great except that on some computers, one of them doesn't count.

    Computer 1:
    Booked: 15 (Expression : =nnz([Booking Yes].[Formulär]![Text26]) )
    Interviewed : 14 (Expression : =nnz([Interviewed yes].Formulär!Text26)

    Computer 2:
    Booked: 15 (Expression : =nnz([Booking Yes].[Formulär]![Text26]) )
    Interviewed : 0 (Expression : =nnz([Interviewed yes].Formulär!Text26)

    As you see, nothing changed except for the result...
    How can that be ?
     
  2. Loading...


  3. OP
    Larry G.

    Larry G.
    Expand Collapse
    Guest

    Are you using a FE and a BE database, the obvious solution is that the data
    is changed on one computer but not the other.
    --
    Never give up, the answer IS out there, it just takes a while to find it
    sometimes!


    "Ben" wrote:

    > In my access database I have an overview page where I have some totals.
    >
    > The overview takes the information on some subforms and shows just the
    > result.
    > This works great except that on some computers, one of them doesn't count.
    >
    > Computer 1:
    > Booked: 15 (Expression : =nnz([Booking Yes].[Formulär]![Text26]) )
    > Interviewed : 14 (Expression : =nnz([Interviewed yes].Formulär!Text26)
    >
    > Computer 2:
    > Booked: 15 (Expression : =nnz([Booking Yes].[Formulär]![Text26]) )
    > Interviewed : 0 (Expression : =nnz([Interviewed yes].Formulär!Text26)
    >
    > As you see, nothing changed except for the result...
    > How can that be ?
    >
     
  4. OP
    Ben

    Ben
    Expand Collapse
    Guest

    Yes, I am using FE and BE.

    The weird thing is that this is just a record counter and that users cannot
    change anything on that.
    I think I checked all details and there is absolutely no difference.
    One of the users has an older windows version could it be something like
    that... or an installation that was incomplete, or ...???




    --
    Novice


    "Larry G." wrote:

    > Are you using a FE and a BE database, the obvious solution is that the data
    > is changed on one computer but not the other.
    > --
    > Never give up, the answer IS out there, it just takes a while to find it
    > sometimes!
    >
    >
    > "Ben" wrote:
    >
    > > In my access database I have an overview page where I have some totals.
    > >
    > > The overview takes the information on some subforms and shows just the
    > > result.
    > > This works great except that on some computers, one of them doesn't count.
    > >
    > > Computer 1:
    > > Booked: 15 (Expression : =nnz([Booking Yes].[Formulär]![Text26]) )
    > > Interviewed : 14 (Expression : =nnz([Interviewed yes].Formulär!Text26)
    > >
    > > Computer 2:
    > > Booked: 15 (Expression : =nnz([Booking Yes].[Formulär]![Text26]) )
    > > Interviewed : 0 (Expression : =nnz([Interviewed yes].Formulär!Text26)
    > >
    > > As you see, nothing changed except for the result...
    > > How can that be ?
    > >
     
  5. OP
    Ben

    Ben
    Expand Collapse
    Guest

    Ok, seems like some more stuff are not working either.
    The conditional formatting doesn't seem to work on those computers either.

    There must be something wrong in the Access installation or Windows
    things... anyone knows how to check this?


    --
    Novice


    "Ben" wrote:

    > In my access database I have an overview page where I have some totals.
    >
    > The overview takes the information on some subforms and shows just the
    > result.
    > This works great except that on some computers, one of them doesn't count.
    >
    > Computer 1:
    > Booked: 15 (Expression : =nnz([Booking Yes].[Formulär]![Text26]) )
    > Interviewed : 14 (Expression : =nnz([Interviewed yes].Formulär!Text26)
    >
    > Computer 2:
    > Booked: 15 (Expression : =nnz([Booking Yes].[Formulär]![Text26]) )
    > Interviewed : 0 (Expression : =nnz([Interviewed yes].Formulär!Text26)
    >
    > As you see, nothing changed except for the result...
    > How can that be ?
    >
     
Since you're here... we have a small favor to ask...     Become a Supporter      ::     Make a Contribution     


Share This Page